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.
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 127.0.0.1/32 ident
# IPv6 local connections:
host all all ::1/128 ident
from "peer" and "ident"
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?