Thank you, it is written in the manual, but here's an example remotely necessary, and such command pg_dump -i-h dbxx -user_crm U-C-F p user_crm, gives pg_dump: SQL command failed and then pg_dump: Error message from server: ERROR: permission denied for relation pg_namespace, it is not clear or commands in the wrong order or something with the authentication. - Arely.Casper commented on July 8th 19 at 16:41
:
>> ERROR: permission denied for relation pg_namespace
The error suggests that your user user_crm no right even to read the signs pg_namespace.
Get two outputs
1). Queried this table from user with higher privileges
2). Give this user privileges to this table https://www.postgresql.org/docs/9.4/static/sql-gra...
Conduct a session of fortune-telling by the name the user has rights to look at the system table should not be:) - herman.Labadie commented on July 8th 19 at 16:44
>> ERROR: permission denied for relation pg_namespace
The error suggests that your user user_crm no right even to read the signs pg_namespace.
Get two outputs
1). Queried this table from user with higher privileges
2). Give this user privileges to this table
https://www.postgresql.org/docs/9.4/static/sql-gra...
Conduct a session of fortune-telling by the name the user has rights to look at the system table should not be:) - herman.Labadie commented on July 8th 19 at 16:44