Re: How do dump server wide configuration?

From: Joe Conway <mail(at)joeconway(dot)com>
To: Ron Watkins <rwatki(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: How do dump server wide configuration?
Date: 2024-10-21 18:26:25
Message-ID: 8db4db2a-550e-4dca-a3d6-15ab9e6116c3@joeconway.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 10/21/24 14:22, Ron Watkins wrote:
> I have been dumping individual databases with the pg_dump command, but a
> issue has come up where user configs and other data stored at the server
> level are not being dumped. Is there a way to dump those data as well?

perhaps:
pg_dumpall -g

https://www.postgresql.org/docs/current/app-pg-dumpall.html

HTH,

--
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2024-10-21 18:31:31 Re: Verify or dump pgdata files
Previous Message Ron Watkins 2024-10-21 18:22:07 How do dump server wide configuration?