![]() Locate the ‘ $conf = true ‘ and change the value from true to false so you can log in to phpPgAdmin as the postgres user. After editing the section should look like this: # Only allow connections from localhost: Then under that very line, add ‘ Allow From all‘. Therefore open the nf file: # nano /etc/apache2/conf-available/nfĬomment the ‘ Require local‘ line by adding ‘#’ in front of the line. In order to access phpPgAdmin via your browser, the Apache web server needs to be configured. Quit the psql command line: postgres=# \qĮxit the postgres user: postgres=# exit 5. Now you can access PostgreSQL using: psqlĬhange your ‘ postgres‘ role password to match your needs: postgres=# \password postgres Once the installation is completed, log into the ‘ postgres‘ system account so you can access PostgreSQL. This command will install all the necessary packages needed by PostgreSQL and phpPgAdmin such as Apache, PHP etc… so don’t worry if you don’t have Apache or PHP installed on your server. Now install PostgreSQL and phpPgAdmin using the below command: # apt-get install postgresql postgresql-contrib phppgadmin Make sure your server is fully up to date using: # apt-get update & apt-get upgradeģ. Install PostgreSQL and phpPgAdmin on Uubntu 16.04 You should get this output: Distributor ID: Ubuntu Log in to your server via SSH # ssh can check whether you have the proper Ubuntu version installed on your server with the following command: # lsb_release -a Verify phpPgAdmin Installation on Ubuntu 16.04ġ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |