Re: Help, server doesn't start
| От | Anibal David Acosta |
|---|---|
| Тема | Re: Help, server doesn't start |
| Дата | |
| Msg-id | 007e01cd528c$99e197d0$cda4c770$@devshock.com обсуждение исходный текст |
| Ответ на | Re: Help, server doesn't start (Raghavendra <raghavendra.rao@enterprisedb.com>) |
| Ответы |
Re: Help, server doesn't start
(Raghavendra <raghavendra.rao@enterprisedb.com>)
Re: Help, server doesn't start (Craig Ringer <ringerc@ringerc.id.au>) |
| Список | pgsql-general |
Yes, we must upgrade.
The value of the shared_preload_libraries is
shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll' # (change requires restart)
An additional information….
When I login into the server the disk used by Postgres installation was without space (0Bytes available).
Also is possible that someone (I am checking now) restart the Postgres service in the middle of this situation
Right now I am making a file-level copy of the entire postgres folder in order to run some corruption recover method
Thanks!
De: Raghavendra [mailto:raghavendra.rao@enterprisedb.com]
Enviado el: lunes, 25 de junio de 2012 12:31 a.m.
Para: Anibal David Acosta
CC: pgsql-general@postgresql.org
Asunto: Re: [GENERAL] Help, server doesn't start
On Mon, Jun 25, 2012 at 8:23 AM, Anibal David Acosta <aa@devshock.com> wrote:
We have an old postgres installation (8.3) running on windows 2003
The server run perfect for many years but today it crash L
We have a very old backup so I’ll try desperate to repair.
If I can’t repair I want to skip the error and start server with only healthy data, no matter if I lose some table page, entire table or even entire database because the server has many databases inside.
Side-by, you should also consider upgrading PG versions to latest.
Currently the database is not starting, when I try to start I got the in the log:
2012-06-25 02:22:33 GMT LOG: database system was interrupted while in recovery at 2012-06-25 02:22:26 GMT
2012-06-25 02:22:33 GMT HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
2012-06-25 02:22:33 GMT LOG: database system was not properly shut down; automatic recovery in progress
2012-06-25 02:22:33 GMT LOG: redo starts at 17C/E1C42040
2012-06-25 02:22:33 GMT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2012-06-25 02:22:33 GMT FATAL: the database system is starting up
[LAST TWO LINES REPEAT MANY TIMES]
2012-06-25 02:22:36 GMT LOG: startup process (PID 1120) was terminated by exception 0xC000000D
2012-06-25 02:22:36 GMT HINT: See C include file "ntstatus.h" for a description of the hexadecimal value.
2012-06-25 02:22:36 GMT LOG: aborting startup due to startup process failure
2012-06-25 02:22:36 GMT FATAL: the database system is starting up
2012-06-25 02:22:36 GMT LOG: loaded library "$libdir/plugins/plugin_debugger.dll"
2012-06-25 02:22:36 GMT FATAL: the database system is starting up
Can you also paste whats there in shared_preload_libraries setting from $PGDATA/postgresql.conf ?
---
В списке pgsql-general по дате отправления: