Re: File System backup - Mailing list pgsql-general

From itishree sukla
Subject Re: File System backup
Date
Msg-id CAL-g6VT-L2zpu5sVU2sJdBYPHwFujSWx6bkWVKW3BkwYFLiJVA@mail.gmail.com
Whole thread Raw
In response to Re: File System backup  (Amit Langote <amitlangote09@gmail.com>)
Responses Re: File System backup
List pgsql-general
No, as its only one postgresql is running with default installation, server got restatared with out shuting down postgresql service properly. Then i tied to start server using ./init.d command, which didn't help me either. Then i created pstmaster.pid, that also doesn't help me much.
 
Regards,
Itishree

On Fri, Jun 21, 2013 at 6:10 PM, Amit Langote <amitlangote09@gmail.com> wrote:
On Fri, Jun 21, 2013 at 7:53 PM, itishree sukla
<itishree.sukla@gmail.com> wrote:
> Hi all,
>
> Can any one give me more suggestion, about this problem. Every time my os
> got restart, postmaster.pid is missing. After that createing postmaster.pid
> is also not helping to start the server.  I am using postgresql 9.2 in
> ubuntu, with default installation. Is there any possibility i can take the
> Data directory backup, and install postgresql server, then restore Data
> directory. Will it work to get back my databases.

Can you tell what command you use to start the server and when you
issue it? Is that after OS restarts?) Did you, by any chance, use
"restart" whereas you should have used "start" assuming you are using
pg_ctl for the same?

Issuing "restart" requires that you should already have server running
(and that means postmaster.pid should be there in data directory).

--
Amit Langote

pgsql-general by date:

Previous
From: Natalie Wenz
Date:
Subject: type-casting failures
Next
From: Lonni J Friedman
Date:
Subject: 9.3-beta postgres-fdw COPY error