Backup pg_shadow 
Author Message
 Backup pg_shadow
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");

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



Mon, 20 Sep 2004 02:14:24 GMT
 Backup pg_shadow

Quote:

> 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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



Mon, 20 Sep 2004 04:32:18 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Encrypting pg_shadow passwords

2. PG_PWD and PG_SHADOW

3. oops Re: Encrypting pg_shadow passwords

4. passwords in pg_shadow (duplicate).

5. cannot read block 0 of pg_shadow

6. Encrypting pg_shadow passwords

7. alter table pg_shadow

8. Encrypting pg_shadow passwords

9. pg_shadow prob solved

10. alter user to change user's password returns pg_shadow: Permission

11. pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!!

12. Proposal for encrypting pg_shadow passwords


 
Powered by phpBB® Forum Software