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...@??????q7?2g?0k??$??slz^p?>??k??|????A?ʞ?A??f-j
\p: extra argument
"zr_?q«+_???c?ܦ?e??...@???ߒq????y+?v?*?x?d}x?r?ǯ?67??e???y?/4o?f?u??ڇw?5???.??a????????n...@??_???--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?????...@?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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
