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
3 SP-GiST
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.1 DROP INDEX CONCURRENTLY
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

Upgrade

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