public inbox for [email protected]help / color / mirror / Atom feed
How 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]> 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:26 Joe Conway <[email protected]> parent: Ron Watkins <[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-22 03:57 Muhammad Usman Khan <[email protected]> parent: Ron Watkins <[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