Obtain PostgreSQL password
 

Hi, we have installed postgreSQL with ispmanager.

Ispmanager can connect to postreSQL and create users.

But we don't remember the 'root' password of postgreSQL.

So my question is where does ispmanager keeps the root password of postgreSQL ?

By reading the documentation:
http://en.ispdoc.com/index.php/ISPma...%29#PostgreSQL

"
The following directives will be added into the control panel [devel.config configuration file]:

DbServer "Postgres" { Type pgsql Hostname localhost User pgsql Password password }

Since the only mode providing Postgres installation is Custom, the installation program will ask you to enter pgsql user password. Once you have done, the password will be set by the command

psql -U pgsql -c "ALTER USER pgsql WITH PASSWORD 'password'" template1

The lines below will be added into Postgres configuration file and then Postgres restart will follow

#TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD local all pgsql password local template1 all password
"

But we can't find any file named "devel.config"


Thank you

To obtain the password visit page "database servers" and make double click on "PostrgeSQL" item

Thank you.

Problem solved