From postgresql@fironline.com.br Mon Feb 2 23:31:20 2004 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id AD24ED1D3E8 for ; Mon, 2 Feb 2004 23:31:20 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 48569-04 for ; Mon, 2 Feb 2004 19:31:16 -0400 (AST) Received: from chiapa.terra.com.br (chiapa.terra.com.br [200.154.55.224]) by svr1.postgresql.org (Postfix) with ESMTP id AA1E2D1D7FA for ; Mon, 2 Feb 2004 19:30:57 -0400 (AST) Received: from rosario.terra.com.br (rosario.terra.com.br [200.154.55.129]) by chiapa.terra.com.br (Postfix) with ESMTP id 80B0BECC4E for ; Mon, 2 Feb 2004 21:30:51 -0200 (BRST) Received: from fironline.com.br (cm-tvcidade-rec-C8B14B69.brdterra.com.br [200.177.75.105]) (authenticated user gtrmp) by rosario.terra.com.br (Postfix) with ESMTP id 26AB93C03A for ; Mon, 2 Feb 2004 21:30:49 -0200 (BRST) Message-ID: <401EDD75.7020408@fironline.com.br> Date: Mon, 02 Feb 2004 20:29:57 -0300 From: Gustavo Paixao User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.2; en-US; rv:1.5) Gecko/20031007 X-Accept-Language: en-us, en, pt-br MIME-Version: 1.0 To: PGSQL+PHP Subject: PG_CONNECT error Content-Type: multipart/alternative; boundary="------------050302070508050803090700" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/8 X-Sequence-Number: 2556 This is a multi-part message in MIME format. --------------050302070508050803090700 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit Hi, Why this error ir happening? and How to fix? *Warning*: pg_connect(): Unable to connect to PostgreSQL server: FATAL: IDENT authentication failed for user "fotolis" . in */home/fotolis/public_html/connection.php* on line *6 *Thanks,* Gustavo Paixão * --------------050302070508050803090700 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Hi,

Why this error ir happening? and How to fix?

Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: IDENT authentication failed for user "fotolis" . in /home/fotolis/public_html/connection.php on line 6

Thanks,


Gustavo Paixão
--------------050302070508050803090700-- From scott.marlowe@ihs.com Mon Feb 2 23:58:53 2004 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 70A7CD1D362 for ; Mon, 2 Feb 2004 23:58:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 56173-04 for ; Mon, 2 Feb 2004 19:58:52 -0400 (AST) Received: from mail1.ihs.com (mail1.ihs.com [170.207.70.222]) by svr1.postgresql.org (Postfix) with ESMTP id 2C11ED1CCCD for ; Mon, 2 Feb 2004 19:58:49 -0400 (AST) Received: from css120.ihs.com (css120.ihs.com [170.207.105.120]) by mail1.ihs.com (8.12.10/8.12.10) with ESMTP id i12NvhRC010814; Mon, 2 Feb 2004 16:57:43 -0700 (MST) Date: Mon, 2 Feb 2004 16:53:52 -0700 (MST) From: "scott.marlowe" To: Gustavo Paixao Cc: PGSQL+PHP Subject: Re: PG_CONNECT error In-Reply-To: <401EDD75.7020408@fironline.com.br> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-IHS-MailScanner: Found to be clean X-IHS-MailScanner-SpamCheck: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/10 X-Sequence-Number: 2558 On Mon, 2 Feb 2004, Gustavo Paixao wrote: > Hi, > > Why this error ir happening? and How to fix? > > *Warning*: pg_connect(): Unable to connect to PostgreSQL server: FATAL: > IDENT authentication failed for user "fotolis" . in > */home/fotolis/public_html/connection.php* on line *6 Is there a postgresql user named fotolis in the database? select * from pg_user will tell you. From postgresql@fironline.com.br Tue Feb 3 00:26:48 2004 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D4F12D1D412 for ; Tue, 3 Feb 2004 00:26:48 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 66547-01 for ; Mon, 2 Feb 2004 20:26:44 -0400 (AST) Received: from ibague.terra.com.br (ibague.terra.com.br [200.154.55.225]) by svr1.postgresql.org (Postfix) with ESMTP id C8D24D1D362 for ; Mon, 2 Feb 2004 20:26:40 -0400 (AST) Received: from paramonga.terra.com.br (paramonga.terra.com.br [200.154.55.133]) by ibague.terra.com.br (Postfix) with ESMTP id D9E73EC575 for ; Mon, 2 Feb 2004 22:26:42 -0200 (BRST) Received: from fironline.com.br (cm-tvcidade-rec-C8B14B69.brdterra.com.br [200.177.75.105]) (authenticated user gtrmp) by paramonga.terra.com.br (Postfix) with ESMTP id 32AB83C067 for ; Mon, 2 Feb 2004 22:26:42 -0200 (BRST) Message-ID: <401EEA93.3000407@fironline.com.br> Date: Mon, 02 Feb 2004 21:25:55 -0300 From: Gustavo Paixao User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.2; en-US; rv:1.5) Gecko/20031007 X-Accept-Language: en-us, en, pt-br MIME-Version: 1.0 To: PGSQL+PHP Subject: Re: PG_CONNECT error References: In-Reply-To: Content-Type: multipart/alternative; boundary="------------000608090602030100040803" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/11 X-Sequence-Number: 2559 This is a multi-part message in MIME format. --------------000608090602030100040803 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit fotolis is user in the database!!! How may I edit pg_hba.conf and pg_ident.conf on prompt using bash.exe? scott.marlowe wrote: >On Mon, 2 Feb 2004, Gustavo Paixao wrote: > > > >>Hi, >> >>Why this error ir happening? and How to fix? >> >>*Warning*: pg_connect(): Unable to connect to PostgreSQL server: FATAL: >>IDENT authentication failed for user "fotolis" . in >>*/home/fotolis/public_html/connection.php* on line *6 >> >> > >Is there a postgresql user named fotolis in the database? > >select * from pg_user > >will tell you. > > > > > > --------------000608090602030100040803 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit fotolis is user in the database!!!

