ISPsystem.com Forums - View Single Post

MV1980 · 08-24-2010, 01:24 PM

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

08-24-2010, 01:24 PM	#1
MV1980 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.