Schemas not created on restore - Mailing list pgsql-general

From Mike Nolan
Subject Schemas not created on restore
Date
Msg-id 200401141545.i0EFjV1B015471@gw.tssi.com
Whole thread Raw
Responses Re: Schemas not created on restore
List 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



pgsql-general by date:

Previous
From: Yannick Warnier
Date:
Subject: Re: How are NULLS stored on disk for PG 7.4?
Next
From: "Jim Wilson"
Date:
Subject: Re: planner and join type mismatches