Server Management - Systems Insight Manager
1843946 Members
2013 Online
110226 Solutions
New Discussion

Re: 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/