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

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

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