X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8A3B8565CC for ; Fri, 11 Mar 2005 15:18:55 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 62347-09 for ; Fri, 11 Mar 2005 15:18:48 +0000 (GMT) Received: from fmmailgate05.web.de (fmmailgate05.web.de [217.72.192.243]) by svr1.postgresql.org (Postfix) with ESMTP id 81350566B3 for ; Fri, 11 Mar 2005 15:18:45 +0000 (GMT) Received: by fmmailgate05.web.de (8.12.10/8.12.10/webde Linux 0.7) with SMTP id j2BFGEui014165; Fri, 11 Mar 2005 16:17:19 +0100 Received: from [193.141.180.241] by freemailng0201.web.de with HTTP; Fri, 11 Mar 2005 16:17:15 +0100 Date: Fri, 11 Mar 2005 16:17:15 +0100 Message-Id: <2029637570@web.de> MIME-Version: 1.0 From: "Gregor Schon" To: pgsql-admin@postgresql.org Subject: Restoring a Dump with psql on Windows Fails - Password Cannot Be Entered (?) Precedence: fm-user Organization: http://freemail.web.de/ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/179 X-Sequence-Number: 16677 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