| From: | Steve Atkins <steve(at)blighty(dot)com> |
|---|---|
| To: | Janet S Jacobsen <JSJacobsen(at)lbl(dot)gov> |
| Cc: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: unable to restore from a pgdump file |
| Date: | 2010-02-14 04:48:04 |
| Message-ID: | EB1F2ECB-697C-4491-9493-E262C9817D86@blighty.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Feb 13, 2010, at 7:36 PM, Janet S Jacobsen wrote:
> 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"
I'd guess that you created the dump in custom format, rather than sql format.
If so, you'd need to use pg_restore to restore it rather than psql.
Cheers,
Steve
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John DeSoi | 2010-02-14 15:34:11 | Re: Hosting Account with PostgreSQL and PHP? |
| Previous Message | Janet S Jacobsen | 2010-02-14 03:36:44 | unable to restore from a pgdump file |