Re: Disaster recovery (server died)

[Miguel Miranda <miguel.mirandag@xxxxxxxxx>]

Well, i just didnt explain in detail, what i have is just the 16897 directory where i was storing the database, i tried just copying the files but it didnt work, 
should it be posible to import this database is any way?

the Os is Freebsd 6.2 and PG version is 8.1.3
thank you.

On Fri, Jun 19, 2009 at 3:46 PM, Madison Kelly <linux@xxxxxxxxxxx> wrote:

Miguel Miranda wrote:

Hi, the worst have ocurred, my server died (cpu), so i reinstalled another server with the same postgres version.
I have the old data directory from the old server, how can i restore my databases from this directory to the new one?
I dont have a backup (pg_dump,etc), just the main previus live data directory from the old server.
best regards

First, make a copy. DO NOT USE your backup until done. :)

Now then, assumin *nix;

stop the postgresql daemon, copy the data directories into place and restart the daemon. Be sure to restore your config files like pg_hba.conf and such while the daemon is stopped.

If your backup is in a consistent (or recoverable) state, you should be golden. For more specific instructions, post your OS and PgSQL versions.

Best of luck!

Madi