Re: howto to do an automated backup on windows xp?

the pg_hba.conf is in your db "data" folder. i doubt you can even run pgsql
without having such a file..

cheers,
thomas


----- Original Message -----
From: "Mike G" <mike@thegodshalls.com>
To: <me@alternize.com>
Cc: <jessica@roefs.be>; <pgsql-novice@postgresql.org>
Sent: Wednesday, September 07, 2005 7:28 AM
Subject: Re: [NOVICE] howto to do an automated backup on windows xp?


>I haven't seen anyone get around that problem yet without setting
> pg_hba.conf to trust.
>
> The pgpass.conf file did not exist on my machine as mentioned in the
> docs.  I added it manually but still received the password error.  I set
> all the other parameters and those did seem to be acknowledged.
>
> Mike
>
> On Tue, 2005-09-06 at 05:22, me@alternize.com wrote:
>> 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
>> >
>>
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 4: Have you searched our list archives?
>>
>>                http://archives.postgresql.org
>