Skip site navigation (1) Skip section navigation (2)

Re: pg_dump in 7.2.4 with trigger functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Steve Wampler <swampler(at)noao(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump in 7.2.4 with trigger functions
Date: 2005-01-31 16:53:18
Message-ID: 20380.1107190398@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
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

Responses

pgsql-general by date

Next:From: NTPTDate: 2005-01-31 17:07:40
Subject: Re: Postgresql and Athlon64 ?
Previous:From: Tom LaneDate: 2005-01-31 16:47:28
Subject: Re: "Invalid multibyte character for locale" still there

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group