| From: | Chris Smith <csmith(at)squiz(dot)net> |
|---|---|
| To: | "John Clark L(dot) Naldoza" <njclark(at)ntsp(dot)nec(dot)co(dot)jp>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Database Recovery Help... |
| Date: | 2001-05-08 07:06:01 |
| Message-ID: | 01050817060110.00718@area51.cybersydney.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(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?
--------------
Chris Smith
http://www.squiz.net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Clark L. Naldoza | 2001-05-08 07:09:34 | Re: Database Recovery Help... |
| Previous Message | Poul L. Christiansen | 2001-05-08 07:05:32 | Re: Database Recovery Help... |