pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres will no longer startup
2+ messages / 2 participants
[nested] [flat]
* Postgres will no longer startup
@ 2009-02-08 22:53 Josh Moore <joshsmoore@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Josh Moore @ 2009-02-08 22:53 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Postgres will no longer startup
@ 2009-02-08 23:41 Jeff Frost <jeff@frostconsultingllc.com>
parent: Josh Moore <joshsmoore@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Jeff Frost @ 2009-02-08 23:41 UTC (permalink / raw)
To: Josh Moore <joshsmoore@gmail.com>; +Cc: pgsql-admin
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@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 916-647-6411 FAX: 916-405-4032
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2009-02-08 23:41 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-02-08 22:53 Postgres will no longer startup Josh Moore <joshsmoore@gmail.com>
2009-02-08 23:41 ` Jeff Frost <jeff@frostconsultingllc.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox