Re: Unable to connect to PostgreSQL 8 from PGAdmin III

Walid,
Are you working in a client - server model.
Are you trying to connect to a database server that is hosted at a different
machine?

~Jas

On 8/11/06, Walid Haider <whaider(at)odline(dot)com> wrote:
>
> Hi Jas,
>
>
>
> I am using PGAdmin III to connect to the db, and that is when I get the
> error. However, when I connect to the server using Putty (SSH), I am able to
> open the test db that I created after installing PostgreSQL 8.
>
>
>
> Thanks for clarifying ECPG.
>
>
>
> Regards,
>
> Walid
>
>
> ------------------------------
>
> *From:* Jasbinder Bali [mailto:jsbali(at)gmail(dot)com]
> *Sent:* sexta-feira, 11 de Agosto de 2006 8:50
> *To:* Walid Haider
> *Cc:* pgsql-general(at)postgresql(dot)org
>
> *Subject:* Re: [NOVICE] Unable to connect to PostgreSQL 8 from PGAdmin III
>
>
>
> Hi Walid,
>
>
>
> Well how are u connecting to the database?
>
> What client interface are u using?
>
> is it libpq?
>
> What code are u using to connect to the database?
>
>
>
> ECPG means embedded sql in C. You can write sql in ur C program using ECPG
>
>
>
> On 8/11/06, *Walid Haider* <whaider(at)odline(dot)com> wrote:
>
> Hi Jas,
>
>
>
> What is ECPG?
>
> Which connection string?
>
>
>
> Regards,
>
> Walid
> ------------------------------
>
> *From:* Jasbinder Bali [mailto:jsbali(at)gmail(dot)com]
> *Sent:* quinta-feira, 10 de Agosto de 2006 22:28
>
>
> *To:* Walid Haider
> *Cc:* pgsql-novice(at)postgresql(dot)org
>
> *Subject:* Re: [NOVICE] Unable to connect to PostgreSQL 8 from PGAdmin III
>
>
>
>
> Walid,
>
> Are you using ECPG?
>
> What does your connection string look like?
>
> I''m also banging my head on the same problem for the past one day.
>
> ~Jas
>
>
>
> On 8/10/06, *Walid Haider* < whaider(at)odline(dot)com> wrote:
>
> Hi All,
>
>
>
> I have been trying to connect to PostgreSQL 8 (which is installed on an
> FC4 server with a public IP address) from PGAdmin III, and I am getting the
> following error:
>
>
>
> Error connecting to the server: could not connect to server: Connection
> timed out (0x0000274C/10060)
>
> Is the server running on host "XX.XXX.XXX.XXX" and accepting
>
> TCP/IP connections on port 5432?
>
>
>
> From a terminal on the server, on the server I can connect to the 'test'
> database that I created after installation of PostgreSQL.
>
>
>
> I have read on various sites on the internet that this issue could be
> associated with the "tcpip_socket" flag being set to FALSE, this flag is not
> available in the postgresql.conf file?
>
>
>
> *On the postgresql.conf file, I have done the following:*
>
>
>
> listen_addresses = '*'
>
> port = 5432
>
>
>
> *On the pg_hba.conf file, I have done the following:*
>
>
>
> Located the line beginning with "TYPE" and added entries as
> applicable
>
> TYPE DB USER CIDR-ADDRESS METHOD
>
> host all all XX.XX.XXX.XXX/24 trust # remote
> access
>
> host all all XX.XX.XX.XX/24 trust # remote
> access
>
>
>
>
>
> Any ideas where I am going wrong?
>
>
>
> Thanks
>
> Walid
>
>
>
>
>