PostgreSQL first run

This is the most common issue for PostgreSQL first run in Linux env: configure the server to allow TCP/IP connections postgresql server it can produce PostgeSQL cannot connect to database host Here I’ll show how to fix it before you struggle with firewall and ports: I’ve found ot here: 17.3. Starting the Database Server and How Do I Enable remote access to PostgreSQL database server? My situation: vi /var/lib/pgsql/data/pg_hba.conf add the string: host all all 10.10.29.0/24 trust with my range and next config: vi /var/lib/pgsql/data/postgresql.conf add the string: listen_addresses=’*’ After that restart the service: systemctl restart postgresql.service also you can use an old ‘service postgresql restart’ [root@centst010 ~]# service postgresql restart Redirecting to /bin/systemctl restart postgresql.service And here it is: [root@centst010Short Read more…