pg_dump error - Permission denied

From: "Kumar" <sgnerd(at)yahoo(dot)com(dot)sg>
To: "psql" <pgsql-sql(at)postgresql(dot)org>
Subject: pg_dump error - Permission denied
Date: 2003-11-03 07:14:25
Message-ID: 02a201c3a1da$2268ecb0$7502a8c0@hdsc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Stef 2003-11-03 14:58:04 'invalid' value in timestamp with timezone.
Previous Message Christopher Browne 2003-11-03 01:40:15 Re: A tricky sql-query...