Re: 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(at)lfix(dot)co(dot)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