Re: How to rebuild tables - Mailing list pgsql-general

From Tom Lane
Subject Re: How to rebuild tables
Date
Msg-id 17891.1022855397@sss.pgh.pa.us
Whole thread Raw
In response to How to rebuild tables  (Kay-Uwe Michaelis <kum@kumichaelis.de>)
List pgsql-general
Kay-Uwe Michaelis <kum@kumichaelis.de> writes:
> a few days ago my HD crashed. Unfortunally i have only a copy of the PGDATA-directory, no pg_dump-file. I installed
thesame postgresql-version (6.3.2) on another system (tested it with some test-db/-tables) and then copied the
PGDATA-directoryto that computer, but that wan't work. The postmaster start correct but every frontend-command ends
witherrors (can't find db in pg_database). 

This should work, if you copy the *entire* $PGDATA directory tree.  You
cannot copy just part (the pg_log file has to be in sync with all the data
files).

BTW, 6.3.2 is very ancient history --- you *really* should update.

            regards, tom lane

pgsql-general by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: PostgreSQL search engine (Perl)
Next
From: Oleg Bartunov
Date:
Subject: Re: PostgreSQL search engine (Perl)