This page describes methods for keeping your computer’s time accurate. This is useful for servers, but is not necessary (or desirable) for desktop machines.

Execute below command in your terminal

 sudo dpkg-reconfigure tzdata

& select time zone.

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