Re: [GENERAL] cannot connect anymore from a remote host

2006-11-09 Thread Shoaib Mir
You might want to check the ip tables as well if they have the required entries or not.Thanks,---Shoaib MirEnterpriseDB (www.enterprisedb.com) On 11/9/06, Richard Huxton wrote: Luca Ferrari wrote:> Hi all,> after a crash of my machine I restarted the pgsql as usual, and I can

Re: [GENERAL] cannot connect anymore from a remote host

2006-11-09 Thread Tom Lane
Richard Huxton writes: > Luca Ferrari wrote: >> I've started the daemon as: >> postmaster -D /mnt/data/database & > Is that how you normally start your DB server? Ditto. But if you are using a stock postgresql.conf then in fact the postmaster will *not* be listening to TCP with that command lin

Re: [GENERAL] cannot connect anymore from a remote host

2006-11-09 Thread Luca Ferrari
On Thursday 09 November 2006 15:57 Jeremiasz Miedzinski's cat, walking on the keyboard, wrote: > Have You checked network interfaces on your machine ? Maybe some of them > doesn't start-up properly... Interfaces are ok, and in fact other services on such interface are running correctly. Luca

Re: [GENERAL] cannot connect anymore from a remote host

2006-11-09 Thread Richard Huxton
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

Re: [GENERAL] cannot connect anymore from a remote host

2006-11-09 Thread Jeremiasz Miedzinski
2006/11/9, Luca Ferrari <[EMAIL PROTECTED]>: Hi all,after a crash of my machine I restarted the pgsql as usual, and I can connectfrom the machine itself, but no more from a remote host. I checked thepg_hba.conf file and it's ok, but either from psql or pgadmin I cannot connect to the host. Nmapping

[GENERAL] cannot connect anymore from a remote host

2006-11-09 Thread Luca Ferrari
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 listen