Re: Install postgresql in different box
Hailu Meng <[email protected]>
| Newsgroups | gmane.network.opennms.install |
|---|---|
| Message-ID | <[email protected]> |
Anyone? Thanks guys. Lou On Wed, May 11, 2011 at 12:42 PM, Hailu Meng <[email protected]> wrote: > 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