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

pg_dump/psql fails on win32 beta 8.0

From: Josué Maldonado <josue(at)lamundial(dot)hn>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dump/psql fails on win32 beta 8.0
Date: 2004-08-23 23:13:35
Message-ID: 412A7A1F.4090703@lamundial.hn (view raw or flat)
Thread:
Lists: pgsql-general
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."

Responses

pgsql-general by date

Next:From: David WheelerDate: 2004-08-23 23:18:00
Subject: Re: UTF-8 and LIKE vs =
Previous:From: Tim PenheyDate: 2004-08-23 23:12:35
Subject: Re: Python and 8.0 beta

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