Postgres Pro
Downloads
Home   >   mailing lists

Thread: Postgre Sql 7.3 connection problem

Postgre Sql 7.3 connection problem

From
nij es
Date:
sir,

I am using postgresql 7.3 in Redhat Linux.Windows XP is my client. I want to communicate pgsql without a specific ip rangeI.I want to accept all ip address in postgresql 7.3. How can i comunicate. Please help me to solve this problem.

Ahhh...imagining that irresistible "new car" smell?
Check out new cars at Yahoo! Autos.

Re: Postgre Sql 7.3 connection problem

From
"Martin Gainty"
Date:
try
vi postgres_home/data/postgresql.conf
 
#list comma delimited IP addresses for this server to listen on
#listen on just localhost by uncommenting this line
#listen_addresses = 'localhost' 
 
M--
This email message and any files transmitted with it contain confidential
information intended only for the person(s) to whom this email message is
addressed.  If you have received this email message in error, please notify
the sender immediately by telephone or email and destroy the original
message without making a copy.  Thank you.
----- Original Message -----
From: nij es
Sent: Monday, May 07, 2007 3:39 AM
Subject: [GENERAL] Postgre Sql 7.3 connection problem

sir,

I am using postgresql 7.3 in Redhat Linux.Windows XP is my client. I want to communicate pgsql without a specific ip rangeI.I want to accept all ip address in postgresql 7.3. How can i comunicate. Please help me to solve this problem.

Ahhh...imagining that irresistible "new car" smell?
Check out new cars at Yahoo! Autos.

Re: Postgre Sql 7.3 connection problem

From
"A. Kretschmer"
Date:
am  Mon, dem 07.05.2007, um  0:39:43 -0700 mailte nij es folgendes:
> sir,
>
> I am using postgresql 7.3 in Redhat Linux.Windows XP is my client. I want to
> communicate pgsql without a specific ip rangeI.I want to accept all ip address
> in postgresql 7.3. How can i comunicate. Please help me to solve this problem.

First, 7.3 are out of date...

You should check if your PG-Server listening on TCP/IP. Take a look into
your postgresql.conf, you need an entry like 'listen_addresses = ...'.
Then check your pg_hba.conf, you need a propper line with 'host' at the
beginning of the line, like:

host    all     all     192.168.1.0       255.255.255.0   trust


And, again, 7.3 are very, very old.


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

Re: Postgre Sql 7.3 connection problem

From
Osvaldo Rosario Kussama
Date:
A. Kretschmer escreveu:
> am  Mon, dem 07.05.2007, um  0:39:43 -0700 mailte nij es folgendes:
>> sir,
>>
>> I am using postgresql 7.3 in Redhat Linux.Windows XP is my client. I want to
>> communicate pgsql without a specific ip rangeI.I want to accept all ip address
>> in postgresql 7.3. How can i comunicate. Please help me to solve this problem.
>
> First, 7.3 are out of date...
>
> You should check if your PG-Server listening on TCP/IP. Take a look into
> your postgresql.conf, you need an entry like 'listen_addresses = ...'.

Valid only in 8.+ versions. In 7.3 was:
TCPIP_SOCKET = true


> Then check your pg_hba.conf, you need a propper line with 'host' at the
> beginning of the line, like:
>
> host    all     all     192.168.1.0       255.255.255.0   trust
>
>
> And, again, 7.3 are very, very old.


[]s
Osvaldo

Re: Postgre Sql 7.3 connection problem

From
"A. Kretschmer"
Date:
am  Mon, dem 07.05.2007, um 17:15:04 -0300 mailte Osvaldo Rosario Kussama folgendes:
> >First, 7.3 are out of date...
> >
> >You should check if your PG-Server listening on TCP/IP. Take a look into
> >your postgresql.conf, you need an entry like 'listen_addresses = ...'.
>
> Valid only in 8.+ versions. In 7.3 was:
> TCPIP_SOCKET = true

Thanks for the rectification.


--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net