Обсуждение: Accessing Linux Postgre Server from windows client

Поиск
Список
Период
Сортировка

Accessing Linux Postgre Server from windows client

От
"Eduardo Sachwek Fontanetti"
Дата:
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

Re: Accessing Linux Postgre Server from windows client

От
Sam Barnett-Cormack
Дата:
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

Re: Accessing Linux Postgre Server from windows client

От
jseymour@LinxNet.com (Jim Seymour)
Дата:
"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

Re: Accessing Linux Postgre Server from windows client

От
"Gregory S. Williamson"
Дата:
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.
 
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 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

Re: Accessing Linux Postgre Server from windows client

От
Sam Barnett-Cormack
Дата:
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