PostgreSQL problem...where is phppgadmin?

[Annibal]

Good morning,
I had installed PostgreSQL using /scripts/installpostgres and updated apache through EasyApache.

In the "SQL Services" i got only the "Postgres Config" icon and nothing else .

In "Service Manager" I have the postgresql's options (enable and monitor) both checked.
In the "service monitor" postgresql results up and running.

In /usr/local/cpanel/base/3rdparty there is the phpPgAdmin directory...but how to access it? how to create a database through the WHM interface? Why there is not the phppgadmin icon?

Any suggestion is appreciated,
thank you!

Configuration:
cPanel 11.24.4-R36167 - WHM 11.24.2 - X 3.9
CENTOS 5.3 i686

 

[cPanelDavidG]

Good morning,
I had installed PostgreSQL using /scripts/installpostgres and updated apache through EasyApache.

In the "SQL Services" i got only the "Postgres Config" icon and nothing else .

In "Service Manager" I have the postgresql's options (enable and monitor) both checked.
In the "service monitor" postgresql results up and running.

In /usr/local/cpanel/base/3rdparty there is the phpPgAdmin directory...but how to access it? how to create a database through the WHM interface? Why there is not the phppgadmin icon?

Any suggestion is appreciated,
thank you!

Configuration:
cPanel 11.24.4-R36167 - WHM 11.24.2 - X 3.9
CENTOS 5.3 i686

In WHM you will need to set your root password for Postgres and go through Postgres Config in WHM.

Don't forget to recompile PHP so that PostgreSQL can be used via PHP.

 

[Annibal]

Hello and thank you for your reply but i'm not sure to understanding what you saying:

"In WHM you will need to set your root password for Postgres"

Does that means that in Main >> SQL Services >> Postgre config, in the field "Postgres Password" i have to write my SERVER root password???

By enter in that field any password (no my server root password) I get this message "postmaster signaled ALTER ROLE postmaster signaled Password successfully changed".

Then in that page I have only a button: "Install Postgres Config" that once pressed gives me: "Configuration successfully updated postmaster signaled"

"Don't forget to recompile PHP so that PostgreSQL can be used via PHP. "
I did it.

My main question is: is normal that logged as root in WHM i don't have the phppgadmin icon? I have the phppgadmin icon only logged with a normal domain user account.

I'm sorry i'm a newbie with cpanel i'm migrating from plesk.

Thanks again

 

[fineline]

I think what he means is when you log into your WHM
Under SQL Services you will see "MySQL Root Password"
There should also be a place to set the root password for Postgres also

This might help you too.

On your navigation pane on the left In the "Find" box
type "post" this should help you see the Postgres links
and eliminate most the others.

Once you change your password for it then you will need to go through the

"Postgres Config"

After that then you will need to recompile PHP so that PostgreSQL can be used via PHP.

 

[Annibal]

> Under SQL Services you will see "MySQL Root Password"
> There should also be a place to set the root password for Postgres also

Hello fineline and thank you.

I have in Main >> SQL Services >> Postgres Config, a field called "Postgres Password" and that's it.

> On your navigation pane on the left In the "Find" box
> type "post" this should help you see the Postgres links
> and eliminate most the others.

Nice trick! however didn't find anything new and where is supposed to be the phppgadmin icon for the server administrator?

Again, thanks!