Re: pg_dump/psql fails on win32 beta 8.0
От | Secrétariat |
---|---|
Тема | Re: pg_dump/psql fails on win32 beta 8.0 |
Дата | |
Msg-id | 004c01c489a9$90b20280$0a00a8c0@lrp43008 обсуждение исходный текст |
Ответ на | pg_dump/psql fails on win32 beta 8.0 (Josué Maldonado <josue@lamundial.hn>) |
Ответы |
Re: pg_dump/psql fails on win32 beta 8.0
|
Список | pgsql-general |
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 >
В списке pgsql-general по дате отправления: