Re: Restore database from files (not dump files)?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: wheel <wheel(at)wheel(dot)not>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Restore database from files (not dump files)?
Date: 2006-12-12 15:16:52
Message-ID: 2785.1165936612@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

wheel <wheel(at)wheel(dot)not> writes:
> I guess the reason is that the pg system database etc are lodged in the
> hive under \base\, and the system db contains the metadata about the db
> to be restored?

No, the reason why selective restore doesn't work is that all tables in
a database cluster depend on the same commit log (pg_clog) to determine
which rows are valid and which are not. What you were trying to do is
described in the manual (with a warning not to do it) under
backup/restore procedures:
http://www.postgresql.org/docs/8.2/static/backup-file.html

Also, if you would like to know more about the physical layout of the
database contents, it's described here:
http://www.postgresql.org/docs/8.2/static/storage.html

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Chernow 2006-12-12 15:25:09 PostgreSQL Developer Full-time Position
Previous Message Richard Huxton 2006-12-12 15:08:24 Re: search_path when restoring to new db