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 \ \