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: [EMAIL PROTECTED]                        \   \

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl

Reply via email to