Josh Moore wrote: > 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, > > 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 Josh, that just looks like the proper shutdown messages. Try starting it by hand with pg_ctl as the postgres user: pg_ctl -D /path/to/data/dir start and see if it outputs anything useful to the console. -- Jeff Frost, Owner <jeff@xxxxxxxxxxxxxxxxxxxxxx> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 916-647-6411 FAX: 916-405-4032 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
