Postgre, the next stage..

[Ken Dimson]

You will need to check the settings for the Postgresql server.

Which operating system are you using?

Find the file postgresql.conf possibly as below on Linux. 

Linux
/var/lib/pgsql/data/postgresql.conf

Note the following setting:
# - Connection Settings -

listen_addresses = 'localhost' # what IP address(es) to listen on; 
					# comma-separated list of addresses;
					# defaults to 'localhost', '*' = all

Changing this setting and restarting the Postgresql server will allow the
server to listen on more than localhost.

Next you need to allow specific users access

Find the file pg_hba.conf in the same directory as above
This file outlines how to add access for a user to specific databases, all
databases from specific ips etc.

Ken


-----Original Message-----
From: omnisdev-en-bounces at lists.omnis-dev.com
[mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf Of Chuck Kirkman
Sent: Friday, May 16, 2008 8:16 PM
To: OmnisDev List - English
Subject: Postgre, the next stage..

Hi $all,
I have a Postgre database setup and working, but only as "localhost".  
How do I change that to allow other users to connect?  In my setup  
method to logon I use the following:

Calculate idatabase as 'localhost'
Calculate idatabasename as 'comserve'
Calculate itusername as 'postgres'
Calculate ituserpassword as '*********'
Calculate isessionname as 'comserve'

TIA
Chuck Kirkman
_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com

No virus found in this incoming message.
Checked by AVG. 
Version: 7.5.524 / Virus Database: 269.23.16/1446 - Release Date: 5/16/2008
7:42 AM
 

No virus found in this outgoing message.
Checked by AVG. 
Version: 7.5.524 / Virus Database: 269.23.16/1446 - Release Date: 5/16/2008
7:42 AM