unable to restore from a pgdump file

From: Janet S Jacobsen <JSJacobsen(at)lbl(dot)gov>
To: pgsql-general(at)postgresql(dot)org
Cc: jsjacobsen(at)lbl(dot)gov
Subject: unable to restore from a pgdump file
Date: 2010-02-14 03:36:44
Message-ID: f22d0fbc2de1.4b76ff4c@lbl.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi. I am trying to restore a database from a pgdump file, something
that I've sucessfully done before.

I created a new database cluster, created the database that I want
to restore using

create database subptf with template = template0;

and then I tried to restore the database using

./psql subptf < subptf.pgdump

The first part of what I get is

ERROR: syntax error at or near "PGDMP"
LINE 1: PGDMP
^
GRANT
GRANT
ERROR: syntax error at or near ""
LINE 1: ptffield integer,
^
ERROR: syntax error at or near ""
LINE 1: f1 integer,
^
ERROR: syntax error at or near ""
LINE 1: AS $$
^
ERROR: syntax error at or near ""
LINE 1: AS $_X$
^
ERROR: syntax error at or near ""
LINE 1: AS $_X$
^
ERROR: syntax error at or near ""
LINE 1: AS $$
...

The last part of what I get is

...
vJ?N'G?D(at)??????Q7?2G?0k??$??Slz^P?>??k??|????A?ʞ?A??f-j
\p: extra argument "Zr_?Q«+_???c?ܦ?E??L??(at)???ߒQ????y+?V?*?x?D}x?R?ǯ?67??e???Y?/4O?f?u??ڇW?5???(dot)??A????????N???(at)??_???--kD??I?SatB?Ak????Ƴ?ҕZ?K??&?{?zUt_???{ ?????Tt
???Au????.?V9?rpZ?g?l??8???0³???3
ޒ????}?-??Vӭ????f????+,?mo?HN??+?
?R??z?:?x[bk˯?R_?8ed?ЀI???&=>%?2H??B"???" ignored
\p: extra argument ":P" ignored
\p: extra argument ";???P?+?1?i?)??a=?" ignored
unterminated quoted string
invalid command \??c?>
??Փ%??U???3+??U?SƳǕ???9?????.???e+
invalid command \W??????????????_tUÁ+MK??z?ܦ?H??`o??-/s??N?s?3?Sy?6{7??^gRP???????F(at)?l#??g7HW??j?ӣ?T30={??
invalid command \??g.???
invalid command \AJ??E?$?TC?r?f]?B??
invalid command \??Hzp?Y2??8?@
invalid command \Ā?(?%?O
\connect: FATAL: database "???6??$?^" does not exist

I feel like I'm making some beginner's error here, but I haven't
run into this before.

I am running 8.3.7 on a linux system

Thanks,
Janet

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Atkins 2010-02-14 04:48:04 Re: unable to restore from a pgdump file
Previous Message Prasanna Sukumar 2010-02-14 03:03:03 Kerberos library update