Thread: Unable to connect to PostgreSQL 8 from PGAdmin III
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
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
Have you guys started postmaster with the –i option to tell it to listen and accept connections via TCP/IP, instead of just via the *nix sockets??
Cheers,
-p
-----Original Message-----
From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Jasbinder Bali
Sent: Friday, 11 August 2006 07:28
To: Walid Haider
Cc: pgsql-novice@postgresql.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@odline.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
*******************Confidentiality and Privilege Notice*******************
The material contained in this message is privileged and confidential to the addressee. If you are not the addressee indicated in this message or responsible for delivery of the message to such person, you may not copy or deliver this message to anyone, and you should destroy it and kindly notify the sender by reply email.
Information in this message that does not relate to the official business of Weatherbeeta must be treated as neither given nor endorsed by Weatherbeeta. Weatherbeeta, its employees, contractors or associates shall not be liable for direct, indirect or consequential loss arising from transmission of this message or any attachments
~Jas
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@gmail.com]
Sent: sexta-feira, 11 de Agosto de 2006 8:50
To: Walid Haider
Cc: pgsql-general@postgresql.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@odline.com> wrote:
Hi Jas,
What is ECPG?
Which connection string?
Regards,
Walid
From: Jasbinder Bali [mailto:jsbali@gmail.com]
Sent: quinta-feira, 10 de Agosto de 2006 22:28
To: Walid Haider
Cc: pgsql-novice@postgresql.orgSubject: 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@odline.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
Have you guys started postmaster with the –i option to tell it to listen and accept connections via TCP/IP, instead of just via the *nix sockets??
Cheers,
-p
-----Original Message-----
From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Jasbinder Bali
Sent: Friday, 11 August 2006 07:28
To: Walid Haider
Cc: pgsql-novice@postgresql.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@odline.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
*******************Confidentiality and Privilege Notice*******************
The material contained in this message is privileged and confidential to the addressee. If you are not the addressee indicated in this message or responsible for delivery of the message to such person, you may not copy or deliver this message to anyone, and you should destroy it and kindly notify the sender by reply email.
Information in this message that does not relate to the official business of Weatherbeeta must be treated as neither given nor endorsed by Weatherbeeta. Weatherbeeta, its employees, contractors or associates shall not be liable for direct, indirect or consequential loss arising from transmission of this message or any attachments
> http://www.postgresql.org/docs/8.0/interactive/app-pg-ctl.html > > it doesn't have -i option Correct, kind of... look for the option -o "-i" the -o passes options from a text string you provide directly to the postmaster service once it is started. Notice that -i is an option for the postmaster. http://www.postgresql.org/docs/8.0/interactive/app-postmaster.html Regards, Richard Broersma Jr.