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