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 |
Thread: | |
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 | Date | Subject | |
---|---|---|---|
Next Message | Mike G. | 2004-12-22 03:42:51 | Re: postmaster won't start after 'kill -9' |
토토 캔 : PSQL EMACS/Cygwin | David Liu | 2004-12-20 23:42:56 | psql hang in emacs/cygwin bash (postgresql-7.4.5) |