Re: pg_dump and pg_restore in batch scripts

Um, sorry about that post. I understood that pg_restore was not working, 
but I have been able to use it. I needed to dump and restore as a .tar 
file (the raw dump didn't seem to work - but that may just be because I 
didn't understand the man page ...)

-F t  is the switch for setting the archive type to .tar for restoring.

Good luck.

En/na Tim Penhey ha escrit:

> Johan Paul Glutting wrote:
>
>> I don't think pg_restore is working in this Beta version of 
>> PostgreSQL. At least, that is my understanding, from a post a few 
>> weeks ago.
>>
>> pg_restore does not work for me, although pg_dump seems to be 
>> functional.
>>
>> You can edit your your pg_hba.conf file to set different types of 
>> authentication ("trust", or "ïdent")
>> http://www.postgresql.org/docs/7.3/interactive/client-authentication.html 
>>
>>
>> Cheers,
>>
>> JP
>
>
> Aah... that will explain why I am having problems with the restoring 
> of the database ;-)
>
> Thanks for the link on authentication, that looks like it might solve 
> the problem.
>
> Tim
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to [email protected] so that your
>      message can get through to the mailing list cleanly



-- 
JP Glutting
Oficina de Qualitat		Plaça Víctor Siurana, 1
Universitat de Lleida		25003 Lleida
-------------------------------------------------------
Tel: 973 703 103		Fax: 973 702 036



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster