Uncomment it by removing the # symbol and make it look like below: allow from all Open up the file /etc/apache2/conf.d/phppgadmin: # nano /etc/apache2/conf.d/phppgadmin To install phpPgAdmin, enter the following command: # apt-get install phppgadminīy default, you can access phppgadmin using from your local system only.

PhpPgAdmin is a web-based administration utility written in PHP for managing PosgreSQL. Restart postgresql service to save changes: # /etc/init.d/postgresql restart Uncomment it by removing the # symbol to look like below: password_encryption = on

Uncomment and set the IP address of your postgresql server as shown below: listen_addresses = '192.168.1.200'Īnd find the line: #password_encryption = on To allow to connect users from another computers, open the file /etc/postgresql/9.1/main/nf: # nano /etc/postgresql/9.1/main/nfįind the line: #listen_addresses = 'localhost' Now you will be asked password every time while connecting to databases.īy default, TCP/IP connection is disabled, so that the users from another computers can’t access postgresql. Restart postgresql to apply the changes: # /etc/init.d/postgresql restart Open up the /etc/postgresql/9.1/main/pg_hba.conf file: # nano /etc/postgresql/9.1/main/pg_hba.confįind the following line: local all all ident If you want to set MD5 authentication to require users to enter passwords. By default, Posgresql uses ident authentication, so that the local system users can be granted access to databases own by them.

Install postgresql debian 11