From: Fred Pope <fred.pope@satcomresources.com>
To: pgsql-admin@postgresql.org
Subject: Error:PG_DUMP relation pg_user does not exist
Date: Fri, 28 Oct 2005 15:20:54 -0600
Message-ID: <43629636.4050906@satcomresources.com> (raw)
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
<error-message>
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'
</error-message>
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:
<response>
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)
</response>
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:
<response>
bash-3.00$ psql -l
ERROR: relation "pg_catalog.pg_user" does not exist
</response>
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;
<response>
ERROR: permission denied to create "pg_catalog.pg_user"
DETAIL: System catalog modifications are currently disallowed.
</response>
So my question now is how do I enable system catalog modifications.
Thanks in advance.
fred at satcomresources dot com
Attachments:fred.pope.vcf (text/x-vcard, 320B) download
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
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: fred.pope@satcomresources.com
Subject: Re: Error:PG_DUMP relation pg_user does not exist
In-Reply-To: <43629636.4050906@satcomresources.com>
References: <43629636.4050906@satcomresources.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