Schemas not created on restore

[Mike Nolan]

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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Tom Lane]

Mike Nolan <no***@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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Mike Nolan]

> 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 ...

When I try to build 7.4.1 on that system, I get the following error
in the regression test:

/home/postgres/src/postgresql-7.4.1/src/test/regress/./tmp_check/install//usr/lo
cal/pgsql/bin/createdb: relocation error: /home/postgres/src/postgresql-7.4.1/sr
c/test/regress/./tmp_check/install//usr/local/pgsql/bin/createdb: undefined symb
ol: get_progname
pg_regress: createdb failed

Do I need to actually install 7.4, or can I just use pg_dump and pg_dumpall
from it? (I get the same 'undefined symbol: get_progname' message when
I try that.)
--
Mike Nolan

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster