| From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
|---|---|
| To: | PgSQL General ML <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Backup? |
| Date: | 2003-09-04 22:23:30 |
| Message-ID: | 1062714209.17023.143.camel@haggis |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 2003-09-04 at 15:40, Doug McNaught wrote:
> Bjørn T Johansen <btj(at)havleik(dot)no> writes:
>
> > Should one use pg_dumpall to backup the database or is it more practical
> > to just copy the data directory?
>
> The data directory will not be consistent unless the server is
> stopped. pg_dumpall works well, produces a consistent backup and is
> easily portable to a different machine architecture if need be.
And it's smaller than the data/ directory, especially when "-F c"
option is used.
--
-----------------------------------------------------------------
Ron Johnson, Jr. ron(dot)l(dot)johnson(at)cox(dot)net
Jefferson, LA USA
"The UN couldn't break up a cookie fight in a Brownie meeting."
Larry Miller
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Kellerer | 2003-09-04 22:36:49 | Re: Output from PLPGSQL |
| Previous Message | Richard Ellis | 2003-09-04 22:00:47 | Re: Replaceing records |