1. Forum
  2. Usenet
  3. COMP.DATABASES.POSTGRESQL

  • Password?

    From Peter Percival@21:1/5 to All on Sat Feb 3 15:56:48 2018
    When I installed PostgreSQL it asked me to supply a password, which I
    did. My first use of the product was to issue this command:

    createdb books

    I was asked for a password and I duly typed the one I supplied. It was rejected. Any thoughts?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Peter Percival@21:1/5 to Peter Percival on Sat Feb 3 20:15:33 2018
    Peter Percival wrote:
    When I installed PostgreSQL it asked me to supply a password, which I
    did.  My first use of the product was to issue this command:

        createdb books

    I was asked for a password and I duly typed the one I supplied.  It was rejected.  Any thoughts?

    It maybe that I need to find .pgpass. If so, where is it?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Laurenz Albe@21:1/5 to Peter Percival on Mon Feb 5 19:33:45 2018
    Peter Percival wrote:
    When I installed PostgreSQL it asked me to supply a password, which I
    did.  My first use of the product was to issue this command:

        createdb books

    I was asked for a password and I duly typed the one I supplied.  It was
    rejected.  Any thoughts?

    It maybe that I need to find .pgpass. If so, where is it?

    .pgpass is in your home directory.

    I guess from your user agent that you are on Windows.

    Was the password you entered for an operating system user or
    for a database user?

    There is a simple way to get out of this situation:
    Edit pg_hba.conf and change the authentication method to
    "trust" for all local and localhost lines. Then restart
    PostgreSQL.

    After that, neither "createdb" nor "psql" will ask a password
    if you are on the same machine, and you can use the psql
    command "\password" to change your password.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)