How to install postgresql 9.2 on ubuntu 13.04 (Raring Ringtail) Server

Sponsored Link
PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others.

What is new in version 9.2

This release has been largely focused on performance improvements, though new SQL features are not lacking. Work also continues in the area of replication support. Major enhancements include:

Allow queries to retrieve data only from indexes, avoiding heap access (index-only scans)

Allow the planner to generate custom plans for specific parameter values even when using prepared statements

Improve the planner's ability to use nested loops with inner index scans

Allow streaming replication slaves to forward data to other slaves (cascading replication)

Allow pg_basebackup to make base backups from standby servers

Add a pg_receivexlog tool to archive WAL file changes as they are written

Add the SP-GiST (Space-Partitioned GiST) index access method

Add support for range data types

Add a JSON data type

Add a security_barrier option for views

Allow libpq connection strings to have the format of a URI

Add a single-row processing mode to libpq for better handling of large result sets

Install postgresql 9.2 on ubuntu 13.04 Server

Create /etc/apt/sources.list.d/pgdg.list

sudo vi /etc/apt/sources.list.d/pgdg.list

and add the following line

deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main

Save and exit the file

Add the GPG key

wget --quiet -O -- http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | sudo apt-key add --

Update the source list

sudo apt-get update

Install postgresql

sudo apt-get install postgresql-common -t raring

sudo apt-get install postgresql-9.2

You can check the postgresql version using the following command

psql --version

Sponsored Link

You may also like...

1 Response

  1. Alexander says:

    $ wget –quiet -O — http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | sudo apt-key add –
    gpg: no valid OpenPGP data found.

    There should be only one ‘-‘:

    wget –quiet -O – http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc

Leave a Reply

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