How to rebuild tables

On Fri, May 31, 2002 at 07:47:40AM +0200, Kay-Uwe Michaelis wrote:

Hello list,

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).

What should i do to recover these databases.
Is there a tool to use the old tables in the new database.
Why doen't work postgresql with these PGDATA-directory ?

Well, you should create the db, then copy the files. Then you need to hope
the pg_xlog directory backed up too. if not, there is some kind of reset log
somewhere which may allow you to read it. but it's still dodgy.

--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/

Search the documentation does not work right now:

Warning: Unable to connect to PostgreSQL server: connectDBStart() --
connect() failed: Connection refused Is the postmaster running (with -i) at
'db.postgresql.org' and accepting connections on TCP/IP port 5432? in
/usr/local/www/www/idocs/opendb.php on line 3
Unable to access database

--
Kaare Rasmussen --Linux, spil,-- Tlf: 3816 2582
Kaki Data tshirts, merchandize Fax: 3816 2501
Howitzvej 75 �ben 14.00-18.00 Web: www.suse.dk
2000 Frederiksberg L�rdag 11.00-17.00 Email: kar@kakidata.dk

Search the documentation does not work right now:

What I was trying to find was information about full text indexing.

It's supposed to be used in a search engine. But maybe someone knows a
search engine in Perl optimized for PostgreSQL?

One that works ? ;-)

--
Kaare Rasmussen --Linux, spil,-- Tlf: 3816 2582
Kaki Data tshirts, merchandize Fax: 3816 2501
Howitzvej 75 �ben 14.00-18.00 Web: www.suse.dk
2000 Frederiksberg L�rdag 11.00-17.00 Email: kar@kakidata.dk

try archives.postgresql.org?

On Fri, 31 May 2002, Kaare Rasmussen wrote:

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 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

See:

http://www.postgresql.org/idocs/index.php?runtime-config.html

On Fri, 31 May 2002, Kaare Rasmussen wrote: