AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Postgresql enable remote connections9/22/2023 ![]() ![]() Edit pg_hba.conf authentication config file: We will edit file /var/lib/pgsql/13/data/pg_hba.conf and tell to PostgreSQL that we want to accept connections from a specific IP address or range. Max_connections = 100 # (change requires restart) ![]() # defaults to 'localhost' use '*' for all Listen_addresses = '*' # what IP address(es) to listen on Find this section: and change it by uncommenting the listen_addressesline and changing localhost to * as data]# data]# vi nf (Configuration File) This is done by making a change in /var/lib/pgsql/13/data/nf. Edit nf Configuration File: We will tell PostgreSQL to start listening to our network interfaces. Rich 13]# firewall-cmd -zone=public -add-port=5432/tcp 13]# firewall-cmd 13]# firewall-cmd -list-all Services: dhcpv6-client mysql postgresql ssh Ââ47250 /usr/bin/python2 -Es /usr/sbin/firewalld -nofork 13]# firewall-cmd -permanent 13]# firewall-cmd 13]# firewall-cmd -list-all Loaded: loaded (/usr/lib/systemd/system/rvice enabled vendor preset: enabled)Īctive: active (running) since Tue 11:32:05 +03 6 days ago  rvice - firewalld - dynamic firewall daemon Redirecting to /bin/systemctl status rvice ![]()
0 Comments
Read More
Leave a Reply. |