Re: Forgot to dump old data before re-installing machine

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Stefan Schwarzer <stefan(dot)schwarzer(at)grid(dot)unep(dot)ch>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: Forgot to dump old data before re-installing machine
Date: 2008-01-24 16:42:06
Message-ID: 20080124164206.GC21323@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-patches

On Thu, Jan 24, 2008 at 05:10:51PM +0100, Stefan Schwarzer wrote:
> Oh, stupid me! Gush, I'll never learn it...
>
> But nevertheless:
>
> When I start the postmaster it seems ok. But there is no process
> running. When I try to stop it it says:
>
> pg_ctl: PID file "/usr/local/pgsql/data/postmaster.pid" does not exist
> Is postmaster running?

If it fails to start it must log somehwere.

If you run the postmaster directly from the console it'll get you into
singleuser mode, try that.

(PS. Have you tried pgfsck on the new machine. With the same byte-order
it should work much betteR).

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brian A. Seklecki (Mobile) 2008-01-24 16:43:26 PostgreSQL/PHP Application Server
Previous Message Wes 2008-01-24 16:41:46 REINDEX on large DB vs. DROP INDEX/CREATE INDEX

Browse pgsql-patches by date

  From Date Subject
Next Message Martijn van Oosterhout 2008-01-24 19:27:13 Re: Forgot to dump old data before re-installing machine
Previous Message Stefan Schwarzer 2008-01-24 16:41:20 Re: Forgot to dump old data before re-installing machine