| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Kay-Uwe Michaelis <kum(at)kumichaelis(dot)de> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to rebuild tables |
| Date: | 2002-05-31 14:29:57 |
| Message-ID: | 17891.1022855397@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Kay-Uwe Michaelis <kum(at)kumichaelis(dot)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 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Bartunov | 2002-05-31 14:38:47 | Re: PostgreSQL search engine (Perl) |
| Previous Message | Marc G. Fournier | 2002-05-31 14:25:16 | Re: PostgreSQL search engine (Perl) |