X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7FA62DB23E for ; Fri, 28 Oct 2005 18:23:06 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 50402-05 for ; Fri, 28 Oct 2005 21:23:01 +0000 (GMT) Received: from webmail.satcomresources.com (vail-66-198-193-146.colorado.net [66.198.193.146]) by svr1.postgresql.org (Postfix) with ESMTP id 54480DB148 for ; Fri, 28 Oct 2005 18:23:01 -0300 (ADT) Received: from localhost (webmail.satcomresources.com [127.0.0.1]) by webmail.satcomresources.com (Postfix) with ESMTP id D880E3D8036 for ; Fri, 28 Oct 2005 15:19:01 -0400 (EDT) Received: from webmail.satcomresources.com ([127.0.0.1]) by localhost (webmail.satcomresources.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 07269-10 for ; Fri, 28 Oct 2005 15:18:59 -0400 (EDT) Received: from [192.168.0.100] (unknown [192.168.0.100]) by webmail.satcomresources.com (Postfix) with ESMTP id C5FF03D8034 for ; Fri, 28 Oct 2005 15:18:59 -0400 (EDT) Message-ID: <43629636.4050906@satcomresources.com> Date: Fri, 28 Oct 2005 15:20:54 -0600 From: Fred Pope Reply-To: fred.pope@satcomresources.com Organization: Satcom Resources, LLC User-Agent: Mozilla Thunderbird 1.0.5 (Windows/20050711) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Error:PG_DUMP relation pg_user does not exist Content-Type: multipart/mixed; boundary="------------030704090300020800070007" X-Virus-Scanned: amavisd-new at satcomresources.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/26 X-Sequence-Number: 19399 This is a multi-part message in MIME format. --------------030704090300020800070007 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit I am running Postgresql 7.4.7. on RedHat ES-64 version 4 on a Dual-Opteron Dual Core system. I am having problems with the pg_dump command due to improper initialization of the Database cluster on RH ES 4. The initial symptom was visible on execution of the command: pg_dump mydatabase > /tmp/mydatabase.dump pg_dump: SQL command failed pg_dump: Error message from server: ERROR: relation "pg_user" does not exist pg_dump: The command was: SELECT (SELECT usename FROM pg_user WHERE usesysid = datdba) as dba, pg_encoding_to_char(encoding) as encoding, datpath FROM pg_database WHERE datname = 'mydatabase' Hence I went into the mydatabase catalog and created that above mentioned view, and now when I execute that query from within the respective catalogs I get: mydatabase=# select (select usename from pg_user where usesysid = datdba) as dba, pg_encoding_to_char(encoding), datpath as encoding from pg_database where datname = 'mydatabase'; dba | pg_encoding_to_char | encoding ----------+---------------------+---------- postgres | SQL_ASCII | (1 row) When the database engine is calling this query from the pg_dump command, I am assuming this is calling from the database that you are trying to dump. However, the following result makes me question this. psql -l which returns: bash-3.00$ psql -l ERROR: relation "pg_catalog.pg_user" does not exist Hence this led me to try: create view pg_catalog.pg_user as select pg_shadow.usename, pg_shadow.usesysid, pg_shadow.usecreatedb, pg_shadow.usesuper, pg_shadow.usecatupd, '********'::text as passwd, pg_shadow.valuntil, pg_shadow.useconfig from pg_shadow; ERROR: permission denied to create "pg_catalog.pg_user" DETAIL: System catalog modifications are currently disallowed. So my question now is how do I enable system catalog modifications. Thanks in advance. fred at satcomresources dot com --------------030704090300020800070007 Content-Type: text/x-vcard; charset=utf-8; name="fred.pope.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="fred.pope.vcf" begin:vcard fn:Fred Pope n:Pope;Fred org:Satcom Resources LLC adr:101 Eagle Road Building 7;;PO Box 1639;Avon;CO;81620;USA email;internet:fred.pope@satcomresources.com title:CEO tel;work:970-748-3094 tel;fax:970-748-3096 tel;cell:970-471-1073 x-mozilla-html:FALSE url:http://www.satcomresources.com version:2.1 end:vcard --------------030704090300020800070007--