How to install postgresql 9.2 on ubuntu 13.04 (Raring Ringtail) Server
Sponsored Link
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
$ 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