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

howto to do an automated backup on windows xp?

From
"Jessica Broomans"
Date:
Attachment

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

From
Oliver Elphick
Date:
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


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

From
Date:
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
>



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

From
Mike G
Date:
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

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

From
Date:
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
>