Re: Disaster recovery (server died)

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Disaster recovery (server died)
Date: 2009-06-19 21:34:36
Message-ID: 200906191434.36348@hal.medialogik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Friday 19 June 2009, Miguel Miranda <miguel(dot)mirandag(at)gmail(dot)com> 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

Just copy it into place where the new postmaster expects to live.

--
WARNING: Do not look into laser with remaining eye.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Madison Kelly 2009-06-19 21:46:04 Re: Disaster recovery (server died)
Previous Message Todd A. Cook 2009-06-19 20:58:39 Re: FYI: Load times for a largish DB in 8.2 vs. 8.3 vs. 8.4