Re: Can't connect after restart

> > What's the value of
> > "listen_addresses" in your
> > postgresql.conf?
>=20
> UGH!! 5435... WHY??? I changed it to 5432 and it works (obviously).

Yay!


> As in most cases, it was a *stupid* thing, that I
> *should* have thought of checking out.

Well, at least it wasn't a bug, so that leaves us both happy now :-)


> We changed some settings in the conf file the first time we=20
> installed, and someone might have made a stupid typo. But=20
> when we reinstalled, we didn't change it. Is it an installer=20
> problem, or is it that pgSQL installer simply doesn't=20
> overwrite the conf file on a new install?=20

No, the installer doesn't touch the data directory, which is where the
config file sits.=20


> Another question: why did it work right after the install? Is=20
> the service started without the conf file the first time around?

Um. No. That's still weird :-) You are absolutely sure this was it?
Any chance the old postmaster was still around servicing requests
without having reloaded the config filE?


//Magnus

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend