![]() # sudo systemctl restart postgresql-11 # FOR Postgresql 11 # sudo systemctl restart postgresql-10 # FOR Postgresql 10 – After making changes, we have to restart the PostgreSQL server # sudo systemctl restart postgresql # sudo vi /var/lib/pgsql/11/data/pg_hba.conf # FOR Postgresql 11 # sudo vi /var/lib/pgsql/10/data/pg_hba.conf # FOR Postgresql 10 – Add the following line in the pg_hba.conf file to allow access to all databases for all users with an encrypted password: # sudo vi /etc/postgresql/9.6/main/pg_hba.conf # defaults to 'localhost' use '*' for all Listen_addresses = '*' # what IP address(es) to listen on # sudo vi /var/lib/pgsql/11/data/nf # Postgresql 11 # sudo vi /var/lib/pgsql/10/data/nf # Postgresql 10 # sudo vi /etc/postgresql/9.6/main/nf # Postgresql 9.6 – Edit this line in your nf file as shown below. How To Install PostgreSQL 11 on Ubuntu 18.04 LTS / 16.04 LTS. ![]() How To install PostgreSQL 11 on CentOS 7 / RHEL 7.If you did not installed yet Postgresql Server, you can check out our previous tutorials : Here, we’ll show you how to enable the network remote access to PostgreSQL Database Server. By default, PostgreSQL Server allow access to clients localy using Unix sockets.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |