From: | Shaun Clements <ShaunC(at)relyant(dot)co(dot)za> |
---|---|
To: | 'John DeSoi' <desoi(at)pgedit(dot)com> |
Cc: | 'PgSql General' <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Problem performing a restore of a data schema in Wi |
Date: | 2005-02-08 06:27:55 |
Message-ID: | B16D6764833DA442961BBD8CC1AF7CFD01E03384@srldbexc003.relyant.co.za |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi John
Thanks for the suggestion. It worked perfectly.
Thanks
Kind Regards,
Shaun Clements
-----Original Message-----
From: John DeSoi [mailto:desoi(at)pgedit(dot)com]
Sent: 07 February 2005 04:21 PM
To: Shaun Clements
Cc: 'PgSql General'
Subject: Re: [GENERAL] Problem performing a restore of a data schema in
Windows
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
Subject to www.relyant.co.za/edisclaim.htm
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-02-08 06:45:44 | Re: a SELECT FOR UPDATE question |
Previous Message | Michael Fuhr | 2005-02-08 06:25:52 | Re: a SELECT FOR UPDATE question |