After the release of PostgreSQL 9.2 I tested a OpenERP server with this release of Postgres. And I was surprised finding out the speed of OpenERP increased enormously. I would recommend it to anyone using OpenERP 7.0 at this moment.

If you want to use PostgreSQL 9.2 on OpenERP 7.0 use my guide to install OpenERP on Ubuntu 12.04 and use the part below instead of:

apt-get install postgresql

Installation of repository from PGDG for latest postgres version in Ubuntu 12.04
Import the repository key from http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc:

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

Edit /etc/apt/sources.list.d/pgdg.list. and add the repo to your sources:

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

Add the following to the file:

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

Configure apt’s package pinning to prefer the PGDG packages over the Debian ones in /etc/apt/preferences.d/pgdg.pref:

sudo vi /etc/apt/preferences.d/pgdg.pref

Add the following to the file:

Package: *
Pin: release o=apt.postgresql.org
Pin-Priority: 500

Note: this will replace all your Debian/Ubuntu packages with available packages from the PGDG repository. If you do not want this, skip this step.

Update the package lists, and install the pgdg-keyring package to automatically get repository key updates:

sudo apt-get update
sudo apt-get install pgdg-keyring

Install the PostgreSQL server

sudo apt-get install postgresql-9.2

Continu with the OpenERP v7 install guide