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