From dufuzzy@yahoo.com.br Wed Mar 31 00:08:28 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 6E11DD1D12E for ; Wed, 31 Mar 2004 00:08:28 +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 50077-07 for ; Tue, 30 Mar 2004 20:08:28 -0400 (AST) Received: from smtp017.mail.yahoo.com (smtp017.mail.yahoo.com [216.136.174.114]) by svr1.postgresql.org (Postfix) with SMTP id 41A08D1D16D for ; Tue, 30 Mar 2004 20:08:25 -0400 (AST) Received: from unknown (HELO casa) (dufuzzy@200.103.144.163 with login) by smtp017.mail.yahoo.com with SMTP; 31 Mar 2004 00:08:27 -0000 Message-ID: <017a01c416b4$53e1fc60$0501010a@casa> From: "Eduardo Sachwek Fontanetti" To: Subject: Accessing Linux Postgre Server from windows client Date: Tue, 30 Mar 2004 21:08:40 -0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0177_01C4169B.2D2A5EF0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=2.7 tagged_above=0.0 required=5.0 tests=BAYES_44, HTML_MESSAGE, RCVD_IN_DSBL, RCVD_IN_NJABL, RCVD_IN_NJABL_PROXY, RCVD_IN_SORBS, RCVD_IN_SORBS_SOCKS X-Spam-Level: ** X-Archive-Number: 200403/396 X-Sequence-Number: 12965 This is a multi-part message in MIME format. ------=_NextPart_000_0177_01C4169B.2D2A5EF0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable How can I do it? I really can't, something is not working and when I try to= connect to the postgreSQL server Linux machine from the PgAdmin III, it sa= ys me that cant connect, and say me to check the port (5432). What may be wrong? I got just installed the Postgre on linux, and it is answering properly to = the psql test command. I've checked the IPTables too, I've tried to disable it and try to connect,= and the problem continues... Somebody could help me? Thanks a lot! Eduardo --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.644 / Virus Database: 412 - Release Date: 26/3/2004 ------=_NextPart_000_0177_01C4169B.2D2A5EF0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
How can I do it? I really can't, something= is not=20 working and when I try to connect to the postgreSQL server Linux machine fr= om=20 the PgAdmin III, it says me that cant connect, and say me to check the port= =20 (5432).
 
What may be wrong?
 
I got just installed the Postgre on linux,= and it=20 is answering properly to the psql test command.
 
I've checked the IPTables too, I've tried = to=20 disable it and try to connect, and the problem continues...
 
Somebody could help me?
 
Thanks a lot!
Eduardo
 

