Thread: Lost socket connection

I lost my socket connection to the database.  The postmaster did not shut
down. Made no configuration or database changes.

Rebooted the server and restarted the postmaster with no luck.  Localhost
connection works fine.

Any hints on troubleshooting this problem would be helpful.

Thanks in advance,

Bryan

At 13:09 2000-12-06 +0000, you wrote:
>I lost my socket connection to the database.  The postmaster did not shut
>down. Made no configuration or database changes.

Sounds stupid, maybe, but: are you still starting the postmaster with the -i option?
Is networking up on your machine? Maybe that's the problem...

Stefan

Not stupid at all.  Had two shell scripts, on with -i and one without.
Wanna guess which one I was starting with!!!!!!!!

One of those
days............................................................

----- Original Message -----
From: "Stefan Huber" <schweinsaug@crosswinds.net>
To: <pgsql-admin@postgresql.org>
Sent: Wednesday, December 06, 2000 6:33 PM
Subject: Re: [ADMIN] Lost socket connection


> At 13:09 2000-12-06 +0000, you wrote:
> >I lost my socket connection to the database.  The postmaster did not shut
> >down. Made no configuration or database changes.
>
> Sounds stupid, maybe, but: are you still starting the postmaster with
the -i option?
> Is networking up on your machine? Maybe that's the problem...
>
> Stefan
>

I had to re-install postgresql  in my FreeBSD machine.
And after that I get an error:
pg_ctl: Can't find :/usr/local/pgsql/data/postmaster.opts.default

this file is ok with permissions to postgres user.

what´s wrong here ?