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