---
Outgoing mail is certified Viru= s=20 Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.= 0.644 /=20 Virus Database: 412 - Release Date: 26/3/2004
------=_NextPart_000_0177_01C4169B.2D2A5EF0-- From jseymour@LinxNet.com Wed Mar 31 00:24:20 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B3AD1D1DB51 for ; Wed, 31 Mar 2004 00:24: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 54988-09 for ; Tue, 30 Mar 2004 20:24:20 -0400 (AST) Received: from jimsun.LinxNet.com (jimsun.linxnet.com [64.32.196.134]) by svr1.postgresql.org (Postfix) with ESMTP id 0B3DAD1DB53 for ; Tue, 30 Mar 2004 20:24:17 -0400 (AST) Received: by jimsun.LinxNet.com (Postfix, from userid 332) id C5D9C4307; Tue, 30 Mar 2004 19:24:19 -0500 (EST) To: pgsql-admin@postgresql.org Subject: Re: Accessing Linux Postgre Server from windows client X-Sun-Charset: US-ASCII Reply-To: pgsql-admin@postgresql.org In-Reply-To: <017a01c416b4$53e1fc60$0501010a@casa> Message-Id: <20040331002419.C5D9C4307@jimsun.LinxNet.com> Date: Tue, 30 Mar 2004 19:24:19 -0500 (EST) From: jseymour@LinxNet.com (Jim Seymour) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/398 X-Sequence-Number: 12967 "Eduardo Sachwek Fontanetti" wrote: > > How can I do it? I really can't, something is not working and when I > try to connect to the postgreSQL server Linux machine from the PgAdmin > III, it says me that cant connect, and say me to check the port > (5432). > > What may be wrong? Check the pg_hba.conf file in your PGDATA directory. Note that it, in turn, refers you to a setting in postgresql.conf. Note also that, as the notes in pg_hba.conf say, you must either SIGHUP postmaster or do a pg_ctl reload after modifying these files. Jim From s.barnett-cormack@lancaster.ac.uk Wed Mar 31 00:24:04 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A385BD1D643 for ; Wed, 31 Mar 2004 00:24:04 +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 53000-10 for ; Tue, 30 Mar 2004 20:24:04 -0400 (AST) Received: from zooty.lancs.ac.uk (zooty.lancs.ac.uk [148.88.16.231]) by svr1.postgresql.org (Postfix) with ESMTP id 1A1E8D1D9E9 for ; Tue, 30 Mar 2004 20:24:01 -0400 (AST) Received: from mail.lancs.ac.uk ([148.88.1.10] helo=marl.lancs.ac.uk) by zooty.lancs.ac.uk with esmtp (Exim 4.30) id 1B8TWV-0002Ym-Jm; Wed, 31 Mar 2004 01:24:03 +0100 Received: from faa034000015.lancs.ac.uk ([148.88.81.14]) by marl.lancs.ac.uk with esmtp (Exim 3.36 #1) id 1B8TWV-0003Dr-00; Wed, 31 Mar 2004 01:24:03 +0100 Date: Wed, 31 Mar 2004 01:27:08 +0100 (BST) From: Sam Barnett-Cormack X-X-Sender: sdb@short.lancs.ac.uk To: Eduardo Sachwek Fontanetti Cc: pgsql-admin@postgresql.org Subject: Re: Accessing Linux Postgre Server from windows client In-Reply-To: <017a01c416b4$53e1fc60$0501010a@casa> Message-ID: References: <017a01c416b4$53e1fc60$0501010a@casa> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/397 X-Sequence-Number: 12966 Have you actually enabled the tcp/ip option of the postgres server? By default, it only enables local clients via Unix domain sockets. On Tue, 30 Mar 2004, Eduardo Sachwek Fontanetti wrote: > How can I do it? I really can't, something is not working and when I try to connect to the postgreSQL server Linux machine from the PgAdmin III, it says me that cant connect, and say me to check the port (5432). > > What may be wrong? > > I got just installed the Postgre on linux, and it is answering properly to the psql test command. > > I've checked the IPTables too, I've tried to disable it and try to connect, and the problem continues... > > Somebody could help me? > > Thanks a lot! > Eduardo > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.644 / Virus Database: 412 - Release Date: 26/3/2004 -- Sam Barnett-Cormack Software Developer | Student of Physics & Maths UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University From gsw@globexplorer.com Wed Mar 31 00:36:55 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 92590D1DB51 for ; Wed, 31 Mar 2004 00:36:55 +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 61783-09 for ; Tue, 30 Mar 2004 20:36:56 -0400 (AST) Received: from loki.globexplorer.com (unknown [208.35.14.101]) by svr1.postgresql.org (Postfix) with ESMTP id AF862D1CC92 for ; Tue, 30 Mar 2004 20:36:50 -0400 (AST) X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C416B8.44FCACA7" Subject: Re: Accessing Linux Postgre Server from windows client Date: Tue, 30 Mar 2004 16:36:56 -0800 Message-ID: <71E37EF6B7DCC1499CEA0316A2568328DC9B7F@loki.wc.globexplorer.net> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] Accessing Linux Postgre Server from windows client Thread-Index: AcQWt+qsuHdYNNt/THSHPRD01jSLcAAApJvg From: "Gregory S. Williamson" To: "Eduardo Sachwek Fontanetti" , X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/399 X-Sequence-Number: 12968 This is a multi-part message in MIME format. ------_=_NextPart_001_01C416B8.44FCACA7 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Check the log file for the postgres instance you are connecting to -- it ma= y be that pg_hba.conf file does not have your client server listed; the log= file would show that error. =20 Greg Williamson DBA GlobeXplorer LLC -----Original Message----- From: Eduardo Sachwek Fontanetti [mailto:dufuzzy@yahoo.com.br] Sent: Tuesday, March 30, 2004 4:09 PM To: pgsql-admin@postgresql.org Subject: [ADMIN] Accessing Linux Postgre Server from windows client How can I do it? I really can't, something is not working and when I try to= connect to the postgreSQL server Linux machine from the PgAdmin III, it sa= ys me that cant connect, and say me to check the port (5432). =20 What may be wrong? =20 I got just installed the Postgre on linux, and it is answering properly to = the psql test command. =20 I've checked the IPTables too, I've tried to disable it and try to connect,= and the problem continues... =20 Somebody could help me? =20 Thanks a lot! Eduardo =20 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system ( http://www.grisoft.com). Version: 6.0.644 / Virus Database: 412 - Release Date: 26/3/2004 ------_=_NextPart_001_01C416B8.44FCACA7 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Check=20 the log file for the postgres instance you are connecting to -- it may be t= hat=20 pg_hba.conf file does not have your client server listed; the log file woul= d=20 show that error.
 
