From: | "Schon, Gregor" <Gregor(dot)Schon(at)ids-scheer(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Restoring a Dump with psql on Windows Fails -Password Cannot Be Entered (?) |
Date: | 2005-03-09 16:51:54 |
Message-ID: | 97B9A9BADAB0624D87957A6193F5ED3941D673@049SBEVS2.me.corp.ids-scheer.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
<mailto:pgsql-admin(at)postgresql(dot)org>
From | Date | Subject | |
---|---|---|---|
Next Message | gustavog | 2005-03-09 17:17:24 | Tablespace On 8.0 (Windows) |
Previous Message | Bruno Wolff III | 2005-03-09 15:19:18 | Re: Slow Update |