Schemas not created on restore

From: Mike Nolan <nolan(at)gw(dot)tssi(dot)com>
To: pgsql-general(at)postgresql(dot)org (pgsql general list)
Subject: Schemas not created on restore
Date: 2004-01-14 15:45:30
Message-ID: 200401141545.i0EFjV1B015471@gw.tssi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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. Below is the relevant portion of the dumpall, is this a problem
with permissions on the dumping system or with the restore?

SET SESSION AUTHORIZATION 'uscf';

--
-- TOC entry 2 (OID 16977)
-- Name: uscf; Type: SCHEMA; Schema: -; Owner: uscf
--

CREATE SCHEMA uscf;
--
Mike Nolan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim Wilson 2004-01-14 15:46:18 Re: planner and join type mismatches
Previous Message Yannick Warnier 2004-01-14 15:30:26 Re: How are NULLS stored on disk for PG 7.4?