Originally posted by richard22
Using both phppgadmin and pgimport. I'm having real problems connecting to a postgres database on another server. It probably simple but cant think what I am doing wrong. I have tried http://IP address http://dns name and http://machinename.domain but just get error unknown host.
I'm wondering if you have a DNS problem and not a PostgreSQL one. What happens when you try to ping the database server? Also, PostgreSQL by default listens on port 5432. If you're trying to connect to the database server using your web browser you'll normally be connecting to port 80. If I try connecting to port 5432 using Mozilla I get a ``The document contains no data.'' and not the one you're reporting.
Also, have you gotten into the `pg_hba.conf' file and set up the records that control what hosts are allowed to connect to the database server?
Can you post exectly what commands you're trying? And the exact error messages? (Check out the ``script'' command for a nifty way to capture this stuff.)