MIME-Version: 1.0
References: 
 <CAPdrarqMm9c4M9G5CvNAWM3oo-cyBe4SHLQhCsP_rf8CYN16qA@mail.gmail.com>
In-Reply-To: 
 <CAPdrarqMm9c4M9G5CvNAWM3oo-cyBe4SHLQhCsP_rf8CYN16qA@mail.gmail.com>
From: Muhammad Usman Khan <usman.k@bitnine.net>
Date: Tue, 22 Oct 2024 08:57:04 +0500
Message-ID: 
 <CAPnRvGsoqXUBKWoo_qrsObb_aDq+wW54Sg3Dm4enapnkzW2nqA@mail.gmail.com>
Subject: Re: How do dump server wide configuration?
To: Ron Watkins <rwatki@gmail.com>
Cc: pgsql-admin@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000d266cd062508c3b7"
Archived-At: 
 <https://www.postgresql.org/message-id/CAPnRvGsoqXUBKWoo_qrsObb_aDq%2BwW54Sg3Dm4enapnkzW2nqA%40mail.gmail.com>
Precedence: bulk

--000000000000d266cd062508c3b7
Content-Type: text/plain; charset="UTF-8"

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 <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
>

--000000000000d266cd062508c3b7
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi,<br>You can use pg_dumpall. This will create a complete=
 dump of all databases along with the global objects.</div><br><div class=
=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, 21 Oct 2024 =
at 23:22, Ron Watkins &lt;<a href=3D"mailto:rwatki@gmail.com">rwatki@gmail.=
com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"marg=
in:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1e=
x"><div dir=3D"ltr">I have been dumping individual databases with the pg_du=
mp command, but a issue has come up where user configs and other data store=
d at the server level are not being dumped. Is there a way to dump those da=
ta as well?<br clear=3D"all"><div><br></div><span class=3D"gmail_signature_=
prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=
=3D"ltr"><div>Ron Watkins, K7DOG<br>602.743.5272</div></div></div></div>
</blockquote></div>

--000000000000d266cd062508c3b7--