Re: Can´t connect but listen address and pg_hba configured correctly

On Thu, Apr 10, 2008 at 06:00:30PM -0300, Marcelo de Moraes Serpa wrote:
> Thank you for the replies,
>
> Actually I did not change the port number. For some bizarre reason, the
> pgsql 8.1 debian package comes with port 5433 pre-configured and this was
> exactly was causing the problem, of course, I wasn't noting that the port
> was different, but they are so similar (that's what happens when you have a
> stressful day of work..). I changed it to 5432 and everything went fine.

Debian allows parallel installs. In all likelyhood you had 7.4 still
installed using port 5432 and then you installed 8.1 which got assigned
the next available port. It would have mentioned this during
installation and also pg_lsclusters would have told you this.

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.