pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gregor Schon <g.schon@web.de>
To: pgsql-admin@postgresql.org
Subject: Restoring a Dump with psql on Windows Fails - Password Cannot Be Entered (?)
Date: Fri, 11 Mar 2005 16:17:15 +0100
Message-ID: <2029637570@web.de> (raw)

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




view thread (4+ messages)  latest in thread

Message-ID: <2029637570@web.de>
Permalink:  ../2029637570@web.de/
Also on:    postgresql.org/message-id/2029637570@web.de

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: g.schon@web.de
  Subject: Re: Restoring a Dump with psql on Windows Fails - Password Cannot Be Entered (?)
  In-Reply-To: <2029637570@web.de>
  References: <2029637570@web.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox