Re: postmaster does not come up

From: Jeffrey Webster <icwebby(at)gmail(dot)com>
To: "surabhi(dot)ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: postmaster does not come up
Date: 2005-12-05 10:27:16
Message-ID: 8c0cc2820512050227h4e5f9842r86798ffd75ebe22f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This is a little vague...

There is a way to recover the data. Make postmaster come back up. Unless
you're talking about postmaster not coming up due to corrupted data files,
or a hardware failure.

You do need to use pg_dump at regular intervals. It is common practice to
back up data, after all.

Now, instead of being vague, let's see if you can't give us a bit more
information about why your postmaster is failing to start. Have you tried
starting it manually? For example, running postmaster directly from the
command line. Like so:

postmaster -D /usr/local/pgsql/data

Replace "/usr/local/pgsql/data" with the path to your own. If postmaster
fails to come up, what errors/warnings did it report?

On 12/5/05, surabhi.ahuja <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in> wrote:
>
> hi all..
> sometime back i had asked a question
> is ther no way to recove the database in case postmaster fails to come
> up??
>
> i dont remember what was there in the log file ... i had seen it sometime
> back ...for which i dont have the logs
>
> i dint check if by restarting the system the problem would go away?..
>
> do u need to take pg_dump then at regular intervals ?
>
> thanks,
> regards
> Surabhi
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Byrne Kevin-kbyrne01 2005-12-05 10:33:00 ODBC Layer and the now() function
Previous Message Tim Allen 2005-12-05 10:18:35 Re: [ANNOUNCE] == PostgreSQL Weekly News - December 05 2005 ==