Luca Ferrari wrote: > Hi all, > after a crash of my machine I restarted the pgsql as usual, and I can connect > from the machine itself, but no more from a remote host. I checked the > pg_hba.conf file and it's ok, but either from psql or pgadmin I cannot > connect to the host. Nmapping my host I cannot see the daemon listening on > the port 5342. > I've started the daemon as: > postmaster -D /mnt/data/database &
Is that how you normally start your DB server? Not via pg_ctl or your system startup scripts?
> and my pg_hba.conf gile contains:
If you say it's not listening on port 5432 then the pg_hba.conf doesn't matter. Check your postgresql.conf for valid settings on listen_addresses and port.