| Lists: | pgsql-cygwin |
|---|
| From: | Carlo Florendo <list-subscriber(at)hq(dot)astra(dot)ph> |
|---|---|
| To: | pgsql-cygwin(at)postgresql(dot)org |
| Subject: | postmaster won't start after 'kill -9' |
| Date: | 2004-12-22 00:58:04 |
| Message-ID: | 41C8C69C.8090101@hq.astra.ph |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-cygwin |
Hello,
I mistakenly did a 'kill -9' on postmaster and afterwads, postgresql
won't start anymore. I've deleted everything under pg_xlog and pg_clog
thinking the server would have to start all over again. However, I'm
still not able to run the server.
Here's the transcript of what happens:
$ export CYGWIN=server
$ postmaster -i -D /var/postgresql/data/
WARNING: dup(0) failed after 3195 successes: Bad file descriptor
LOG: database system shutdown was interrupted at 2004-12-09 17:06:57 TST
LOG: could not open file
"/var/postgresql/data/pg_xlog/0000000000000000" (log file 0, segment 0):
No such file or directory
LOG: invalid primary checkpoint record
LOG: could not open file
"/var/postgresql/data/pg_xlog/0000000000000000" (log file 0, segment 0):
No such file or directory
LOG: invalid secondary checkpoint record
PANIC: could not locate a valid checkpoint record
LOG: startup process (PID 1528) was terminated by signal 6
LOG: aborting startup due to startup process failure
I'll be glad for any pointers.
Thanks!
Best Regards,
Carlo
--
Carlo Florendo
Astra Philippines Inc.
www.astra.ph
| From: | "Mike G(dot)" <mike(at)thegodshalls(dot)com> |
|---|---|
| To: | Carlo Florendo <list-subscriber(at)hq(dot)astra(dot)ph> |
| Cc: | pgsql-cygwin(at)postgresql(dot)org |
| Subject: | Re: postmaster won't start after 'kill -9' |
| Date: | 2004-12-22 03:42:51 |
| Message-ID: | 20041222034251.GB10718@thegodshalls.thegodshalls |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-cygwin |
Can you restore the directories you deleted? They really should not have been deleted.
On Wed, Dec 22, 2004 at 08:58:04AM +0800, Carlo Florendo wrote:
> Hello,
>
> I mistakenly did a 'kill -9' on postmaster and afterwads, postgresql
> won't start anymore. I've deleted everything under pg_xlog and pg_clog
> thinking the server would have to start all over again. However, I'm
> still not able to run the server.
>
> Here's the transcript of what happens:
>
> $ export CYGWIN=server
> $ postmaster -i -D /var/postgresql/data/
> WARNING: dup(0) failed after 3195 successes: Bad file descriptor
> LOG: database system shutdown was interrupted at 2004-12-09 17:06:57 TST
> LOG: could not open file
> "/var/postgresql/data/pg_xlog/0000000000000000" (log file 0, segment 0):
> No such file or directory
> LOG: invalid primary checkpoint record
> LOG: could not open file
> "/var/postgresql/data/pg_xlog/0000000000000000" (log file 0, segment 0):
> No such file or directory
> LOG: invalid secondary checkpoint record
> PANIC: could not locate a valid checkpoint record
> LOG: startup process (PID 1528) was terminated by signal 6
> LOG: aborting startup due to startup process failure
>
> I'll be glad for any pointers.
>
> Thanks!
>
> Best Regards,
>
> Carlo
>
> --
> Carlo Florendo
> Astra Philippines Inc.
> www.astra.ph
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend