How to Install Latest PostgreSQL 9.4.X on Lubuntu 12.04 Precise LTS 32/64-bit Linux Easy Guide

April 1, 2014 | By thelinuxevangelist | Filed in: Tutorial.

Install PostgreSQL 9.x on Lubuntu 12.04 Precise 32/64-bit

The Tutorial Shows You How to Install and Getting-Started with PostgreSQL 9.x Database for Lubuntu 12.04 Precise Pangolin LTS i386/amd64 Linux.

As with every annual release, PostgreSQL 9.x includes many New Features to make working with PostgreSQL easier, more flexible and more fun for application developers, administrators and architects.

The New PostgreSQL Features include:

  • Additional JSON constructor and extractor methods
  • Automatically updatable VIEWs
  • Parallel pg_dump to speed backups of large databases
  • LATERAL JOINs

Further, PostgreSQL 9.4’s User-Defined Background Workers allow developers to write task managers, request handlers, parallel processors, queuing tools and other helper applications to enable PostgreSQL as a workload coordinator.

One example of this already released is Mongres, a background worker which accepts MongoDB queries, interprets them and passes them on to PostgreSQL.

To the PostgreSQL Database Installation Lubuntu 12.04 Precise Guide Bottom You find Link to Quick-Start with PostgreSQL on Lubuntu Linux.

Lubuntu 12.04 Precise Install PostgreSQL 9.X - Featured
  1. Download PostgreSQL DB for Linux:

    Linux PotrgreSQL Installer
  2. Open Terminal Window
    (Press “Enter” to Execute Commands)

    Lubuntu 12.04 Precise Install PostgreSQL 9.X - Open Terminal
  3. Give Permissions and Start PostgreSQL Installer

    cd ~/Downloads/
    sudo su -c "chmod +x ./postgresql-9.*.run"
    sudo su -c "./postgresql-9.*.run"
  4. Get Installed DropBox for Easy Stuff Sharing

    Installing DropBox for Lubuntu
  5. Follow PostgreSQL Installation Wizard

    Lubuntu 12.04 Precise Install PostgreSQL 9.X - welcome

    Set the PostgreSQL Installation Path.

    Lubuntu 12.04 Precise Install PostgreSQL 9.X - path

    Set the PostgreSQL Data Path.

    Lubuntu 12.04 Precise Install PostgreSQL 9.X - data path

    Set-Up the Postgres Administrator.

    Lubuntu 12.04 Precise Install PostgreSQL 9.X - user setup

    Set the PostgreSQL Server Listening Port.

    Lubuntu 12.04 Precise Install PostgreSQL 9.X - listening port

    Set the PostgreSQL Database Locale in Use.

    Lubuntu 12.04 Precise Install PostgreSQL 9.X - setup locale

    Start PostgreSQL Installation.

    Lubuntu 12.04 Precise Install PostgreSQL 9.X - start installation
    Lubuntu 12.04 Precise Install PostgreSQL 9.X - installing

    Last Eventually Add some PostgreSQL Tools

    Lubuntu 12.04 Precise Install PostgreSQL 9.X - postgresql add-ons

  6. Getting-Started Quickly with PostgreSQL on Lubuntu:

    PostgreSQL Quick-Start Guide

Tags: , , , , , , , , , , , ,