Steve Wampler <swampler(at)noao(dot)edu> writes:
> ->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
> 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)?
Which part of "must be superuser" are you not following? The database
contains objects that were created by a superuser, and therefore the
restore will have to be run as superuser.
7.2's pg_dump may also have some problems with choosing the wrong dump
order, but there's not evidence of that here.
regards, tom lane
In response to
pgsql-general by date
|Next:||From: NTPT||Date: 2005-01-31 17:07:40|
|Subject: Re: Postgresql and Athlon64 ?|
|Previous:||From: Tom Lane||Date: 2005-01-31 16:47:28|
|Subject: Re: "Invalid multibyte character for locale" still there |