Re: Post-Reboot Issue: Postmaster Not Accessible -- FIXED - Mailing list pgsql-general

From Rich Shepard
Subject Re: Post-Reboot Issue: Postmaster Not Accessible -- FIXED
Date
Msg-id Pine.LNX.4.64.0702280827010.16174@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Post-Reboot Issue: Postmaster Not Accessible  (Alan Hodgson <ahodgson@simkin.ca>)
List pgsql-general
On Wed, 28 Feb 2007, Alan Hodgson wrote:

> Something happened to your /tmp directory after PostgreSQL started up.

Alan,

   Seems so, doesn't it?

> Stop the postmaster, clean out the socket in /tmp, and restart the
> postmaster, and it will likely fix it up.  Then you can investigate your
> boot process to see what's going wrong.

   Ahhh-h-h! That did it. I did not realize that I could kill the socket and
have postgresql start it again upon loading. It's there now (owned by
postgres.users), and I can access both the shell and my accounts via
SQL-Ledger.

Thanks very much,

Rich

--
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

pgsql-general by date:

Previous
From: "Ezequias Rodrigues da Rocha"
Date:
Subject: Re: How often do I need to reindex tables?
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Difference between UNIQUE constraint vs index