Re: [HACKERS] Sure enough, the lock file is gone

2001-01-29 Thread Ross J. Reedstrom
On Fri, Jan 26, 2001 at 11:55:16PM -0500, Bruce Momjian wrote: > > I said: > > > Yes, there are lots of systems that will clean /tmp --- and since the > > > lock file is an ordinary file (not a socket) pretty much any tmp-cleaner > > > is going to decide to remove it. I think that I had intended

Re: [HACKERS] Sure enough, the lock file is gone

2001-01-27 Thread Tom Lane
"Oliver Elphick" <[EMAIL PROTECTED]> writes: > /var/run/postgresql There's another reason why the standard socket directory is /tmp, and that's that it exists everywhere. Not all Unix systems even *have* a /var hierarchy, let alone one that the admin will let you have a playpen in.

Re: [HACKERS] Sure enough, the lock file is gone

2001-01-27 Thread Oliver Elphick
Bruce Momjian wrote: >> Note: programs that run as non-root users may be unable to create files un >der >> /var/run and therefore need a subdirectory owned by the appropriate user. > >This is the killer. We can't require root. Seems we are stuck with >/tmp. I'd be surprised to

Re: [HACKERS] Sure enough, the lock file is gone

2001-01-27 Thread Bruce Momjian
> Jan Wieck wrote: > >Peter Eisentraut wrote: > >> Jan Wieck writes: > >> > >> > Exactly the way you want it to do (open(2) and close(2) of a > >> > UNIX domain socket) was what I had to do to get an old > >> > Mach3-4.3BSD combo into a kernel-panic. > >> > >> T

Re: [HACKERS] Sure enough, the lock file is gone

2001-01-27 Thread Oliver Elphick
Jan Wieck wrote: >Peter Eisentraut wrote: >> Jan Wieck writes: >> >> > Exactly the way you want it to do (open(2) and close(2) of a >> > UNIX domain socket) was what I had to do to get an old >> > Mach3-4.3BSD combo into a kernel-panic. >> >> The lock file is an

Re: [HACKERS] Sure enough, the lock file is gone

2001-01-26 Thread Bruce Guenter
On Fri, Jan 26, 2001 at 05:06:24PM -0500, Jan Wieck wrote: > So the crazy-temp-vacuum-cleaner on linux doesn't touch the > sockets? The tmpwatch program that comes with many Linux distributions will only unlink regular files and empty directories by default. -- Bruce Guenter <[EMAIL PR

Re: [HACKERS] Sure enough, the lock file is gone

2001-01-26 Thread Bruce Momjian
> I said: > > Yes, there are lots of systems that will clean /tmp --- and since the > > lock file is an ordinary file (not a socket) pretty much any tmp-cleaner > > is going to decide to remove it. I think that I had intended to insert > > a periodic touch of the lockfile and forgot to. > > Done

Re: [HACKERS] Sure enough, the lock file is gone

2001-01-26 Thread Bruce Momjian
> On Fri, Jan 26, 2001 at 03:18:13PM -0500, Bruce Momjian wrote: > > > The 'tmpwatch' program on Red Hat will remove the /tmp/.s.PGSQL.5432.lock > > > file after the server has run 6 days. This will be a problem. > > > > > > We could touch (open) the file once every time the ServerLoop() runs >

Re: [HACKERS] Sure enough, the lock file is gone

2001-01-26 Thread Tom Lane
I said: > Yes, there are lots of systems that will clean /tmp --- and since the > lock file is an ordinary file (not a socket) pretty much any tmp-cleaner > is going to decide to remove it. I think that I had intended to insert > a periodic touch of the lockfile and forgot to. Done now.

Re: [HACKERS] Sure enough, the lock file is gone

2001-01-26 Thread Jan Wieck
Peter Eisentraut wrote: > Jan Wieck writes: > > > Exactly the way you want it to do (open(2) and close(2) of a > > UNIX domain socket) was what I had to do to get an old > > Mach3-4.3BSD combo into a kernel-panic. > > The lock file is an ordinary file. So the crazy-temp-

Re: [HACKERS] Sure enough, the lock file is gone

2001-01-26 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Bruce Momjian writes: >> If we have to do it, let's make it an #ifdef __linux__ option. > What does Linux have to do with it? FreeBSD does the same thing, only > every three days. I dont' know whether it's not enabled on a fresh > install, but it's

Re: [HACKERS] Sure enough, the lock file is gone

2001-01-26 Thread Peter Eisentraut
Bruce Momjian writes: > If we have to do it, let's make it an #ifdef __linux__ option. What does Linux have to do with it? FreeBSD does the same thing, only every three days. I dont' know whether it's not enabled on a fresh install, but it's there, you only need to flip the switch. I doubt /t

Re: [HACKERS] Sure enough, the lock file is gone

2001-01-26 Thread Peter Eisentraut
Jan Wieck writes: > Exactly the way you want it to do (open(2) and close(2) of a > UNIX domain socket) was what I had to do to get an old > Mach3-4.3BSD combo into a kernel-panic. The lock file is an ordinary file. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.

Re: [HACKERS] Sure enough, the lock file is gone

2001-01-26 Thread Alfred Perlstein
* Peter Eisentraut <[EMAIL PROTECTED]> [010126 12:11] wrote: > The 'tmpwatch' program on Red Hat will remove the /tmp/.s.PGSQL.5432.lock > file after the server has run 6 days. This will be a problem. > > We could touch (open) the file once every time the ServerLoop() runs > around. It's not pe

Re: [HACKERS] Sure enough, the lock file is gone

2001-01-26 Thread Jan Wieck
Ross J. Reedstrom wrote: > On Fri, Jan 26, 2001 at 03:18:13PM -0500, Bruce Momjian wrote: > > > The 'tmpwatch' program on Red Hat will remove the /tmp/.s.PGSQL.5432.lock > > > file after the server has run 6 days. This will be a problem. > > > > > > We could touch (open) the file once every time

Re: [HACKERS] Sure enough, the lock file is gone

2001-01-26 Thread Ross J. Reedstrom
On Fri, Jan 26, 2001 at 03:18:13PM -0500, Bruce Momjian wrote: > > The 'tmpwatch' program on Red Hat will remove the /tmp/.s.PGSQL.5432.lock > > file after the server has run 6 days. This will be a problem. > > > > We could touch (open) the file once every time the ServerLoop() runs > > around.

Re: [HACKERS] Sure enough, the lock file is gone

2001-01-26 Thread Bruce Momjian
> The 'tmpwatch' program on Red Hat will remove the /tmp/.s.PGSQL.5432.lock > file after the server has run 6 days. This will be a problem. > > We could touch (open) the file once every time the ServerLoop() runs > around. It's not perfect but it should work in practice. If we have to do it, l

[HACKERS] Sure enough, the lock file is gone

2001-01-26 Thread Peter Eisentraut
The 'tmpwatch' program on Red Hat will remove the /tmp/.s.PGSQL.5432.lock file after the server has run 6 days. This will be a problem. We could touch (open) the file once every time the ServerLoop() runs around. It's not perfect but it should work in practice. -- Peter Eisentraut [EMAIL