Re: Database Recovery Help... - Mailing list pgsql-general

From Chris Smith
Subject Re: Database Recovery Help...
Date
Msg-id 01050817060110.00718@area51.cybersydney.com.au
Whole thread Raw
In response to Database Recovery Help...  ("John Clark L. Naldoza" <njclark@ntsp.nec.co.jp>)
List pgsql-general
Hi,

Did you try what it suggests?

If you're sure PostgreSQL isn't already running, remove the
"/tmp/.s.PGSQL.5432" file, and try again.

> I recently came across a problem wherein I am not able to start my
> postgreSQL 7.0.3 server.
>
> Here's what happens..;-(
>
> postgres@kahoy /root$ postmaster -D /var/lib/pgsql/data
> FATAL: StreamServerPort: bind() failed: Permission denied
>         Is another postmaster already running on that port?
>         If not, remove socket node (/tmp/.s.PGSQL.5432) and retry.
> /usr/bin/postmaster: cannot create UNIX stream port
>
> There is no one binding the 5432 port, and no one is trying to connect
> to that port.  I may be left with no other alternative and restart from
> scratch...;-(
>
> There are some pretty important data currently in the database that I'd
> like to recover...
>
> Is there any way wherein I could recover or reconstruct the data?

--------------
     Chris Smith
http://www.squiz.net

pgsql-general by date:

Previous
From: "John Clark L. Naldoza"
Date:
Subject: Re: Database Recovery Help...
Next
From: "Poul L. Christiansen"
Date:
Subject: Re: Database Recovery Help...