| From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
|---|---|
| To: | "Ed L(dot)" <pgsql(at)bluepolka(dot)net>, Flower Sun <sun_2002_flower(at)yahoo(dot)com>, Pgsql Group <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: system table backup strategy |
| Date: | 2003-03-21 00:01:49 |
| Message-ID: | 20030321000149.9997F103C2@polaris.pinpointresearch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)postgresql(dot)org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Doug McNaught | 2003-03-21 00:02:52 | Re: Multiple backend connections |
| Previous Message | Ed L. | 2003-03-20 23:57:34 | Re: fieldwidths |