How may I edit pg_hba.conf and pg_ident.conf on prompt using bash.exe?

scott.marlowe wrote:
On Mon, 2 Feb 2004, Gustavo Paixao wrote:

  
Hi,

Why this error ir happening? and How to fix?

*Warning*: pg_connect(): Unable to connect to PostgreSQL server: FATAL: 
IDENT authentication failed for user "fotolis" . in 
*/home/fotolis/public_html/connection.php* on line *6
    

Is there a postgresql user named fotolis in the database?

select * from pg_user

will tell you.




  

--------------000608090602030100040803-- From longlinux@gmail.com Sun May 18 20:21:22 2008 Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 103EA2E0031 for ; Sun, 18 May 2008 17:21:22 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 20650-10 for ; Sun, 18 May 2008 17:21:16 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from yw-out-2324.google.com (yw-out-2324.google.com [74.125.46.28]) by developer.postgresql.org (Postfix) with ESMTP id 23EB22E0039 for ; Sun, 18 May 2008 17:21:18 -0300 (ADT) Received: by yw-out-2324.google.com with SMTP id 3so984825ywj.73 for ; Sun, 18 May 2008 13:21:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:from:to:subject:date:mime-version:content-type:x-priority:x-msmail-priority:x-mailer:x-mimeole; bh=TAnX24ZkVg4rA5rwnkvwd0pWcRq3ZI74nivj84VQmi4=; b=tdVPVHqpfFEiY9rGf1hx5CF+dciKcZqQ1NGm70VUEuk3XSwaivnJ0hBvmWdMz/Y/kahemWKu2vFCsW0pKa6YqXxvzAETjxYoOfPf4jrH6jc19NNi/s5zXOrDAE0SnDwqbZ3tvhsYo/RpgWXST2nhNmd+ZCkiUVqlBUSP4gP638g= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:from:to:subject:date:mime-version:content-type:x-priority:x-msmail-priority:x-mailer:x-mimeole; b=Ey7oW6c66WC0K2yvICEUBaZUsY/YWD3CIRaK9lvbM6yNJicrMIsA1ytv4lQCLgaBWuF9J9IY+ytPN1XLekulQTtZzNvdWwkIzzW3S1feMv8I9wzs5yNMgPceQOgwdl0q7SsPjiH99M081gsulLgY/QffZNWOdmZEFuLcFPa2xHE= Received: by 10.150.191.15 with SMTP id o15mr5613205ybf.54.1211142078114; Sun, 18 May 2008 13:21:18 -0700 (PDT) Received: from osvaldox ( [200.122.23.17]) by mx.google.com with ESMTPS id 6sm6626708ywi.1.2008.05.18.13.21.16 (version=SSLv3 cipher=RC4-MD5); Sun, 18 May 2008 13:21:17 -0700 (PDT) Message-ID: <001201c8b924$bad26150$e295fea9@osvaldox> From: "LonLinux" To: Subject: pg_connect error Date: Sun, 18 May 2008 17:21:15 -0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000F_01C8B90B.93C020C0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200805/3 X-Sequence-Number: 3845 This is a multi-part message in MIME format. ------=_NextPart_000_000F_01C8B90B.93C020C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I have this problem with a connection to postgres server (running = in a win2000 server). When I connect with pgAdmin to the same postgres server works ok, but = when I try to connect from php5 the connection fails. Can help me? Thanks. $db_conn =3D pg_connect("host=3DSQLMACHINE port=3D5432 password=3Dxxxx = user=3Dpostgres dbname=3Dcompraventa1"); if (!$db_conn): ?>

