From: | "Anton Maksimenkov" <anton200(at)gmail(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: db crash after power crash |
Date: | 2006-05-28 18:32:17 |
Message-ID: | 8cac8dd0605281132p64099b75jff38f5e779d86ab9@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
May I ask - how can I do it...? My ordinary startup command (from
rc.local) like this
# su -l _postgresql -c "nohup /usr/local/bin/pg_ctl start -D
/var/postgresql/data -l /var/postgresql/logfile -o '-D
/var/postgresql/data'"
But I tried
# su -l _postgresql
$ postgres -D /var/postgresql/data/ -P billing
FATAL: catalog is missing 1 attribute(s) for relid 2662
Anyhow, after all it is completely refuse to log me on. After shutting
down and ordinary startup the RDBMS:
$ export PGOPTIONS="-P"
$ psql -d billing
Password:
psql: FATAL: catalog is missing 1 attribute(s) for relid 2662
$ unset PGOPTIONS
$ psql -d billing
Password:
psql: FATAL: catalog is missing 1 attribute(s) for relid 2662
I think I broke something while experimenting with feeding -P to my
ordinary startup string...
--
engineer
From | Date | Subject | |
---|---|---|---|
Next Message | Devrim GUNDUZ | 2006-05-28 19:25:37 | Re: Binary Packages |
Previous Message | Michael Ben-Nes | 2006-05-28 18:00:33 | The server's LC_CTYPE locale |