| From: | "Magnus Hagander" <mha(at)sollentuna(dot)net> |
|---|---|
| To: | "Zlatko Matic" <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>, "Andreas" <maps(dot)on(at)gmx(dot)net>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: automating backup ? |
| Date: | 2005-06-28 08:16:28 |
| Message-ID: | 6BCB9D8A16AC4241919521715F4D8BCE6C771C@algol.sollentuna.se |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> Hello.
> I created a Windows XP schedule for backup, following your
> instruction. Now I have a .bat file with this script:
>
> cd D:\Program Files\PostgreSQL\8.0\bin
> pg_dumpall >D:\MYDATABASE_DUMPALL -U postgres pg_dumpall
> >D:\MYDATABASE_SHEMA -U postgres -s pg_dumpall
> >D:\MYDATABASE_GLOBALS -U postgres -g
>
> Well, it works OK, but prompts for password every time. Is
> there any way that I pass the superuser password (off course,
> in safe way) so that it works automatically without prompting
> for password ?
Use a pgpass.conf file:
http://www.postgresql.org/docs/8.0/static/libpq-pgpass.html (remember
the file has to be in the profile of the account that executes the step.
And be sure to protect it with file system ACLs so other users can't
read it)
//Magnus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hakan Kocaman | 2005-06-28 09:36:46 | Re: Generate a list of (days/hours) between two dates |
| Previous Message | Gregory Youngblood | 2005-06-28 06:49:38 | Performance Tuning Best Practices for 8 |