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.