Postgres Pro
Downloads
Home   >   mailing lists

Re: Schemas not created on restore - Mailing list pgsql-general

From Tom Lane
Subject Re: Schemas not created on restore
Date
Msg-id 4943.1074107738@sss.pgh.pa.us
Whole thread Raw
In response to Schemas not created on restore  (Mike Nolan <nolan@gw.tssi.com>)
Responses Re: Schemas not created on restore  (Mike Nolan <nolan@gw.tssi.com>)
List pgsql-general
Tree view 
Mike Nolan <nolan@gw.tssi.com> writes:
> I'm restoring a full dump from a 7.3.3 system to a new 7.4.1 system and am
> getting a 'permission denied' error when it tries to create the user
> schemas.

Yeah, this is an error in the 7.3 pg_dump logic for schemas.  Use the
pg_dump from the 7.4 installation to dump the 7.3 server, or manually
edit the dump file ...

            regards, tom lane

pgsql-general by date:

Previous
From: Matt Davies
Date:
Subject: Re: Postgress and MYSQL
Next
From: Tom Lane
Date:
Subject: Re: Rights in 7.4