CODEWITHSUNDEEP
postgresqlubuntu
user3541631
user3541631

Reputation: 4008

PostgreSql remote access on Ubuntu 10.04

I try do access remotely a Postgresql(10.3) db.

After I modify #listen_addresses = 'localhost' to listen_addresses = '*' or the ip, I get an error when I use:

sudo -u postgres psql

'Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? '

Upvotes: 0

Views: 246

Answers (1)

Ilya Dyoshin
Ilya Dyoshin

Reputation: 4624

simply remove '#' - before - that means commented line.

UPDATE: if you changed postgresql's listen configuration, then default socket connection is not present. So if you specify exact IP for listen: listen_address = '192.168.1.2' then you need to connect via psql -h 192.168.1.2 -U postgres and your pg_hba.conf should contain entry similar to : 

host    all             all             192.168.1.2/32            md5

and you will need to know postgres password. if you not worried about security - then simply use

host    all             all             192.168.1.2/32            trust

WARNING: do not use 'trust' configuration in production!

Upvotes: 1

Related Questions