Skip site navigation (1) Skip section navigation (2)

Re: problematic upgrade

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jeff Flowers" <duckfoo(at)fastmail(dot)fm>
Cc: "PGSQL-Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: problematic upgrade
Date: 2004-11-29 19:30:37
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
"Jeff Flowers" <duckfoo(at)fastmail(dot)fm> writes:
> I know that there are a few ways to back up a PostgreSQL database but is
> there any one method that is generally recommended above others?

You can either use pg_dump or do filesystem backups *with the postmaster
stopped*.  See the Administrator's Guide:
PG 8.0 will allow a third basic approach, on-line backup:

The "File system level backup" subsection in that chapter explains why
piecemeal copying of data files (which is what I understood Marcin to
say his friend did) doesn't work.  Add to that the issues associated
with a cross-version changeover (such as, usually, changes in system
catalog contents and layout), and I'm amazed that the thing appeared
to work at all.

			regards, tom lane

In response to


pgsql-novice by date

Next:From: Steve TucknottDate: 2004-11-29 21:24:37
Subject: lo_export (server)
Previous:From: Jeff FlowersDate: 2004-11-29 18:45:54
Subject: Re: problematic upgrade

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group