Re: Schemas not created on restore

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mike Nolan <nolan(at)gw(dot)tssi(dot)com>
Cc: pgsql-general(at)postgresql(dot)org (pgsql general list)
Subject: Re: Schemas not created on restore
Date: 2004-01-14 19:15:38
Message-ID: 4943.1074107738@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Mike Nolan <nolan(at)gw(dot)tssi(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-01-14 19:18:35 Re: Rights in 7.4
Previous Message Matt Davies 2004-01-14 19:12:48 Re: Postgress and MYSQL