Re: db crash after power crash
От | Anton Maksimenkov |
---|---|
Тема | Re: db crash after power crash |
Дата | |
Msg-id | 8cac8dd0605281132p64099b75jff38f5e779d86ab9@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: db crash after power crash (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: db crash after power crash
|
Список | 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
В списке pgsql-general по дате отправления: