X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 0E0A9D1B93D
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  3 Nov 2003 07:18:21 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 03317-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  3 Nov 2003 03:17:51 -0400 (AST)
Received: from smtp017.mail.yahoo.com (smtp017.mail.yahoo.com
	[216.136.174.114])
	by svr1.postgresql.org (Postfix) with SMTP id 851DCD1CAFA
	for <pgsql-sql@postgresql.org>; Mon,  3 Nov 2003 03:17:49 -0400 (AST)
Received: from ptil-138-190-chn.primus-india.net (HELO IVESIA67)
	(sgnerd@203.196.190.138 with login)
	by smtp.mail.vip.sc5.yahoo.com with SMTP; 3 Nov 2003 07:17:00 -0000
Message-ID: <02a201c3a1da$2268ecb0$7502a8c0@hdsc.com>
Reply-To: "Kumar" <sgnerd@yahoo.com.sg>
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
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_029D_01C3A208.36C16D30"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.6 tagged_above=0.0 required=5.0 tests=HTML_30_40
X-Spam-Level: 
X-Archive-Number: 200311/10
X-Sequence-Number: 15825

This is a multi-part message in MIME format.

------=_NextPart_000_029D_01C3A208.36C16D30
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear friends,=20

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 te=
st

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: ERRO=
R:  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 sequenc=
e 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 =3D 105 where datname =3D 'test';

Even though I am the owner of the sequence, why I am getting this error. An=
ybody could shed some light, pls.

Regards
Kumar

------=_NextPart_000_029D_01C3A208.36C16D30
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1264" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY style=3D"COLOR: #0000ff; FONT-FAMILY: Arial" bgColor=3D#ffffff>
<DIV><FONT size=3D2>Dear friends, </FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>I am working with Postgres 7.3.4 on RH Linux 7.3.</FONT=
></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>I could manage to take a backup using the following com=
mand=20
and as the user 'postgres'.</FONT></DIV>
<DIV><FONT size=3D2>&nbsp;$ pg_dump -h 192.168.2.51 -v -u -f=20
/home/db_repository/test20031103.sql test</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>But while I try to execute the same command with the us=
er=20
'kumar', it gives me the following error</FONT></DIV>
<DIV><FONT size=3D2>&gt;&gt;</FONT></DIV>
<DIV><FONT size=3D2>pg_dump: query to get data of sequence "clients_client_=
id_seq"=20
failed: ERROR:&nbsp; clients_client_id_seq: permission denied<BR>pg_dump: *=
**=20
aborted because of error</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>But as the user 'kumar' I could manage to get the next =
value=20
of the sequence with the following command</FONT></DIV>
<DIV><FONT size=3D2>select nextval('test.clients_client_id_seq');</FONT></D=
IV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>Previously, user 'postgres' is the owner of the databas=
e and I=20
have changed that to 'kumar' via the following command</FONT></DIV>
<DIV><FONT size=3D2>UPDATE pg_database SET datdba =3D 105 where datname =3D=
=20
'test';</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>Even though I am the owner of the sequence, why I am ge=
tting=20
this error. Anybody could shed some light, pls.</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>Regards</FONT></DIV>
<DIV><FONT size=3D2>Kumar</FONT></DIV>
<P></P></BODY></HTML>

------=_NextPart_000_029D_01C3A208.36C16D30--