Cannot manage PostgreSQL DBs/Tables with phpPgAdmin

[Oldiesmann]

I am running CentOS 7 with PostgreSQL 9.2.18 and the latest release version of cPanel/WHM (it's a VPS). I mostly use PostgreSQL to test a forum script that I am a developer for. Recently we added a few more columns to one of the database tables. Since it's a development version, the simplest option was to go into phpPgAdmin and add the columns. However, upon trying to execute the changes, I just get an error saying "Error: must be owner of relation <table>". This is when logged in to cPanel as the account owner (not as root). All of the tables are owned by the user that created them, but the cPanel user doesn't have the appropriate privileges to fix the tables. I even tried granting the cPanel user all privileges on the database (which I was able to do), but I couldn't grant that user privileges. The only way I was able to add the columns was to login to PostgreSQL via the shell as the user that owned the database.

In WHM I went in to the "Configure PostgreSQL" section and clicked "add users", but now trying to log in to phpPgAdmin fails entirely (it just says "Login failed").

 

[cPanelMichael]

Hello,

Our PostgreSQL Databases document offers a note that may explain the issue you are experiencing:

Some versions of PostgreSQL are ANSI SQL-92 compliant and do not support recursive grants, wildcard grants, or future grants. To ensure that users continue to have access the information in your PostgreSQL tables, click Synchronize Grants.

We recommend that you synchronize the grants after you take the following actions:

• Add a new user.
• Add an existing user to a database.
• Create a new table manually in phpPGAdmin.

Could you let us know if using the Synchronize Grants option helps?

Thank you.

 

[Oldiesmann]

The only way I'm able to login is if I use the synchronize grants option. However, I'm still unable to add columns to a table created by one of the database users.

 

[cPanelMichael]

Hello,

Could you open a support ticket using the link in my signature so we can take a closer look? You can post the ticket number here so we can update this thread with the outcome.

Thank you.

 

[Oldiesmann]

Thanks. The ticket ID is 8129137. I also referenced this topic in the ticket.

 

[cPanelMichael]

Thanks. The ticket ID is 8129137. I also referenced this topic in the ticket.

Hello,

To update, it looks like the issue was not reproducible and is no longer occurring.

Thanks!