Kay-Uwe Michaelis <kum@xxxxxxxxxxxxxx> writes:
> a few days ago my HD crashed. Unfortunally i have only a copy of the
> PGDATA-directory, no pg_dump-file. I installed the same postgresql-version
> (6.3.2) on another system (tested it with some test-db/-tables) and then
> copied the PGDATA-directory to that computer, but that wan't work. The
> postmaster start correct but every frontend-command ends with errors (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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
|
