[ADMIN] Restoring a Dump with psql on Windows Fails -Password Cannot Be Entered (?)

[Schon, Gregor]

Hello

I try to restore a dump of a PostgreSQL 7.4 db into PostgrSQL 8.0.1 on Windows XP SP1
When using pgadmin III it asks for a *.backup file which I do not have and the OK button is greyed out when selecting the dump file - thus this does not work.

 

When using psql as I do it on Linux (Suse 9.0) successfully I cannot enter the password. 
In a command prompt of Windows I get the following effect:

 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
C:\Programme\PostgreSQL\8.0\bin>psql phprvitadb < C:\Programme\PostgreSQL\8.0\bin\phprvitadb200503082100.dump -U gsc
Passwort:
psql: FATAL:  password authentication failed for user "gsc"

 

C:\Programme\PostgreSQL\8.0\bin>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 

It looks that I did not enter the correct password but actually the system did not allow me to enter a password. The 2 lines:
Passwort:
psql: FATAL:  password authentication failed for user "gsc"

are written in one step.

Is that a bug?  I heard that Windows and Unix have different "New Line" handling (LF / CR) - that could be related to the effect.
I could provide the password in the command line directly  but there is no '-pw' parameter or something similar for psql.

 

Any ideas what I could do to get the dump into the database?  A little help would be highly appreciated.

Thanks in advance

Gregor

 

Remark 1: The original Linux based 7.4 database is still running and available - Maybe I have to work with some kind of binary backup instead.

Remark 2: The postgreSQL database runs absolutly stable ( as a php backend) on Linux for more than 2 years - it is wonderful software.