Greg=20 Williamson
DBA
GlobeXplorer LLC
-----Original Message-----
From: Eduardo Sachwek Fonta= netti=20 [mailto:dufuzzy@yahoo.com.br]
Sent: Tuesday, March 30, 2004 4:0= 9=20 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN]=20 Accessing Linux Postgre Server from windows client

How can I do it? I really can't, somethi= ng is not=20 working and when I try to connect to the postgreSQL server Linux machine = from=20 the PgAdmin III, it says me that cant connect, and say me to check the po= rt=20 (5432).
 
What may be wrong?
 
I got just installed the Postgre on linu= x, and it=20 is answering properly to the psql test command.
 
I've checked the IPTables too, I've trie= d to=20 disable it and try to connect, and the problem continues...
 
Somebody could help me?
 
Thanks a lot!
Eduardo
 

---
Outgoing mail is certified Vi= rus=20 Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: = 6.0.644=20 / Virus Database: 412 - Release Date:=20 26/3/2004
------_=_NextPart_001_01C416B8.44FCACA7-- From s.barnett-cormack@lancaster.ac.uk Wed Mar 31 00:56:27 2004 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 5EEECD1DB51 for ; Wed, 31 Mar 2004 00:56:27 +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 71972-02 for ; Tue, 30 Mar 2004 20:56:28 -0400 (AST) Received: from zooty.lancs.ac.uk (zooty.lancs.ac.uk [148.88.16.231]) by svr1.postgresql.org (Postfix) with ESMTP id A2758D1DB0E for ; Tue, 30 Mar 2004 20:56:25 -0400 (AST) Received: from mail.lancs.ac.uk ([148.88.1.10] helo=marl.lancs.ac.uk) by zooty.lancs.ac.uk with esmtp (Exim 4.30) id 1B8U1r-0004jA-4l; Wed, 31 Mar 2004 01:56:27 +0100 Received: from faa034000015.lancs.ac.uk ([148.88.81.14]) by marl.lancs.ac.uk with esmtp (Exim 3.36 #1) id 1B8U1q-00044G-00; Wed, 31 Mar 2004 01:56:26 +0100 Date: Wed, 31 Mar 2004 01:59:32 +0100 (BST) From: Sam Barnett-Cormack X-X-Sender: sdb@short.lancs.ac.uk To: "Gregory S. Williamson" Cc: Eduardo Sachwek Fontanetti , pgsql-admin@postgresql.org Subject: Re: Accessing Linux Postgre Server from windows client In-Reply-To: <71E37EF6B7DCC1499CEA0316A2568328DC9B7F@loki.wc.globexplorer.net> Message-ID: References: <71E37EF6B7DCC1499CEA0316A2568328DC9B7F@loki.wc.globexplorer.net> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/400 X-Sequence-Number: 12969 On Tue, 30 Mar 2004, Gregory S. Williamson wrote: > Check the log file for the postgres instance you are connecting to -- > it may be that pg_hba.conf file does not have your client server > listed; the log file would show that error. The client *ought* to report that error as well. > -----Original Message----- > From: Eduardo Sachwek Fontanetti [mailto:dufuzzy@yahoo.com.br] > Sent: Tuesday, March 30, 2004 4:09 PM > To: pgsql-admin@postgresql.org > Subject: [ADMIN] Accessing Linux Postgre Server from windows client > > > How can I do it? I really can't, something is not working and when I try to connect to the postgreSQL server Linux machine from the PgAdmin III, it says me that cant connect, and say me to check the port (5432). > > What may be wrong? > > I got just installed the Postgre on linux, and it is answering properly to the psql test command. > > I've checked the IPTables too, I've tried to disable it and try to connect, and the problem continues... > > Somebody could help me? > > Thanks a lot! > Eduardo > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system ( http://www.grisoft.com). > Version: 6.0.644 / Virus Database: 412 - Release Date: 26/3/2004 > > -- Sam Barnett-Cormack Software Developer | Student of Physics & Maths UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University