pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Guido Barosio <gbarosio@gmail.com>
To: gbarosio@gmail.com
Cc: pgsql-admin@postgresql.org
Subject: error: permission denied for schema pg_catalog && pg_temp_nn tables
Date: Tue, 18 Oct 2005 03:16:11 +0100
Message-ID: <f7f6b4c70510171916p57b45e1dtbd751282bcb4c66d@mail.gmail.com> (raw)

Hi there,
  Gotta rubish problem, which actually appears to happen in older versions (
7.3.5), but I am using a 7.4.2 server.
  Now, I need to create a new db, for testing purposes, and I've done a dump
from the prd db using pg_dump. After that, I create the new db and I run the
restore. It breaks, crying about the pg_catalog permissions. Ok, going with
a `cat schema.sql | psql dbname`. In this case, it will end, but complaining
several times about the same issue, pg_catalog and permission denied,
and...it also complains about tables that don't exist anymore. But actually,
the relation exists, through a search in pg_class.
  Damn, maybe the dump wrote bad that schema dump?
  The file looks fine, as every schema dump I ever read before (~1500
lines). After this I've put my hands in the db, and searched for schemas in
the db. Found tons of pg_temp_nn (up to 92) schemas. Something aboute
temporary tables, but not much more info arround. The case is that the db,
actually is running without users connected, and no batch jobs are running,
pg_stat_activity shows an empy and great scenery, where nothing goes on. A
restart of the service didn't help. Tables are still there. Note that this
db holds too much views, and that is the only difference with other db's
where the pg_temp_nn are normal (< 5).
  Now, in the irc (freenode, #postgresql), someone suggested an upgrade of
the db software (to a major version, let's say 7.4.9). I've tryed the dump
&& restore with a 7.4.8 and it didn't work (note that the newer soft is on
another box, so hw issue is out of the road today). Same issue, same error,
cat && psql failing also.
 Will 8.x sort this out?
If not:
 Is this a problem with the order in the perms set ? (dump is failing?)
 Any ideas? I need a thread old-guru here, someone with the brain enough
strong to remember this issue in previous versios, or to clarify my scenery.
I could be missing something, dunno.
 Thanks in advance, (..and let me know your thoughts! :) )
 Cheers,
Guido


--
"Adopting the position that you are smarter than an automatic
optimization algorithm is generally a good way to achieve less
performance, not more" - Tom Lane.

view thread (2+ messages)  latest in thread

Message-ID: <f7f6b4c70510171916p57b45e1dtbd751282bcb4c66d@mail.gmail.com>
Permalink:  ../f7f6b4c70510171916p57b45e1dtbd751282bcb4c66d@mail.gmail.com/
Also on:    postgresql.org/message-id/f7f6b4c70510171916p57b45e1dtbd751282bcb4c66d@mail.gmail.com

 · 

reply

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: gbarosio@gmail.com
  Subject: Re: error: permission denied for schema pg_catalog && pg_temp_nn tables
  In-Reply-To: <f7f6b4c70510171916p57b45e1dtbd751282bcb4c66d@mail.gmail.com>
  References: <f7f6b4c70510171916p57b45e1dtbd751282bcb4c66d@mail.gmail.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