Re: automating backup ?

> 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

Hi.
I can't find pgpass.conf file. It should be in Application Data
subdirectory, but there is no PostgreSQL subdirectory in Application Data
directory (!?). I couldn't find pgpass.conf even by searching the hard
disk..

Regards,
Zlatko

----- Original Message -----
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>
Sent: Tuesday, June 28, 2005 10:16 AM
Subject: Re: [GENERAL] automating backup ?

> 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

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

"Zlatko Matic" <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr> writes:

> Hi.
> I can't find pgpass.conf file. It should be in Application Data
> subdirectory, but there is no PostgreSQL subdirectory in Application
> Data directory (!?). I couldn't find pgpass.conf even by searching the
> hard disk..

I'm pretty sure it's not created by the default install (it certainly
isn't on Unix)--you need to create it yourself if you're going to use
it.

-Doug

Zlatko Matic schrieb:

> I can't find pgpass.conf file. It should be in Application Data
> subdirectory, but there is no PostgreSQL subdirectory in Application
> Data directory (!?). I couldn't find pgpass.conf even by searching the
> hard disk..

you have to create the sub-dir and the file yourself