Search Postgresql Archives

pg_dump in 7.2.4 with trigger functions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




I realize 7.2.4 is long in the tooth, but it's an old system that's been running for several years now. Someday we'll upgrade...

However, part of the upgrade will involve dumping and restoring the
tables.  I've just did a little playing with pg_dump on one of
the databases and discovered that I can't restore it!  Is this
a known problem?  If so, is there a workaround?  Is this operator
error?  If so, can someone point me to what I did wrong?

I did:
====================================================================
->pg_dump -C atst.logdb | gzip >atst.logdb.out.gz
->dropdb atst.logdb
DROP DATABASE
->gunzip <atst.logdb.out.gz | psql -q
ERROR:  permission denied to set session authorization
ERROR:  permission denied for language c
ERROR:  must be superuser to create procedural language
ERROR:  permission denied to set session authorization
ERROR:  permission denied for schema public
ERROR:  permission denied to set session authorization
ERROR:  language "plpgsql" does not exist
HINT:  You need to use "createlang" to load the language into the database.
ERROR:  language "plpgsql" does not exist
HINT:  You need to use "createlang" to load the language into the database.
ERROR:  permission denied to set session authorization
ERROR:  permission denied to set session authorization
ERROR:  must be owner of schema public
=======================================================================

I see all the permission denied messages, but why?  How can a user
create a dump that they cannot load back in (the user has createdb *and*
createuser permissions)?

It looks as though the problems are with the procedural language (the
database has some trigger functions attached to one of the tables), but
I have no clue what went wrong.

Any suggestions would be *most* welcome!  [Correct ones even more so...]

Thanks!
Steve

--
Steve Wampler -- swampler@xxxxxxxx
The gods that smiled on your birth are now laughing out loud.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux