Thread: pg_dump and pg_restore in batch scripts
I read somewhere an example of how to do pg_dump and pg_restore on *nix so as to not have it ask for a password, but is there any way in the Win32 environment to do this? What I am actually trying to do is to get a java servlet to execute the dump command and return through http the dumped file. Once that works it will be to upload the file to the servlet and execute the restore command. The java servlet will have the username and password to the database for the jdbc connection. Thanks, Tim
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
En/na Tim Penhey ha escrit:
> I read somewhere an example of how to do pg_dump and pg_restore on
> *nix so as to not have it ask for a password, but is there any way in
> the Win32 environment to do this?
>
> What I am actually trying to do is to get a java servlet to execute
> the dump command and return through http the dumped file. Once that
> works it will be to upload the file to the servlet and execute the
> restore command. The java servlet will have the username and password
> to the database for the jdbc connection.
>
> Thanks,
> Tim
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
--
JP Glutting
Oficina de Qualitat Plaça Víctor Siurana, 1
Universitat de Lleida 25003 Lleida
-------------------------------------------------------
Tel: 973 703 103 Fax: 973 702 036
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
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 majordomo@postgresql.org 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