public inbox for [email protected]
help / color / mirror / Atom feedHow do dump server wide configuration?
3+ messages / 3 participants
[nested] [flat]
* How do dump server wide configuration?
@ 2024-10-21 18:22 Ron Watkins <[email protected]>
2024-10-21 18:26 ` Re: How do dump server wide configuration? Joe Conway <[email protected]>
2024-10-22 03:57 ` Re: How do dump server wide configuration? Muhammad Usman Khan <[email protected]>
0 siblings, 2 replies; 3+ messages in thread
From: Ron Watkins @ 2024-10-21 18:22 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How do dump server wide configuration?
2024-10-21 18:22 How do dump server wide configuration? Ron Watkins <[email protected]>
@ 2024-10-21 18:26 ` Joe Conway <[email protected]>
1 sibling, 0 replies; 3+ messages in thread
From: Joe Conway @ 2024-10-21 18:26 UTC (permalink / raw)
To: Ron Watkins <[email protected]>; 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How do dump server wide configuration?
2024-10-21 18:22 How do dump server wide configuration? Ron Watkins <[email protected]>
@ 2024-10-22 03:57 ` Muhammad Usman Khan <[email protected]>
1 sibling, 0 replies; 3+ messages in thread
From: Muhammad Usman Khan @ 2024-10-22 03:57 UTC (permalink / raw)
To: Ron Watkins <[email protected]>; +Cc: pgsql-admin
Hi,
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 <[email protected]> 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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-10-22 03:57 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-10-21 18:22 How do dump server wide configuration? Ron Watkins <[email protected]>
2024-10-21 18:26 ` Joe Conway <[email protected]>
2024-10-22 03:57 ` Muhammad Usman Khan <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox