Database Recovery Help...

From: "John Clark L(dot) Naldoza" <njclark(at)ntsp(dot)nec(dot)co(dot)jp>
To: pgsql-general(at)postgresql(dot)org
Subject: Database Recovery Help...
Date: 2001-05-08 06:51:17
Message-ID: 3AF79765.BE4BF09D@ntsp.nec.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)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(at)ntsp(dot)nec(dot)co(dot)jp \ \

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Clark L. Naldoza 2001-05-08 06:59:49 Mien Problem Bery Stooopeeed...;-)
Previous Message John Clark L. Naldoza 2001-05-08 04:06:50 Re: Re: PostgreSQL - PHP insert deleted from database immediately?