Failed connecting to postgres database

Hello, I have this problem with a = connection to=20 postgres server (running in a win2000 server).
When I connect with pgAdmin to the same = postgres=20 server works ok, but when I try to connect from php5 the connection=20 fails.
Can help me?
Thanks.
 
$db_conn =3D = pg_connect("host=3DSQLMACHINE port=3D5432=20 password=3Dxxxx user=3Dpostgres dbname=3Dcompraventa1");
if = (!$db_conn):=20 ?>
    <H1>Failed connecting to postgres = database=20 <? echo "compraventa1" ?></H1> = <?
   =20 exit;
endif;
 
Ovax
------=_NextPart_000_000F_01C8B90B.93C020C0-- From xzilla@users.sourceforge.net Mon May 19 01:40:16 2008 Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 0FFC82E002F for ; Sun, 18 May 2008 22:40:16 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 08576-04 for ; Sun, 18 May 2008 22:40:07 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from vms173003pub.verizon.net (vms173003pub.verizon.net [206.46.173.3]) by developer.postgresql.org (Postfix) with ESMTP id 177012E002C for ; Sun, 18 May 2008 22:40:12 -0300 (ADT) Received: from ridley.home ([72.81.250.230]) by vms173003.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0K1300A9PDU7OHBK@vms173003.mailsrvcs.net> for pgsql-php@postgresql.org; Sun, 18 May 2008 20:37:19 -0500 (CDT) Date: Sun, 18 May 2008 21:40:10 -0400 From: Robert Treat Subject: Re: pg_connect error In-reply-to: <001201c8b924$bad26150$e295fea9@osvaldox> To: pgsql-php@postgresql.org Cc: "LonLinux" Message-id: <200805182140.10890.xzilla@users.sourceforge.net> MIME-version: 1.0 Content-type: text/plain; charset=iso-8859-15 Content-transfer-encoding: 7bit Content-disposition: inline References: <001201c8b924$bad26150$e295fea9@osvaldox> User-Agent: KMail/1.9.9 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/4 X-Sequence-Number: 3846 On Sunday 18 May 2008 16:21:15 LonLinux wrote: > Hello, I have this problem with a connection to postgres server (running in > a win2000 server). When I connect with pgAdmin to the same postgres server > works ok, but when I try to connect from php5 the connection fails. Can > help me? > Thanks. > > $db_conn = pg_connect("host=SQLMACHINE port=5432 password=xxxx > user=postgres dbname=compraventa1"); if (!$db_conn): ?> >

Failed connecting to postgres database ?>

