Thread: How do dump server wide configuration?
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?
--
Ron Watkins, K7DOG
602.743.5272
602.743.5272
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
Hi,
You can use pg_dumpall. This will create a complete dump of all databases along with the global objects.
You can use pg_dumpall. This will create a complete dump of all databases along with the global objects.
On Mon, 21 Oct 2024 at 23:22, Ron Watkins <rwatki@gmail.com> 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?--Ron Watkins, K7DOG
602.743.5272