Re: psql on Mac

Поиск
Список
Период
Сортировка
От Jeff Frost
Тема Re: psql on Mac
Дата
Msg-id CABEGHMGq737p7QeQuxiFzrai=e6bX8WeGXNt3kRPsDSLnjesuw@mail.gmail.com
обсуждение исходный текст
Ответ на psql on Mac  (Ozan Kahramanogullari <ozan.kah@gmail.com>)
Список pgsql-bugs
psql -U postgres

is probably what you want.

On Fri, Oct 19, 2018 at 7:58 AM Ozan Kahramanogullari <ozan.kah@gmail.com> wrote:
Hi,

I am behind a Mac, and I have been trying to get a local server running by following an internet tutorial (which also uses Mac, this one<https://video.cs50.net/web/2018/spring/lectures/>). 

I simply try to run psql on the terminal, and I get various error messages, depending on how I mess up the file "pg_hba.conf", for example by adding the following lines to it, among others: 

local   postgres        postgres                                trust
local   all             postgres                                trust

I have spent the whole morning browsing the internet to find a solution to my problem, and I also tried backtracking from version 11 of PostgreSQL to version 10. I am pasting below some of the error messages that I get. The version 10 warns for no support for Mac; is that the problem?

Perhaps, it is me who hasn't been able to dig out the right information from the internet. However, I must say that I am quite surprised that things get so tedious immediately. I will thus be glad if you could help me with getting this running, perhaps by providing some up-to-date  documentation. 

Thanks,
Ozan


XX:src3 ozan$ psql

Password: 

sql: FATAL:  password authentication failed for user "ozan"

XX:src3 ozan$ psql

Password: 

psql: FATAL:  password authentication failed for user "ozan"

XX:src3 ozan$ sudo -u postgres psql

Password:

Sorry, try again.

Password:

sudo: 1 incorrect password attempt

XX:src3 ozan$ sudo -u postgres psql

Password:

Sorry, try again.

Password:

could not identify current directory: Permission denied

Password: 

could not identify current directory: Permission denied

psql: could not find own program executable

XX:src3 ozan$ sudo -u postgres psql

could not identify current directory: Permission denied

Password: 

could not identify current directory: Permission denied

psql: could not find own program executable

XX:src3 ozan$ psql

Password: 


 




=========================================
Ozan Kahramanoğulları, PhD
http://sites.google.com/site/ozankahramanogullari/
-----------------------------------------------------------------------
University of Trento, Department of Mathematics
=========================================

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15443: Connection loss error come occasionally
Следующее
От: Jeff Frost
Дата:
Сообщение: Re: psql on Mac