Results 1 to 1 of 1
  1. #1
    Join Date
    Mar 2011

    Unanswered: Error connecting to server

    hello all!

    When I open PgAdmin, and click on the server (with red x) to connect, I get this error:

    An Error has occured: error connecting to the server:
    fe_sendauth: no password supplied

    I am using postgres as standard pgadmin user.

    How can I fix this?


    I found via google that by changing the below entries:

    [root@server1 yum.repos.d]# vi /var/lib/pgsql/9.1/data/pg_hba.conf
    # Put your actual configuration here
    # ----------------------------------
    # If you want to allow non-local connections, you need to add more
    # "host" records. In that case you will also need to make PostgreSQL
    # listen on a non-local interface via the listen_addresses
    # configuration parameter, or via the -i or -h command line switches.


    # "local" is for Unix domain socket connections only
    local all all peer
    # IPv4 local connections:
    host all all ident
    # IPv6 local connections:
    host all all ::1/128 ident

    from "peer" and "ident"

    TO "trust",,,

    I could restore db's

    This seems like locking the frount door and taping the key to the handle.

    Can someone provide a better alternative? maintaining security, but being able to backup / restore from pgAdmin?

    Last edited by detox; 07-08-12 at 15:58.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts