"Rob Owen" <[EMAIL PROTECTED]> writes:
> PostgreSQL 8.0.3 running on AIX 5.3 (same thing happens on 5.1 though).
> DBMS was running fine for some months but now one of the databases isn't
> accessible. Any help would be greatly appreciated.
Just one database? Sounds like it might be corrupt data in that
database's system catalogs. Can you get a stack trace from the point
of the error to help us narrow it down?
The way I usually debug startup-time failures is:
export PGOPTIONS="-W 30"
psql ...
Now I have 30 seconds to identify the PID of the backend process in
another window and do (as the postgres user)
gdb /path/to/postgres PID
Once you've got gdb control of the backend, do
gdb> break errfinish
gdb> cont
... wait for the timeout to finish elapsing, if needed ... Once
gdb reports that the breakpoint has been reached, say
gdb> bt
... useful info here...
gdb> cont
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
