Symptoms
When using phpPgAdmin to view a sequence within a database, an error similar to the following is shown:
SQL error:
ERROR: permission denied for relation table_name_seq
Description
This issue is caused by missing or incorrect grants for the cPanel user to the Postgres database sequences.
Workaround
To re-add the grants for the cPanel user to the database, perform the following via SSH:
Access the Postgres Shell:
psql -U postgres
Connect to the affected database
\c user_database
Add the grants for the cPanel user to the Database:
user_database=# GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO user;
Example output of the process is below:
# psql -U postgres
psql (9.2.24)
Type "help" for help.
postgres=# \c user_database
You are now connected to database "user_database" as user "postgres".
user_database=# GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO user;
GRANT
user_database-# \q