Re: Install postgresql in different box

Just finished postgresql installation. But when I tried to install opennms
in another box. It checked the dependency which need postgresql 7.4 above in
that box. I don't have postgresql in that box. So in order to get opennms
installed in different box, I should install another postgresql with opennms
in the same box? After installation of opennms, I then point to the
dedicated postgresql box?

Thanks!

Lou

On Wed, May 11, 2011 at 12:28 PM, Hailu Meng <[email protected]> wrote:

> 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