Postgres will no longer startup
| От | Josh Moore |
|---|---|
| Тема | Postgres will no longer startup |
| Дата | |
| Msg-id | fde7e9780902081453i2d8f7fev26ed0e46cca22eea@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Postgres will no longer startup
|
| Список | pgsql-admin |
Hi,
I am using an ubuntu 8.10 installation (from linode). I installed postgres and it was working fine. Then it shutdown and would not start again. When I tried to start it again I got a perl error saying that the locales where not set correctly. I fixed that and then it said that no postgres client was installed so I installed psql. Now when I execute /etc/init.d/postgresql-8.3 start I get no output to the logs or the console, it just returns. I will post the last sever lines of the log below. Does anybody know what problem this is and why I started to have it? Thanks,
Josh
Log:
root@(none):~# tail -f -n10 /var/log/postgresql/postgresql-8.3-main.log
2009-01-21 16:58:29 UTC LOG: unexpected EOF on client connection
2009-01-21 16:58:29 UTC LOG: unexpected EOF on client connection
2009-01-22 11:56:05 UTC LOG: incomplete startup packet
2009-01-22 11:56:05 UTC LOG: received fast shutdown request
2009-01-22 11:56:05 UTC LOG: aborting any active transactions
2009-01-22 11:56:05 UTC FATAL: terminating connection due to administrator command
2009-01-22 11:56:05 UTC FATAL: terminating connection due to administrator command
2009-01-22 11:56:05 UTC LOG: autovacuum launcher shutting down
2009-01-22 11:56:05 UTC LOG: shutting down
2009-01-22 11:56:05 UTC LOG: database system is shut down
I am using an ubuntu 8.10 installation (from linode). I installed postgres and it was working fine. Then it shutdown and would not start again. When I tried to start it again I got a perl error saying that the locales where not set correctly. I fixed that and then it said that no postgres client was installed so I installed psql. Now when I execute /etc/init.d/postgresql-8.3 start I get no output to the logs or the console, it just returns. I will post the last sever lines of the log below. Does anybody know what problem this is and why I started to have it? Thanks,
Josh
Log:
root@(none):~# tail -f -n10 /var/log/postgresql/postgresql-8.3-main.log
2009-01-21 16:58:29 UTC LOG: unexpected EOF on client connection
2009-01-21 16:58:29 UTC LOG: unexpected EOF on client connection
2009-01-22 11:56:05 UTC LOG: incomplete startup packet
2009-01-22 11:56:05 UTC LOG: received fast shutdown request
2009-01-22 11:56:05 UTC LOG: aborting any active transactions
2009-01-22 11:56:05 UTC FATAL: terminating connection due to administrator command
2009-01-22 11:56:05 UTC FATAL: terminating connection due to administrator command
2009-01-22 11:56:05 UTC LOG: autovacuum launcher shutting down
2009-01-22 11:56:05 UTC LOG: shutting down
2009-01-22 11:56:05 UTC LOG: database system is shut down
В списке pgsql-admin по дате отправления: