Re: Odd problem in 7.4.2? - Mailing list pgsql-general

From Chester Kustarz
Subject Re: Odd problem in 7.4.2?
Date
Msg-id Pine.BSO.4.44.0409021408480.23931-100000@detroit.arbor.net
Whole thread Raw
In response to Odd problem in 7.4.2?  ("Owens, Steve" <Steve.Owens@xerox.com>)
List pgsql-general
On Thu, 2 Sep 2004, Owens, Steve wrote:
> Since PostgreSQL is configured by default to run only on Unix sockets,
> moving the machine shouldn't cause the server to fail to run, right?
> What am I missing?

You don't specify how it is failing to start up (hang, crash, etc.), but
I have seen before when "localhost" was not in hosts file that postgresql
hung for 5 minutes during startup while DNS resolution timed out. This
was due to the way one of the local sockets was bound. After waiting
for the timeout (30 second timeout with 6 retries) then postgres would
come up. It may have been the stats collector socket (UDP) that was the
culprit IIRC.



pgsql-general by date:

Previous
From: "Jim Wilson"
Date:
Subject: Re: [NOVICE] pgAccess via ssh?
Next
From: John DeSoi
Date:
Subject: Re: stand-alone psql