pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedsocket file missing
4+ messages / 2 participants
[nested] [flat]
* socket file missing
@ 2007-09-14 09:24 nus4u@gmx.net
2007-09-14 13:16 ` Re: socket file missing Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: nus4u@gmx.net @ 2007-09-14 09:24 UTC (permalink / raw)
To: pgsql-admin
Hi,
i compiled postres 8.2.4, create a user and a database without an error.
I copied a startup skript to the init.d directory and make a chkconfig postgres. After that starting the database was no problem.
Today i restarted the whole PC and everything seems to be ok, the postgres server started and accepted connections via TCP.
BUT : I could not connect via psql for example.
Message :
> Warning: Unable to connect to PostgreSQL server: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
There was no file in the /tmp Directory !
I make a restart via the init skript and then everything was ok!
Again i restarted the whole PC and again the socket file was missing and a restarting via the init skript helps.
->Every Time i restart the socket file is missing !
I decrease the logs but could not find any error message !
Any hints why the socket is missing when i restart the PC ?
How can i solve this problem ?
Thanks for Help
Chris
--
Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: socket file missing
2007-09-14 09:24 socket file missing nus4u@gmx.net
@ 2007-09-14 13:16 ` Scott Marlowe <scott.marlowe@gmail.com>
2007-09-14 18:38 ` Re: socket file missing nus4u@gmx.net
0 siblings, 1 reply; 4+ messages in thread
From: Scott Marlowe @ 2007-09-14 13:16 UTC (permalink / raw)
To: nus4u@gmx.net <nus4u@gmx.net>; +Cc: pgsql-admin
On 9/14/07, nus4u@gmx.net <nus4u@gmx.net> wrote:
> Hi,
>
> BUT : I could not connect via psql for example.
> Message :
> > Warning: Unable to connect to PostgreSQL server: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
>
> There was no file in the /tmp Directory !
> I make a restart via the init skript and then everything was ok!
> Again i restarted the whole PC and again the socket file was missing and a restarting via the init skript helps.
Sounds like postgresql is being started, and then the /tmp directory
is being cleared of old files by your OS. What's the Sxx number on
the startup file in /etc/init.d/rcx.d that you're using (assuming SYSV
init)
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: socket file missing
2007-09-14 09:24 socket file missing nus4u@gmx.net
2007-09-14 13:16 ` Re: socket file missing Scott Marlowe <scott.marlowe@gmail.com>
@ 2007-09-14 18:38 ` nus4u@gmx.net
2007-09-14 19:25 ` Re: socket file missing Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: nus4u@gmx.net @ 2007-09-14 18:38 UTC (permalink / raw)
To: pgsql-admin
> Sounds like postgresql is being started, and then the /tmp directory
> is being cleared of old files by your OS. What's the Sxx number on
> the startup file in /etc/init.d/rcx.d that you're using (assuming SYSV
> init)
Thanks Scott !
I change the location of the socket file and it isn t deleted anymore !
Until now i am not quite sure which script deletes the socket files, i
guess it is "tmpwatch" which is called from cron.hourly, but disabling
and restarting didn t solve the problem.
In rc3.d it has the Numer S96postgres, after this script only
sendmail,rhnsd,haldaemon,messagebus and local are executed, but
none of them will delete tmp files.
Any idea which and where the script is started who deletes tmp files ?
System is a Red Hat ES 4 !
Bye
Chris
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: socket file missing
2007-09-14 09:24 socket file missing nus4u@gmx.net
2007-09-14 13:16 ` Re: socket file missing Scott Marlowe <scott.marlowe@gmail.com>
2007-09-14 18:38 ` Re: socket file missing nus4u@gmx.net
@ 2007-09-14 19:25 ` Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Scott Marlowe @ 2007-09-14 19:25 UTC (permalink / raw)
To: nus4u@gmx.net; +Cc: pgsql-admin
On 9/14/07, nus4u@gmx.net <nus4u@gmx.net> wrote:
> > Sounds like postgresql is being started, and then the /tmp directory
> > is being cleared of old files by your OS. What's the Sxx number on
> > the startup file in /etc/init.d/rcx.d that you're using (assuming SYSV
> > init)
>
> Thanks Scott !
>
> I change the location of the socket file and it isn t deleted anymore !
> Until now i am not quite sure which script deletes the socket files, i
> guess it is "tmpwatch" which is called from cron.hourly, but disabling
> and restarting didn t solve the problem.
> In rc3.d it has the Numer S96postgres, after this script only
> sendmail,rhnsd,haldaemon,messagebus and local are executed, but
> none of them will delete tmp files.
> Any idea which and where the script is started who deletes tmp files ?
> System is a Red Hat ES 4 !
On my laptop running fc4, there's this line in rc.sysinit:
rc.sysinit:rm -f /tmp/.X*-lock /tmp/.lock.* /tmp/.gdm_socket /tmp/.s.PGSQL.*
If your startup script runs before a line like that one above, you'd
get the kind of failure you're talking about.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2007-09-14 19:25 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-09-14 09:24 socket file missing nus4u@gmx.net
2007-09-14 13:16 ` Scott Marlowe <scott.marlowe@gmail.com>
2007-09-14 18:38 ` nus4u@gmx.net
2007-09-14 19:25 ` Scott Marlowe <scott.marlowe@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox