pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
error: permission denied for schema pg_catalog && pg_temp_nn tables
2+ messages / 2 participants
[nested] [flat]

* error: permission denied for schema pg_catalog && pg_temp_nn tables
@ 2005-10-18 02:16  Guido Barosio <gbarosio@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Guido Barosio @ 2005-10-18 02:16 UTC (permalink / raw)
  To: gbarosio@gmail.com; +Cc: pgsql-admin

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.

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: error: permission denied for schema pg_catalog && pg_temp_nn tables
@ 2005-10-18 02:37  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Guido Barosio <gbarosio@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2005-10-18 02:37 UTC (permalink / raw)
  To: Guido Barosio <gbarosio@gmail.com>; +Cc: pgsql-admin

Guido Barosio <gbarosio@gmail.com> writes:
> [ a whole lot of handwaving with no specifics ]

You need to be *way* more specific than that.  Show us exactly what you
did and exactly what error messages you got, not your guesses about
what it means.  Copy-and-paste is your friend.

You might find it helpful to read the reporting guidelines at 
http://www.postgresql.org/docs/7.4/static/bug-reporting.html
Whether it's a postgres bug or not, those guidelines are good to
follow to make sure you've explained your problem in adequate detail.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-10-18 02:37 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-10-18 02:16 error: permission denied for schema pg_catalog && pg_temp_nn tables Guido Barosio <gbarosio@gmail.com>
2005-10-18 02:37 ` Tom Lane <tgl@sss.pgh.pa.us>

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