Thread: 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 > 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 >
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 > > 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.