Re: Database Recovery Help...

If you are sure that no other postmaster is running, try deleting the file
/tmp/.s.PGSQL.5432, as the error message suggests. When you've done that,
you should be able to start the postmaster.

Poul L. Christiansen

On Tue, 8 May 2001, John Clark L. Naldoza wrote:

> Hi,
>
>
> 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?
>
>
> Cheers,
>
>
> John Clark
>
> P.S.  I'm using Trustix 1.4.80..;-)
>
>
> --
>      /) John Clark Naldoza y Lopez                           (\
>     / )    Software Design Engineer II                       ( \
>   _( (_    _  Web-Application Development                    _) )_
>  (((\ \>  /_>    Cable Modem Network Management System <_\  </ /)))
>  (\\\\ \_/ /         NEC Telecom Software Phils., Inc.  \ \_/ ////)
>   \       /                                              \       /
>    \    _/  phone: (+63 32) 233-9142 loc. 3112            \_    /
>    /   /  cellphone: (+63 919) 399-4742                     \   \
>   /   / email: njclark@ntsp.nec.co.jp                        \   \
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>