How-to Install Latest PostgreSQL 9.4.X on Mageia 32/64bit Linux Easy Guide

April 2nd, 2014 by thelinuxevangelist

Install PostgreSQL 9.x on Mageia 1/2/3/4 32/64bit




The Tutorial Shows You How-to Install and Getting-Started with Latest PostgreSQL 9.x Database for Mageia 1/2/3/4 i686/x8664 KDE/Gnome 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 Mageia Linux Guide Bottom You find Link to Quick-Start with PostgreSQL on Mageia Linux.

Mageia 13.10 Saucy Install Latest PostgreSQL 9.X - Featured
  1. Download Latest PostgreSQL DB for Linux:

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

    Mageia 13.10 Saucy Install Latest 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. Follow PostgreSQL Installation Wizard

    Mageia 13.10 Saucy Install Latest PostgreSQL 9.X - welcome

    Set the PostgreSQL Installation Path.

    Mageia 13.10 Saucy Install Latest PostgreSQL 9.X - path

    Set the PostgreSQL Data Path.

    Mageia 13.10 Saucy Install Latest PostgreSQL 9.X - data path

    Set-Up the Postgres Administrator.

    Mageia 13.10 Saucy Install Latest PostgreSQL 9.X - user setup

    Set the PostgreSQL Server Listening Port.

    Mageia 13.10 Saucy Install Latest PostgreSQL 9.X - listening port

    Set the PostgreSQL Database Locale in Use.

    Mageia 13.10 Saucy Install Latest PostgreSQL 9.X - setup locale

    Start PostgreSQL Installation.

    Mageia 13.10 Saucy Install Latest PostgreSQL 9.X - start installation
    Mageia 13.10 Saucy Install Latest PostgreSQL 9.X - installing

    Last Eventually Add some PostgreSQL Tools

    Mageia 13.10 Saucy Install Latest PostgreSQL 9.X - PostgreSQL add-ons

  5. Getting-Started Quickly with PostgreSQL on Mageia:

    PostgreSQL Quick-Start Guide
(Visited 31 times, 1 visits today)
Share on Tumblr

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


Comments are disabled