Help with authentication on Debain/Ubuntu installation

Поиск
Список
Период
Сортировка
От stan
Тема Help with authentication on Debain/Ubuntu installation
Дата
Msg-id 20191121124517.GA3320@panix.com
обсуждение исходный текст
Ответы Re: Help with authentication on Debain/Ubuntu installation
Список 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@stantest:~$ psql stan postgres -W
Password: 
psql: error: could not connect to server: FATAL:  Peer authentication
failed for user "postgres"
stan@stantest:~$ 

What am I doing wrong?


-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                        -- Benjamin Franklin



В списке pgsql-general по дате отправления:

Предыдущее
От: Imre Samu
Дата:
Сообщение: Re: How should I specify work_mem/max_worker_processes if I want todo big queries now and then?
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: Help with authentication on Debain/Ubuntu installation