Re: Problem performing a restore of a data schema in Windows

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Shaun Clements <ShaunC(at)relyant(dot)co(dot)za>
Cc: 'PgSql General' <pgsql-general(at)postgresql(dot)org>
Subject: Re: Problem performing a restore of a data schema in Windows
Date: 2005-02-07 14:21:21
Message-ID: 8A5D3597-7913-11D9-AA7C-000A95B03262@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Feb 7, 2005, at 8:22 AM, Shaun Clements wrote:

> psql -U username -d db1 > filename.dmp

Try

psql.exe -U username -d db1 -f filename.dmp

If it does not work, paste the output from the terminal so we can see
what error you have. Are you sure filename.dmp is a plain text dump? If
not, you need to use pg_restore instead of psql.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Browne 2005-02-07 15:38:18 Re: Is there a peer-to-peer server solution with PG?
Previous Message Konference 2005-02-07 14:10:58 PostgreSQL, exception and PHP