Re: Copying only incremental records to another DB..

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Cc: Scott Ribe <scott_ribe(at)killerbytes(dot)com>, Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>, PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Copying only incremental records to another DB..
Date: 2009-07-25 15:12:55
Message-ID: 25482.1248534775@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> writes:
> To be clearer: Do you mean that the folder you backed up is the folder
> with the file "PG_VERSION" in it, and all its contents?

Careful --- there are multiple PG_VERSION files scattered around in a
Postgres data directory tree. Your comment is correct with respect
to the topmost one, but I'm not certain it's a foolproof definition
of "the data directory".

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-07-25 15:43:06 Re: FATAL: root page 3 of "pg_class_oid_index" has level 0, expected 1
Previous Message APseudoUtopia 2009-07-25 15:05:23 Server/Client Encoding Errors