Install postgresql in different box

Hi All,

I was trying to find some guide for installing postgresql on different box.
But no luck to get detail about the configuration for pgsql. So I need
modify the pg_hba.conf and postgresql.conf right? I modified pg_hba.conf as
below:

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only
local   all         all                               trust
# IPv4 local connections:
host    all         all         127.0.0.1/32          trust
#host   all         all         opennms_ip/32          trust
# IPv6 local connections:
host    all         all         ::1/128               trust

I also changed the listening ip in postgresql.conf:
listen_addresses = 'localhost,opennms_ip'

For OpenNMS, I need change $OPENNMS_HOME/etc/opennms-datasources.xml as

<jdbc-data-source name="opennms"
               database-name="*dbname*"
               class-name="org.postgresql.Driver"
               url="jdbc:postgresql://*dbhost*:*5432*/*dbname*"
               user-name="*username*"
password="*password*" />



is this all I need to do to have it work? Thanks!

Lou

------------------------------------------------------------------------------
Achieve unprecedented app performance and reliability
What every C/C++ and Fortran developer should know.
Learn how Intel has extended the reach of its next-generation tools
to help boost performance applications - inlcuding clusters.
http://p.sf.net/sfu/intel-dev2devmay

_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-install mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-install