Thread: Backup pg_shadow

Backup pg_shadow

From
"Gaetano Mendola"
Date:
How can I easily backup the table pg_shadow
or at least how can I backup the data about the users of
the DB?


Ciao
Gaetano

--
#exclude <windows>
#include <CSRSS>
printf("\t\t\b\b\b\b\b\b");.
printf("\t\t\b\b\b\b\b\b");


Re: Backup pg_shadow

From
Tom Lane
Date:
"Gaetano Mendola" <mendola@bigfoot.com> writes:
> How can I easily backup the table pg_shadow
> or at least how can I backup the data about the users of
> the DB?

See pg_dumpall.

            regards, tom lane