Thread: howto to do an automated backup on windows xp?
Just a short question with hopefully a bit longer answer:
how do I get around the password prompt?
regards,
Ivo
FREE Emoticons for your email! Click Here!
Attachment
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
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 >
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
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 >