08-24-2010, 01:24 PM | #1 |
Junior Member
Join Date: Apr 2010
Posts: 19
|
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 Last edited by MV1980; 08-24-2010 at 01:32 PM. |
|
|