From: | Halford Dace <hal(at)stowe(dot)co(dot)za> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Help! System catalogs vanished! |
Date: | 2001-12-07 12:02:16 |
Message-ID: | 3C10AFC8.1090903@stowe.co.za |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi there,
I'm having a just wonderful Friday at work. Not.
At around 2am this morning, probably in the middle of the nightly
scheduled VACUUM ANALYZE, the UPS on my server failed.
This morning, I have no databases.
The details:
PostgreSQL 7.0.3 on IRIX 6.5.11m.
When I started the machine this morning, I couldn't start the postmaster
with pg_ctl at all. Firstly it claimed there was another postmaster
running (there wasn't) and then when I removed the postmaster.pid file,
pg_ctl just said it couldn't execute postmaster.
When I started postmaster by hand with:
/usr/freeware/bin/postmaster -D /usr/data/pgsql -o "-i -S"
it started BUT now watch this:
jove bin$ psql stowe3
Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
stowe3=> \d
stowe3=> \dS
stowe3=> select now();
stowe3=> select version();
stowe3=>
This is, to my mind, extremely unhealthy. To my customers' minds too for
that matter.
The behaviour is the same no matter which of the 8 databases I connect
to. Also, I don't know if it's relevant, but all of them have pg_table
files of zero length.
SO, I really need to sort this out pronto-urgently.
If I can't do anything to restore them within the next few hours, I'll
have to do a fresh initdb and start restoring and reconstructing.
Frankly though, I'd much rather have a weekend.
*sigh*
Hal
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-12-07 15:16:55 | Re: duplicate templates, wrong users |
Previous Message | Armin Barth | 2001-12-07 05:45:40 | What is "libpq.so.2.1 ? |