How to install PostgreSQL 9.2 on ubuntu server using PPA

Sponsored Link
PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) available for many platforms including Linux, FreeBSD, Solaris, Microsoft Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software. PostgreSQL is developed by the PostgreSQL Global Development Group, consisting of a handful of volunteers employed and supervised by companies such as Red Hat and EnterpriseDB.It implements the majority of the SQL:2008 standard,is ACID-compliant, is fully transactional (including all DDL statements), has extensible data types, operators, index methods, functions, aggregates, procedural languages, and has a large number of extensions written by third parties.

What is new in version 9.2

1 Major new features
1.1 Index-only scans
1.2 Replication improvements
1.3 JSON datatype
1.4 Range Types
2 Performance improvements
4 pg_stat_statements
5 Explain improvements
6 Backward compatibility
6.1 Ensure that xpath() escapes special characters in string values
6.2 Remove hstore's => operator
6.3 Have pg_relation_size() and friends return NULL if the object does not exist
6.4 Remove the spclocation field from pg_tablespace
6.5 Have EXTRACT of a non-timezone-aware value measure the epoch from local midnight, not UTC midnight
6.6 Fix to_date() and to_timestamp() to wrap incomplete dates toward 2020
6.7 pg_stat_activity and pg_stat_replication's definitions have changed
6.8 Change all SQL-level statistics timing values to float8-stored milliseconds
6.9 postgresql.conf parameters changes
7 Other new features
7.2 NOT VALID CHECK constraints
7.3 NO INHERIT constraints
7.4 Reduce ALTER TABLE rewrites
7.5 Security barriers and Leakproof
7.6 New options for pg_dump

Preparing your system

First you need to install required libs from the following command

sudo apt-get install libpq-dev

Install PostgreSQL 9.2 in ubuntu

Open the terminal and run the following commands

sudo add-apt-repository ppa:pitti/postgresql
sudo apt-get update
sudo apt-get install postgresql-9.2


If you want to upgrade from previous versions run the following command (Make sure you have added postgres PPA)

sudo apt-get upgrade

Configuration files

Default config directory is: /etc/postgresql/9.2/main
Default data directory is: /var/lib/postgresql/9.2/main

Sponsored Link

You may also like...

2 Responses

  1. Marco says:

    This week I tried to install postgresql 9.2 on a ubuntu 13.04 (raring) installation. Unfortunately this repo ppa:pitti is deprecated for 13.04. I couldnt find another repo.

    Didn’t feel like building it myself, I want to be able to use apt-get to upgrade.

    Does anyone have any suggestions?

  2. CrazyMoFo says:

    you can follow the steps described here to install it from the mode official repo:
    it’s not a ppa, so you’ll have to edit the sources.list files yourself.
    also 13.04 is not officially supported (and on a server you probably want to use the LTS version)
    but i thin the precise-packages should work

Leave a Reply

Your email address will not be published. Required fields are marked *