| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | bk226157(at)skynet(dot)be (pierre) |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: posgres-7.1.3 hpux-11.00 posmaster died |
| Date: | 2002-01-08 16:17:43 |
| Message-ID: | 16694.1010506663@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
bk226157(at)skynet(dot)be (pierre) writes:
> This morning I saw my database had no new record added since
> yesterday.
> I tried first to connect to my db but I got the following answer:
>> psql tkgdb1240
> psql: connectDBStart() -- connect() failed: No such file or directory
> Is the postmaster running locally
> and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'?
> I displayed the process:
>> ps -ef | grep post
> postgres 6089 1 0 Dec 27 pts/ta 0:47
> /opt/postgres/bin/postmaster -i -D /db1240/data
Looks to me like your postmaster is fine. Probably what is not fine
is the socket file /tmp/.s.PGSQL.5432. Do you have some cron job that
cleans out /tmp periodically? If so, you might need to teach it not
to remove socket files.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roman Gavrilov | 2002-01-08 16:19:17 | Re: posgres-7.1.3 hpux-11.00 posmaster died |
| Previous Message | Holger Krug | 2002-01-08 15:17:47 | Re: Need help |