Dear friends,
I am working with Postgres 7.3.4 on RH Linux 7.3.
I could manage to take a backup using the following command and as the user 'postgres'.
$ pg_dump -h 192.168.2.51 -v -u -f /home/db_repository/test20031103.sql test
But while I try to execute the same command with the user 'kumar', it gives me the following error
>>
pg_dump: query to get data of sequence "clients_client_id_seq" failed: ERROR: clients_client_id_seq: permission denied
pg_dump: *** aborted because of error
But as the user 'kumar' I could manage to get the next value of the sequence with the following command
select nextval('test.clients_client_id_seq');
Previously, user 'postgres' is the owner of the database and I have changed that to 'kumar' via the following command
UPDATE pg_database SET datdba = 105 where datname = 'test';
Even though I am the owner of the sequence, why I am getting this error. Anybody could shed some light, pls.
Regards
Kumar