Time Synchronisation with NTP Linux

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.

PostgreSql Server & phppgadmin on Ubuntu

To install PostgreSql Sever, execute

sudo apt-get install postgresql

 

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:

sudo -u postgres psql postgres

 

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

\password postgres

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:

sudo -u postgres createuser --superuser $USER
sudo -u postgres psql
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:

sudo apt-get install phppgadmin

Remote access

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

sudo nano /etc/apache2/conf.d/phppgadmin

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

sudo service apache2 reload