endif; > Well, what's the error message? (And if there isnt one, have you looked in the db logs? If nothing there, try connecting with psql with the same credentials as above, as your web servers user) -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL From dmagick@gmail.com Mon May 19 01:42:55 2008 Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 5FDFA2E0031 for ; Sun, 18 May 2008 22:42:55 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 10602-03 for ; Sun, 18 May 2008 22:42:47 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.236]) by developer.postgresql.org (Postfix) with ESMTP id 743B72E002C for ; Sun, 18 May 2008 22:42:52 -0300 (ADT) Received: by rv-out-0506.google.com with SMTP id b25so1259155rvf.43 for ; Sun, 18 May 2008 18:42:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; bh=wvsurlnpww+ouS2lonPWKesJ/WovPpEiq4f3MZPeHPg=; b=ixl6/RU+UJ1JV6+gtg52G2woUXmxC4apkQkZAzeFklPMNkgJxtV/jyp6kSW4tHk1vryVE/jsmhVuCK0C/j/xeaYSYQLgaXBdjV8Jyb3Uq1rEXG8qYpjegBO5QarAemb0TvG/Kpzxt0OqEp2HVRVF9uJ94+oSNc/3/GPIFJAIqIo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=R9+mvYZr6nDLPvAAkoUooKISgto6yOmWd+NdCCUYndWwC7AiuiLGvi6Bebok+htfOKzVHyjCGo9t4SSc8GSiBFG+zUY8V6m5OgRM5VmR9rtqs9W3WP3qEjr4+KK2j0qhgIGG1oYv7ETXCUyCXKM9I13QfFalgZ4SAHmSkO78dro= Received: by 10.140.165.21 with SMTP id n21mr3332102rve.257.1211161371031; Sun, 18 May 2008 18:42:51 -0700 (PDT) Received: from ?10.1.1.5? ( [203.206.174.100]) by mx.google.com with ESMTPS id g31sm11905621rvb.2.2008.05.18.18.42.48 (version=TLSv1/SSLv3 cipher=RC4-MD5); Sun, 18 May 2008 18:42:50 -0700 (PDT) Message-ID: <4830DB15.4080103@gmail.com> Date: Mon, 19 May 2008 11:42:45 +1000 From: Chris User-Agent: Thunderbird 2.0.0.14 (X11/20080505) MIME-Version: 1.0 To: LonLinux CC: pgsql-php@postgresql.org Subject: Re: pg_connect error References: <001201c8b924$bad26150$e295fea9@osvaldox> In-Reply-To: <001201c8b924$bad26150$e295fea9@osvaldox> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/5 X-Sequence-Number: 3847 LonLinux wrote: > Hello, I have this problem with a connection to postgres server (running > in a win2000 server). > When I connect with pgAdmin to the same postgres server works ok, but > when I try to connect from php5 the connection fails. What error message do you get? echo pg_last_error($db_conn); -- Postgresql & php tutorials http://www.designmagick.com/ From arun.oakley@gmail.com Fri Sep 4 04:20:17 2009 Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 219DE634190 for ; Fri, 4 Sep 2009 01:20:17 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 72808-01 for ; Fri, 4 Sep 2009 04:20:04 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-pz0-f200.google.com (mail-pz0-f200.google.com [209.85.222.200]) by mail.postgresql.org (Postfix) with ESMTP id 47C5F632EED for ; Fri, 4 Sep 2009 01:20:04 -0300 (ADT) Received: by pzk38 with SMTP id 38so409640pzk.5 for ; Thu, 03 Sep 2009 21:20:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type; bh=XWgPEBevtmsuib6QeiX0JA3ELlMQ/jr7m6BbigUHziY=; b=Z10MXlWdkwKDVjgnDdHVGA92hG8+SJc0wFNtjuCxQegrtkI2SAojJYEhhQ+L1qU+kG JbeJq+O+padZD78x+DWIISxBN18rUOO/O/v+F9jpi15uTzT93/G5qt9+c9qJorba2V3H u9AakefFQS8wWfbc1cxNOlegrEIzvPBO3FlfE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=L5BAU/wUUJUZl8EuWPIvuHmUumyatcEZk2eDTxjh8BS5b4w7W0zxNC5dRKoZySREH+ 9irmKNmWx1VNnirSJwNd5UWXj0lGvrnhrmcRG8JZa9CG1Ol899zdlB7zQMOZ4vy7MTCo IDopot6QxLFoJT1QC6dnhczQLr+loPoFrcvfo= MIME-Version: 1.0 Received: by 10.115.81.21 with SMTP id i21mr9313909wal.125.1252037999391; Thu, 03 Sep 2009 21:19:59 -0700 (PDT) Date: Fri, 4 Sep 2009 14:19:59 +1000 Message-ID: Subject: pg_connect() error From: Arun Oakley To: pgsql-php@postgresql.org Content-Type: multipart/alternative; boundary=0016e64de80e32f52d0472b8d06f X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.598 tagged_above=-10 required=5 tests=BAYES_00=-2.599, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200909/12 X-Sequence-Number: 4070 --0016e64de80e32f52d0472b8d06f Content-Type: text/plain; charset=ISO-8859-1 hi guys, we have a postgres db with a hosting company and have been trying to connect to. error is below. *Warning*: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: could not connect to server: Connection refused Is the server running on host "pgdb1.host-ed.net" and accepting TCP/IP connections on port 3306? from my trawling around google i have found that it could be related to the postgres.conf file and turning on tcpip sockets to true?? (i cannot view/edit any postgres conf files) oh and those are the host/port details supplied by hosting provider any help would be appreciated in pointing on the right path. Cheers Arun --0016e64de80e32f52d0472b8d06f Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable hi guys,

we have a postgres db with a hosting company an= d have been trying to connect to. error is below.
Warning: pg_connect() [function.pg-connect]: Unable to connect to Post= greSQL server: could not connect to server: Connection refused Is the serve= r running on host "pgdb1.host-ed.= net" and accepting TCP/IP connections on port 3306?

from my trawling around google i have found that it cou= ld be related to the postgres.conf file and turning on tcpip sockets to tru= e?? (i cannot view/edit any postgres conf files)

oh and those are the host/port details supplied by hosting provider


any help would be appreciated in pointing = on the right path.

Cheers

Arun
--0016e64de80e32f52d0472b8d06f-- From dmagick@gmail.com Thu Sep 10 22:51:33 2009 Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id BD57D634831 for ; Thu, 10 Sep 2009 19:51:33 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 10037-03 for ; Thu, 10 Sep 2009 22:51:25 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-pz0-f191.google.com (mail-pz0-f191.google.com [209.85.222.191]) by mail.postgresql.org (Postfix) with ESMTP id 84916634006 for ; Thu, 10 Sep 2009 19:51:25 -0300 (ADT) Received: by pzk29 with SMTP id 29so436212pzk.14 for ; Thu, 10 Sep 2009 15:51:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:cc:subject:references:in-reply-to :content-type:content-transfer-encoding; bh=NarpWNsaTS3Glqz7ecIYb1TmsGwLI8qz0H8HlJJ9nrE=; b=Y3r9Y55ldlvMswMkPK1Nyo1DldSGSkeK1TeTHXv5+ThIWAILdmAET9lByDS+pXTOwh k5muG8kUYM2yGGe+gNesWWepMfVOX6DHwYZq+9UDX25Ey3Bn/JEBZ7rda78U4/5Er0wr b/bQXvUmmy3d+6jFMLu2LEk4cfkmL4d4/G7zM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:content-transfer-encoding; b=XTNsRIXo03YjShpCFYWdkpb1MliIyN0B1lTSjpzX1UxocqsxHaXhzSlCj4cBgcbWmo O5M4v3A4Xl5OjRJy7XhSSWbLOsRQZwkRDXTrA98YA4/uwmcG7PkYRO6Yo3wEd23siYSy bnGOfhuRL3OtFETHLfNUJRUYl/1UQ4on9pm4s= Received: by 10.115.86.19 with SMTP id o19mr3930440wal.9.1252623083602; Thu, 10 Sep 2009 15:51:23 -0700 (PDT) Received: from ?192.168.2.65? (office.squiz.net [203.206.128.174]) by mx.google.com with ESMTPS id 21sm793901pzk.7.2009.09.10.15.51.20 (version=TLSv1/SSLv3 cipher=RC4-MD5); Thu, 10 Sep 2009 15:51:22 -0700 (PDT) Message-ID: <4AA982E2.1050807@gmail.com> Date: Fri, 11 Sep 2009 08:51:14 +1000 From: Chris User-Agent: Thunderbird 2.0.0.23 (X11/20090817) MIME-Version: 1.0 To: Arun Oakley CC: pgsql-php@postgresql.org Subject: Re: pg_connect() error References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.644 tagged_above=-10 required=5 tests=BAYES_00=-2.599, URIBL_BLACK=1.955 X-Spam-Level: X-Archive-Number: 200909/14 X-Sequence-Number: 4072 Arun Oakley wrote: > hi guys, > > we have a postgres db with a hosting company and have been trying to > connect to. error is below. > *Warning*: pg_connect() [function.pg-connect > ]: Unable to connect to > PostgreSQL server: could not connect to server: Connection refused Is > the server running on host "pgdb1.host-ed.net > " and accepting TCP/IP connections on port 3306? Port 3306 is usually mysql not postgres. Postgres (by default) uses 5432. > from my trawling around google i have found that it could be related to > the postgres.conf file and turning on tcpip sockets to true?? (i cannot > view/edit any postgres conf files) > oh and those are the host/port details supplied by hosting provider > > > any help would be appreciated in pointing on the right path. Make sure they know you want a postgres db, not mysql. Apart from that, if you can't view a postgres.conf file let alone change it, you need to raise a support issue with them to fix it. Do they allow remote connections to their database? Maybe they don't for security reasons. -- Postgresql & php tutorials http://www.designmagick.com/