| From: | stan <stanb(at)panix(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Help with authentication on Debain/Ubuntu installation |
| Date: | 2019-11-21 12:45:17 |
| Message-ID: | 20191121124517.GA3320@panix.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I am trying to set up to do some work with pg_dump, and I would like to be
able to connect from my normal user to do this. This is on a Ubunt 18.04
installation. I have added the follwing to pg_hba.conf:
host all all 0.0.0.0/0 md5
hostssl all all 0.0.0.0/0 md5
But when I try to login like this:
psql stan postgres -W
I get the following error, and yes, I set postgres'es password to something
I know:
tan(at)stantest:~$ psql stan postgres -W
Password:
psql: error: could not connect to server: FATAL: Peer authentication
failed for user "postgres"
stan(at)stantest:~$
What am I doing wrong?
--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
-- Benjamin Franklin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2019-11-21 13:05:09 | Re: Help with authentication on Debain/Ubuntu installation |
| Previous Message | Imre Samu | 2019-11-21 12:39:34 | Re: How should I specify work_mem/max_worker_processes if I want to do big queries now and then? |