Postgre Sql 7.3 connection problem

Started by nij esalmost 19 years ago5 messagesgeneral
Jump to latest
#1nij es
nijeshonline@yahoo.com

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 outnew cars at Yahoo! Autos.

#2Martin Gainty
mgainty@hotmail.com
In reply to: nij es (#1)
Re: Postgre Sql 7.3 connection problem

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
To: pgsql-general@postgresql.org
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.

#3A. Kretschmer
andreas.kretschmer@schollglas.com
In reply to: nij es (#1)
Re: Postgre Sql 7.3 connection problem

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

#4Osvaldo Rosario Kussama
osvaldo_kussama@yahoo.com.br
In reply to: A. Kretschmer (#3)
Re: Postgre Sql 7.3 connection problem

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

#5A. Kretschmer
andreas.kretschmer@schollglas.com
In reply to: Osvaldo Rosario Kussama (#4)
Re: Postgre Sql 7.3 connection problem

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