Server Management - Systems Insight Manager
1843927 Members
1493 Online
110226 Solutions
New Discussion

Postgres Database password

 
Lars Oeschey
Advisor

Postgres Database password

Hi,

we want to read some values from the database to generate some web-pages from it. How can I get or change the password that HPSIM uses in the postgres database?

Lars
1 REPLY 1
Lars Nilsson_1
Trusted Contributor

Re: Postgres Database password

HPSIM uses the account mxadmin in PostgreSQL. I don't know much about Postgres, but on a SUSE (SLES9) you get it logged in as root by entering:

/opt/mx/bin/mxpassword -l
(-l like in -L)

You also may have to set up rights to access the database from other hosts by editing the files postgresql.conf and pg_hba.conf

If you run Webmin on your HPSIM-server you can do some of it from there.

You find all the PostgreSQL documentation on: http://www.postgresql.org/