Thread: Accessing Linux Postgre Server from windows client

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
machinefrom 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

"Eduardo Sachwek Fontanetti" <dufuzzy@yahoo.com.br> 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

-----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

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
machinefrom 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