Re: Database Recovery Help...

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