Postgres Pro
Downloads
Home   >   mailing lists

Thread: posgresql-8.2 startup problem

posgresql-8.2 startup problem

From
novice
Date:
Hi guys,

I just installed postgres-8.2 using the command line
apt-get install postgres-8.2 and it seems the installation went ok,
but when it tries to start postgres , it fails with this error message
below...
(by the way I am running ubuntu fiesty and on an amazon ec2-image).
Any ideas what is wrong?

Regards,
Beat

Setting up postgresql-8.2 (8.2.5-0ubuntu0.7.04.1) ...
 * Starting PostgreSQL 8.2 database
server
* The PostgreSQL server failed to start. Please check the log output:
2007-11-01 14:16:26 CET LOG:  could not load root certificate file
"root.crt": no SSL error reported
2007-11-01 14:16:26 CET DETAIL:  Will not verify client certificates.
2007-11-01 14:16:26 CET LOG:  could not translate host name
"localhost", service "5432" to address: Name or service not known
2007-11-01 14:16:26 CET WARNING:  could not create listen socket for
"localhost"
2007-11-01 14:16:26 CET FATAL:  could not create any TCP/IP sockets

[fail]
invoke-rc.d: initscript postgresql-8.2, action "start" failed.
dpkg: error processing postgresql-8.2 (--configure):
 subprocess post-installation script returned error exit status 1
Errors were encountered while processing:
 postgresql-8.2
E: Sub-process /usr/bin/dpkg returned an error code (1)

Re: posgresql-8.2 startup problem

From
Tom Lane
Date:
novice <BeatDream@gmail.com> writes:
> I just installed postgres-8.2 using the command line
> apt-get install postgres-8.2 and it seems the installation went ok,
> but when it tries to start postgres , it fails with this error message
> below...
> (by the way I am running ubuntu fiesty and on an amazon ec2-image).
> Any ideas what is wrong?

> 2007-11-01 14:16:26 CET LOG:  could not translate host name
> "localhost", service "5432" to address: Name or service not known

Your DNS and/or /etc/hosts configuration is broken.  Every machine
should be able to resolve "localhost" (to itself, of course).

            regards, tom lane

Re: posgresql-8.2 startup problem

From
novice
Date:
Thanks Tom!  I already solved the problem by putting "127.0.0.1
localhost" in /etc/hosts file..


On Nov 2, 12:04 am, t...@sss.pgh.pa.us (Tom Lane) wrote:
> novice <BeatDr...@gmail.com> writes:
> > I just installed postgres-8.2 using the command line
> > apt-get install postgres-8.2 and it seems the installation went ok,
> > but when it tries to start postgres , it fails with this error message
> > below...
> > (by the way I am running ubuntu fiesty and on an amazon ec2-image).
> > Any ideas what is wrong?
> > 2007-11-01 14:16:26 CET LOG:  could not translate host name
> > "localhost", service "5432" to address: Name or service not known
>
> Your DNS and/or /etc/hosts configuration is broken.  Every machine
> should be able to resolve "localhost" (to itself, of course).
>
>                         regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend