here's what i'm doing on a daily basis on our w2k3 server:
for each db:
"C:\Program Files\PostgreSQL\8.0\Bin\pg_dump" -Fc -Z 5 -U sa -f
e:\backup\somedbname.db somedbname
this works fine once you change localhost access in pg_hba.conf from "md5"
to "trust"
cheers,
thomas
----- Original Message -----
From: "Oliver Elphick" <olly@lfix.co.uk>
To: <jessica@roefs.be>
Cc: <pgsql-novice@postgresql.org>
Sent: Tuesday, September 06, 2005 12:13 PM
Subject: Re: [NOVICE] howto to do an automated backup on windows xp?
> On Fri, 2005-09-02 at 10:47 +0200, Jessica Broomans/Ivo wrote:
>> Just a short question with hopefully a bit longer answer:
>>
>> how do I get around the password prompt?
>
> You don't say nearly enough about the circumstances, so this advice is
> very general.
>
> You need to look at the external file $PGDATA/pg_hba.conf, which defines
> the access rights for your databases. Here you can set what kind of
> authentication is required, according to how the user is accessing the
> server.
>
> If you need to supply a password to a script, you can create a .pgpass
> file in your home directory.
>
> Both these issues are described in the documentation.
>
> --
> Oliver Elphick olly@lfix.co.uk
> Isle of Wight http://www.lfix.co.uk/oliver
> GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
> ========================================
> Do you want to know God? http://www.lfix.co.uk/knowing_god.html
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>