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."
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
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
Show quoted text
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 schemaC:\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?
Import Notes
Resolved by subject fallback
El 24/08/2004 1:11 AM, Secr�tariat en su mensaje escribio:
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.
That way restores to the template1 db without the data, I need to
restore it to a new db with the data included.
Thanks,
--
Sinceramente,
Josu� Maldonado.
"Toda persona que es religiosa es fan�tica." Steve Berk. Sastre jud�o.
On my Win32 Beta1 PG server this procedure has restored all my databases
with all the data !
Luc
Show quoted text
El 24/08/2004 1:11 AM, Secr�tariat en su mensaje escribio:
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.That way restores to the template1 db without the data, I need to
restore it to a new db with the data included.Thanks,
--
Sinceramente,
Josu� Maldonado."Toda persona que es religiosa es fan�tica." Steve Berk. Sastre jud�o.
El 24/08/2004 8:06 AM, Secr�tariat en su mensaje escribio:
On my Win32 Beta1 PG server this procedure has restored all my databases
with all the data !
I wonder why it does not work for me, it restores the table and object
definitions but no data. did you pg_dump with insert instead of copy?
--
Sinceramente,
Josu� Maldonado.
"Tiene valor aquel que admite que es un cobarde." Fernandel ( Fernand
Joseph D�sir� Contandin ) Actor franc�s.