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
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... |