Lists: | pgsql-general |
---|
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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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."
From: | Josué Maldonado <josue(at)lamundial(dot)hn> |
---|---|
To: | Josué Maldonado <josue(at)lamundial(dot)hn> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_dump/psql fails on win32 beta 8.0 |
Date: | 2004-08-23 23:30:11 |
Message-ID: | 412A7E03.5010607@lamundial.hn |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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