Re: Postgres will no longer startup

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(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 916-647-6411 FAX: 916-405-4032