Re: Backup pg_shadow

Lists: pgsql-admin
From: "Gaetano Mendola" <mendola(at)bigfoot(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Backup pg_shadow
Date: 2002-04-03 17:40:49
Message-ID: 012401c1db36$b16619e0$5ce8fea9@GMENDOLA2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

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");

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gaetano Mendola" <mendola(at)bigfoot(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Backup pg_shadow
Date: 2002-04-03 19:58:22
Message-ID: 11988.1017863902@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

"Gaetano Mendola" <mendola(at)bigfoot(dot)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