From: | "Gregor Schon" <g(dot)schon(at)web(dot)de> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Restoring a Dump with psql on Windows Fails - Password Cannot Be Entered (?) |
Date: | 2005-03-11 15:17:15 |
Message-ID: | 2029637570@web.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello
I' am new in the forum amd I send the question below to the forum because I thought that I could get a statement whether I do a mistake or whether it is a bug. And because I hoped to get a pointer what I can do to solve the problem ;-)
I try to restore a dump of a PostgreSQL 7.4 db into PostgrSQL 8.0.1 on Windows XP SP1
1) 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 option does not work.
2) 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. There is a bug BUG #1461 with pg_restore but this seems to be different.
I could provide the password in the command line directly but there is no '-pw' parameter or something similar for psql.
I tried the recommendation "Notes to Windows Users" >cmd.exe /c chcp 1252 but this did not change the effect.
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 a wonderful piece of software.
______________________________________________________________
Verschicken Sie romantische, coole und witzige Bilder per SMS!
Jetzt bei WEB.DE FreeMail: http://f.web.de/?mc=021193
From | Date | Subject | |
---|---|---|---|
Next Message | John DeSoi | 2005-03-11 15:41:54 | Re: Restoring a Dump with psql on Windows Fails - Password Cannot Be Entered (?) |
Previous Message | Bruno Wolff III | 2005-03-11 14:55:54 | Re: Grant ALL on schema |