To install PostgreSql Sever, execute

To start off, we need to change the PostgreSQL postgres user password; we will not be able to access the server otherwise. As the “postgres” Linux user, we will execute the psql command.

In a terminal, type:

Set a password for the “postgres” database role using the command:

and give your password when prompted. The password text will be hidden from the console for security purposes.

Type Control+D to exit the posgreSQL prompt.

Since the only user who can connect to a fresh install is the postgres user, here is how to create yourself a database account (which is in this case also a database superuser) with the same name as your login name and then create a password for the user:

postgres=# \password $USER

phpPgAdmin

Introduction

phpPgAdmin is a web based PostgreSQL software management package. To use it you should install and configure PHP, Apache and postgresql, see PostgreSQL for instructions.

Installing From Package

Install phpPgAdmin From console:

Remote access

By default you can only access phppgadmin from localhost. If you want to be able to use it remotely, do the following:

Comment out (add # at beginning of line) “allow from 127.0.0.0/255.0.0.0 ::1/128” and remove # from the line below it, “allow from all”.

Then restart apache