Re: Problem performing a restore of a data schema in Wi
Yeah, thats right.
Sorry, Typo.
Any suggestions.
Kind Regards,
Shaun Clements
-----Original Message-----
From: Shridhar Daithankar [mailto:ghodechhap@ghodechhap.net]
Sent: 07 February 2005 03:33 PM
To: Shaun Clements
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Problem performing a restore of a data schema in
Windows
On Monday 07 Feb 2005 6:52 pm, Shaun Clements wrote:
Im having a problem restoring a data schema on Postgres 8.01 for Windows.
Im using the following command
psql -U username -d db1 > filename.dmp
Shouldn't that be
psql -U username -d db1 < filename.dmp
Shridhar
Subject to www.relyant.co.za/edisclaim.htm
Hi John
Thanks for the suggestion. It worked perfectly.
Thanks
Kind Regards,
Shaun Clements
-----Original Message-----
From: John DeSoi [mailto:desoi@pgedit.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
Import Notes
Resolved by subject fallback
-----Original Message-----
From: John DeSoi [mailto:desoi@pgedit.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
WindowsOn Feb 7, 2005, at 8:22 AM, Shaun Clements wrote:
psql -U username -d db1 > filename.dm
You're going the wrong way. Try either
psql -U username -d db1 < filename.dm
or
cat filename.dm | psql -U username -d db1
or
psql -f filename.dm -U username -d db1