470,586 Members | 1,438 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,586 developers. It's quick & easy.

pg_dump/psql fails on win32 beta 8.0

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

Nov 23 '05 #1
1 1997

El 23/08/2004 5:13 PM, Josué Maldonado en su mensaje escribio:
it did not ask for the password neither, however this works but no

data is restored just the schema

wrong paste trimmed here, this is the correct, sorry

C:\pgsql\bin>psql -d farmacia2 -U postgres -f xfar.sql
Password:
SET
SET
COMMENT
SET
CREATE FUNCTION
ALTER FUNCTION
CREATE FUNCTION
ALTER FUNCTION
CREATE LANGUAGE
CREATE FUNCTION
....
--
Sinceramente,
Josué Maldonado.
"La sabiduría nos llega cuando ya no nos sirve de nada." -- Gabriel
Garcia Marquez

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Howard Lowndes | last post: by
1 post views Thread by Ruth Hsieh | last post: by
4 posts views Thread by Philip | last post: by
1 post views Thread by Ben-Nes Michael | last post: by
6 posts views Thread by Együd Csaba | last post: by
1 post views Thread by Neil Zanella | last post: by
7 posts views Thread by Ulrich Wisser | last post: by
6 posts views Thread by Ilia Chipitsine | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.