Обсуждение: Lost socket connection

Поиск
Список
Период
Сортировка

Lost socket connection

От
"Bryan Bateman"
Дата:
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


Re: Lost socket connection

От
Stefan Huber
Дата:
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


Re: Lost socket connection

От
"Bryan Bateman"
Дата:
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
>


pg_ctl: Can't find :/usr/local/pgsql/data/postmaster.opts.default

От
"Eduardo Kotujansky"
Дата:
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 ?