Just a short question with hopefully a bit longer answer:

how do I get around the password prompt?

regards,

Ivo


<http://www.incredimail.com/index.asp?id=96317>
_____________________________________________________________________
FREE Emoticons for your email! Click Here!

Search Discussions

  • Oliver Elphick at Sep 6, 2005 at 10:13 am

    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
  • Me at Sep 6, 2005 at 10:22 am
    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
  • Mike G at Sep 7, 2005 at 5:29 am
    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
  • Me at Sep 7, 2005 at 11:47 am
    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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedSep 2, '05 at 8:50a
activeSep 7, '05 at 11:47a
posts5
users4
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase