Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id B6C6363281D
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sun,  8 Feb 2009 18:53:29 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 28292-05 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sun,  8 Feb 2009 18:53:26 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from rn-out-0910.google.com (rn-out-0910.google.com
 [64.233.170.190])
	by mail.postgresql.org (Postfix) with ESMTP id 85013632800
	for <pgsql-admin@postgresql.org>; Sun,  8 Feb 2009 18:53:26 -0400 (AST)
Received: by rn-out-0910.google.com with SMTP id k43so1114468rnd.0
	for <pgsql-admin@postgresql.org>; Sun, 08 Feb 2009 14:53:25 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:date:message-id:subject
	:from:to:content-type;
	bh=AOE13guMkm4/agLeDGvelBMb0xh4p4ClgqxtQPp+C+4=;
	b=Er5Lzz3E1eEnQnoA4nObbnU5JpEQxyeLFlj1QbQWdr6zpizJZ6ERVNPNdEidhwubgL
	FfMFwnx43OsotOW8h/WSxLbb6yfLz9BF4GVGz7DA0MHFq2M0CL1ljigEWywSxIqje9nU
	Cs8O3CCP3+25rR+RN2PnmT1dQEwVTnraA2CPc=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type;
	b=vMnotJvprPUP8Vwh1d8yt+XTnMciYeATbGyHsAR9qcHVJYMSHNfLwbycrG1ZwV1945
	rbRqVVGdpYPUFsfn+DLsqa6zwS0oqyB7m1qDfszlFGoKqTjDlVjrK68rAA/zVek3fEg0
	0GuxKafrQN0rES+Whj0NtjUXHz00YEm6+e9Ok=
MIME-Version: 1.0
Received: by 10.90.83.2 with SMTP id g2mr1412746agb.69.1234133605147; Sun, 08
	Feb 2009 14:53:25 -0800 (PST)
Date: Mon, 9 Feb 2009 06:53:24 +0800
Message-ID: <fde7e9780902081453i2d8f7fev26ed0e46cca22eea@mail.gmail.com>
Subject: Postgres will no longer startup
From: Josh Moore <joshsmoore@gmail.com>
To: pgsql-admin@postgresql.org
Content-Type: multipart/alternative; boundary=00163628364423e3580462701f8f
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200902/57
X-Sequence-Number: 31278

--00163628364423e3580462701f8f
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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

--00163628364423e3580462701f8f
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<span class="postbody">Hi,<br><br>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,
<br>

<br>
Josh
<br>

<br>

<br>
Log:
<br>
root@(none):~# tail -f -n10 /var/log/postgresql/postgresql-8.3-main.log 
<br>
2009-01-21 16:58:29 UTC LOG:  unexpected EOF on client connection
<br>
2009-01-21 16:58:29 UTC LOG:  unexpected EOF on client connection
<br>
2009-01-22 11:56:05 UTC LOG:  incomplete startup packet
<br>
2009-01-22 11:56:05 UTC LOG:  received fast shutdown request
<br>
2009-01-22 11:56:05 UTC LOG:  aborting any active transactions
<br>
2009-01-22 11:56:05 UTC FATAL:  terminating connection due to administrator command
<br>
2009-01-22 11:56:05 UTC FATAL:  terminating connection due to administrator command
<br>
2009-01-22 11:56:05 UTC LOG:  autovacuum launcher shutting down
<br>
2009-01-22 11:56:05 UTC LOG:  shutting down
<br>
2009-01-22 11:56:05 UTC LOG:  database system is shut down</span>

--00163628364423e3580462701f8f--