On Wed, 28 Feb 2007, Tom Lane wrote:
Stop the postmaster, remove the bogus socket file by hand, start the
postmaster.
Tom,
That did it.
I imagine that if you check the postmaster log you will notice a bleat
near the beginning about failing to open the socket file (because of the
pre-exist
Rich Shepard <[EMAIL PROTECTED]> writes:
>Is there a method other than a reboot to remedy this?
Stop the postmaster, remove the bogus socket file by hand, start the
postmaster.
I imagine that if you check the postmaster log you will notice a bleat
near the beginning about failing to open the
On Wed, 28 Feb 2007, Alan Hodgson wrote:
Something happened to your /tmp directory after PostgreSQL started up.
Alan,
Seems so, doesn't it?
Stop the postmaster, clean out the socket in /tmp, and restart the
postmaster, and it will likely fix it up. Then you can investigate your
boot proc
On Wednesday 28 February 2007 08:12, Rich Shepard <[EMAIL PROTECTED]>
wrote:
> [EMAIL PROTECTED] ~]$ psql -h localhost -U postgres aesi
> Welcome to psql 8.1.4, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? f
On Wed, 28 Feb 2007, Tom Lane wrote:
The socket file should surely not be owned by root ... there's something
pretty weird there. How did you start the postmaster?
Tom,
The startup script, /etc/rc.d/rc.postgresql is run when the system boots.
The result is,
16648 pts/1S 0:00 /usr
On Wed, 28 Feb 2007, Joshua D. Drake wrote:
psql -h localhost -U postgres databasename
Joshua,
Well, something's wrong:
[EMAIL PROTECTED] ~]$ psql -h localhost -U postgres aesi
Welcome to psql 8.1.4, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h
Rich Shepard <[EMAIL PROTECTED]> writes:
>The postmaster is running:
> 9959 pts/1S 0:00 /usr/bin/postmaster -D /var/lib/pgsql/data
> and the socket is present:
> srwxrwxrwx 1 root root 0 2007-02-28 05:20 /tmp/.s.PGSQL.5432=
The socket file should surely not be owned by root ... there'
Rich Shepard wrote:
> After having to reboot my server/workstation this morning, I've a
> problem with
> postgresql; one I've never before encountered.
>
> The postmaster is running:
>
> 9959 pts/1S 0:00 /usr/bin/postmaster -D /var/lib/pgsql/data
>
> and the socket is present:
>
>
After having to reboot my server/workstation this morning, I've a problem with
postgresql; one I've never before encountered.
The postmaster is running:
9959 pts/1S 0:00 /usr/bin/postmaster -D /var/lib/pgsql/data
and the socket is present:
srwxrwxrwx 1 root root 0 2007-02-28 05:20
