Skip site navigation (1) Skip section navigation (2)

Re: pg_dump/psql fails on win32 beta 8.0

From: Secrétariat <ets(at)rolland-fr(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_dump/psql fails on win32 beta 8.0
Date: 2004-08-24 07:11:19
Message-ID: 004c01c489a9$90b20280$0a00a8c0@lrp43008 (view raw or flat)
Thread:
Lists: pgsql-general
I encountered the same problem,
I resolve this with psql  connected to template1 :
template1=# \i xfar.sql
would load your data
It works with my dumpall from an Linux 7.4.3 database.

Luc


> Hello List,
>
> I'm having this issue with beta 8.0
>
> C:\pgsql\bin>pg_dump -U postgres farmacia > xfar.sql
> Password:
> C:\pgsql\bin>psql -U postgres farmacia2 < xfar.sql
> Password:
> psql: FATAL:  Password authentication failed for user "postgres"
> C:\pgsql\bin>psql -U postgres -W farmacia2 < xfar.sql
> Password:
> psql: FATAL:  Password authentication failed for user "postgres"
>
> it did not ask for the password neither, however this works but no data
> is restored just the schema
>
> C:\pgsql\bin>pg_dump -U postgres farmacia > xfar.sql
> Password:
>
> C:\pgsql\bin>edit xfar.sql
>
> C:\pgsql\bin>psql -U postgres farmacia2 < xfar.sql
> Password:
> psql: FATAL:  Password authentication failed for user "postgres"
>
> C:\pgsql\bin>psql -U postgres -W farmacia2 < xfar.sql
> Password:
> psql: FATAL:  Password authentication failed for user "postgres"
>
> I'm running on W2k pro SP4, any idea or suggestion?
>
> Thanks in advance
>
>
> -- 
> Sinceramente,
> Josué Maldonado.
> "Y subi en mente y me conecte al servidor pero la imagen era
> desagradable, el balance de mi cuenta estaba en rojo."
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html
>


Responses

pgsql-general by date

Next:From: SecrétariatDate: 2004-08-24 07:23:32
Subject: Re: Connection to a PG 8.0 Beta 1 win32 server
Previous:From: Tatsuo IshiiDate: 2004-08-24 06:47:18
Subject: Re: UTF-8 and LIKE vs =

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group