From: Kumar <sgnerd@yahoo.com.sg>
To: psql <pgsql-sql@postgresql.org>
Subject: pg_dump error - Permission denied
Date: Mon, 3 Nov 2003 12:44:25 +0530
Message-ID: <02a201c3a1da$2268ecb0$7502a8c0@hdsc.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sgnerd@yahoo.com.sg
Subject: Re: pg_dump error - Permission denied
In-Reply-To: <02a201c3a1da$2268ecb0$7502a8c0@hdsc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox