Thread: pg_dump/psql fails on win32 beta 8.0

pg_dump/psql fails on win32 beta 8.0

From
Josué Maldonado
Date:
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."

Re: pg_dump/psql fails on win32 beta 8.0

From
Josué Maldonado
Date:
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

Re: pg_dump/psql fails on win32 beta 8.0

From
Secrétariat
Date:
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
>


Re: pg_dump/psql fails on win32 beta 8.0

From
Josué Maldonado
Date:
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.

Re: pg_dump/psql fails on win32 beta 8.0

From
Secrétariat
Date:
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.
>


Re: pg_dump/psql fails on win32 beta 8.0

From
Josué Maldonado
Date:
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.