Thread: [Fwd: PostgreSQL - Desparate!]

[Fwd: PostgreSQL - Desparate!]

From
Edmund Mergl
Date:
 Pardon the intrusion, but I have a dilemma which I cannot find
the answer to, after searching the newsgroups, documentation,
and mailing lists -- My postmaster will not start.

Below is a message I've posted in several newsgroups.  If you
could make ANY suggestions on getting postmaster to work,
I would appreciated it greatly.

-Thanks

-------------------------
whenever I attempt to start the postmaster, I get the
following error:

FindBackend: found "/usr/bin/postgres" using argv[0]
FATAL: StreamServerPort: bind() failed: errno=13
        Is another postmaster already running on that port?
        If not, remove socket node (/tmp/.s.PGSQL.<portnr>)and retry.

I'ts been working fine for several weeks until recently.  There are
no files in /tmp relating to postgreSQL.  The port I'm using is not in
use by another process, determined with the ps auxw|grep postma
command, and also, fuser -vun tcp 5432.

Here's the command I'm using to start postmaster:
nohup /usr/bin/postmaster -i -B 256 -p 5432 -d -D /var/lib/pgsql
>/home/postgres/pgsql.log 2>/home/postgres/pgsql.err &

I'm using postgreSQL 6.3.2 under RedHat Linux 5.1.
Any suggestions would be greatly appreciated.

-Thanks





Re: [GENERAL] [Fwd: PostgreSQL - Desparate!]

From
Bruce Momjian
Date:
Have you re-booted the machine?

>

-- Start of included mail From:  Bernie <bfb@att.net>

> Return-path:  bfb@att.net
> Return-path:  <bfb@att.net>
> Sender:  root@lena.s.bawue.de
> Date:  Sun, 02 Aug 1998 14:15:15 +0000
> X-Accept-Language:  en
> To:  E.Mergl@bawue.de
> Subject:  PostgreSQL - Desparate!

> Pardon the intrusion, but I have a dilemma which I cannot find
> the answer to, after searching the newsgroups, documentation,
> and mailing lists -- My postmaster will not start.
>
> Below is a message I've posted in several newsgroups.  If you
> could make ANY suggestions on getting postmaster to work,
> I would appreciated it greatly.
>
> -Thanks
>
> -------------------------
> whenever I attempt to start the postmaster, I get the
> following error:
>
> FindBackend: found "/usr/bin/postgres" using argv[0]
> FATAL: StreamServerPort: bind() failed: errno=13
>         Is another postmaster already running on that port?
>         If not, remove socket node (/tmp/.s.PGSQL.<portnr>)and retry.
>
> I'ts been working fine for several weeks until recently.  There are
> no files in /tmp relating to postgreSQL.  The port I'm using is not in
> use by another process, determined with the ps auxw|grep postma
> command, and also, fuser -vun tcp 5432.
>
> Here's the command I'm using to start postmaster:
> nohup /usr/bin/postmaster -i -B 256 -p 5432 -d -D /var/lib/pgsql
> >/home/postgres/pgsql.log 2>/home/postgres/pgsql.err &
>
> I'm using postgreSQL 6.3.2 under RedHat Linux 5.1.
> Any suggestions would be greatly appreciated.
>
> -Thanks
>
>
>
>
-- End of included mail.


--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

Re: [GENERAL] [Fwd: PostgreSQL - Desparate!]

From
David Hartwig
Date:
This happens to us whenever the cleaning lady gets behind the server and
kicks the plug.   We put wrapper script around the postmaster to clean up
these and any orphaned sort files.    My guess is that the "rm /tmp/*" at
boot time does not remove the hidden dot files.

Bruce Momjian wrote:

> Have you re-booted the machine?
>
> >
>
> -- Start of included mail From:  Bernie <bfb@att.net>
>
> > Return-path:  bfb@att.net
> > Return-path:  <bfb@att.net>
> > Sender:  root@lena.s.bawue.de
> > Date:  Sun, 02 Aug 1998 14:15:15 +0000
> > X-Accept-Language:  en
> > To:  E.Mergl@bawue.de
> > Subject:  PostgreSQL - Desparate!
>
> > Pardon the intrusion, but I have a dilemma which I cannot find
> > the answer to, after searching the newsgroups, documentation,
> > and mailing lists -- My postmaster will not start.
> >
> > Below is a message I've posted in several newsgroups.  If you
> > could make ANY suggestions on getting postmaster to work,
> > I would appreciated it greatly.
> >
> > -Thanks
> >
> > -------------------------
> > whenever I attempt to start the postmaster, I get the
> > following error:
> >
> > FindBackend: found "/usr/bin/postgres" using argv[0]
> > FATAL: StreamServerPort: bind() failed: errno=13
> >         Is another postmaster already running on that port?
> >         If not, remove socket node (/tmp/.s.PGSQL.<portnr>)and retry.
> >
> > I'ts been working fine for several weeks until recently.  There are
> > no files in /tmp relating to postgreSQL.  The port I'm using is not in
> > use by another process, determined with the ps auxw|grep postma
> > command, and also, fuser -vun tcp 5432.
> >
> > Here's the command I'm using to start postmaster:
> > nohup /usr/bin/postmaster -i -B 256 -p 5432 -d -D /var/lib/pgsql
> > >/home/postgres/pgsql.log 2>/home/postgres/pgsql.err &
> >
> > I'm using postgreSQL 6.3.2 under RedHat Linux 5.1.
> > Any suggestions would be greatly appreciated.
> >
> > -Thanks
> >
> >
> >
> >
> -- End of included mail.
>
> --
> Bruce Momjian                          |  830 Blythe Avenue
> maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
>   +  If your life is a hard drive,     |  (610) 353-9879(w)
>   +  Christ can be your backup.        |  (610) 853-3000(h)




Re: [GENERAL] [Fwd: PostgreSQL - Desparate!]

From
"Brett W. McCoy"
Date:
On Sun, 2 Aug 1998, David Hartwig wrote:

> This happens to us whenever the cleaning lady gets behind the server and
> kicks the plug.   We put wrapper script around the postmaster to clean up
> these and any orphaned sort files.    My guess is that the "rm /tmp/*" at
> boot time does not remove the hidden dot files.

I put a line in rc.sysinit to explictly remove any .s.PGSQL* files (right
after the line that deletes old PID and .X files).  Haven't had a problem
starting up the postmaster since doing so.  If you need to remove hidden
dot files, you need to use 'rm /tmp/.*' -- you need the leading dot.

Brett W. McCoy
                                        http://www.lan2wan.com/~bmccoy/
-----------------------------------------------------------------------
"The number of UNIX installations has grown to 10, with more expected."
   -- The UNIX Programmer's Manual, 2nd Edition, June, 1972