system table backup strategy
Hi, all,
What's the best way to backup system tables? Are system tables belong to template1 database?
Thank you,
Jing
---------------------------------
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
On Thursday March 20 2003 3:55, Flower Sun wrote:
What's the best way to backup system tables? Are system tables belong to
template1 database?
Just use pg_dump and it'll backup what needs to be backed up.
Ed
Read through the man pages for pg_dump AND pg_dumpall then try each of them.
Run a couple of tests and read the output (it's just text psql commands) to
be sure you are getting what you want.
Cheers,
Steve
Show quoted text
On Thursday 20 March 2003 3:53 pm, Ed L. wrote:
On Thursday March 20 2003 3:55, Flower Sun wrote:
What's the best way to backup system tables? Are system tables belong to
template1 database?Just use pg_dump and it'll backup what needs to be backed up.
Ed
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
While the system is hot and being accessed?
Ed L. wrote:
Show quoted text
On Thursday March 20 2003 3:55, Flower Sun wrote:
What's the best way to backup system tables? Are system tables belong to
template1 database?Just use pg_dump and it'll backup what needs to be backed up.
Ed
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
On Thursday March 20 2003 5:13, you wrote:
Ed L. wrote:
On Thursday March 20 2003 3:55, Flower Sun wrote:
What's the best way to backup system tables? Are system tables belong
to template1 database?Just use pg_dump and it'll backup what needs to be backed up.
While the system is hot and being accessed?
Yes.