1

How to install PostgreSQL 9.2 on ubuntu server using PPA

view story
linux-howto

http://www.ubuntugeek.com – 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 (HowTos)

dayu's picture
Submitted by dayu on 09/20/2012

Stories similar to How to install PostgreSQL 9.2 on ubuntu server using PPA

PostgreSQL is one of the most versatile, powerful and reliable object-relational database systems available. The enterprise-class open source database is in use by some of the largest companies in the world, handling exceptionally large workloads. But you knew all of that already, so let's talk about a few features in PostgreSQL you probably didn't know about already.

I installed postgresql 9.2 from "add-apt-repository ppa:pitti/postgresql" using "apt-get install postgresql-9.2"

At the end of the install and every time I try to launch postgresql by using the following command

/etc/init.d/postgresql start

or

service postgresql start

I get this error:

Error: could not exec /usr/lib/postgresql/9.2/bin/pg_ctl /usr/lib/postgresql/9.2/bin/pg_ctl start -D

Edit: see comment for answer.

I have an interesting question. On my OS X 10.8 server postgres is running fine.

Launchd has is loaded under the label 'org.postgresql.postgres' and '# launchctl list org.postgresql.postgres' gives the output I expected.

The problem is: I cant find the configuration file. In /S/L/LaunchDeamons and in /L/LaunchDeamons I only have an 'org.postgresql.postgres_alt.plis

I am trying to upgrade postgresql from 9.0.4 to 9.2.3 using the directions from the wiki (postgresql page, under "upgrading"), due to systemd causing my connections to be refused on my socket for 9.0.4...# pacman -S postgresql-old-upgrade postgresql-libs :: postgresql-libs is in IgnorePkg/IgnoreGroup. Install anyway?

Hi.

I've read that PostgreSQL 9.2 is released, however I tried to update my PostgreSQL 9.1.5 (Precise). I added Martin Pitt's PPA:

Code: sudo add-apt-repository ppa:pitti/postgresql sudo apt-get update sudo apt-get install postgres-9.2 However, it doesn't upgrade my 9.1.5, instead created a separate postgres. I'm confused how can I set 9.2 as my main?

I have a postgres 8.4 install on ubuntu 10.04. I created a cluster on a disk that is not mountable anymore.

The new version of PostGIS 1.2.0 already released. This new version fix many bugs and performance improvements of the previous PostGIS. You can download this PostGIS 1.2.0 from the link provided below this post. PostGIS Publisher Description: PostGIS adds support for geographic objects to the PostgreSQL object-relational database.

Navicat is a professional database administrator and development tool for many kind of database such as MySQL, SQL Server and PostgreSQL. Here you can download the latest version of Navicat for PostgreSQL 9.1.5 for Mac OS X users. It works with almost any version of PostgreSQL server. With Navicat for PostgreSQL you can easily connect [...]

I have installed postgresql via apt-get install postgresql, but have an error, don't make the folder /etc/postgresql/9.1.

The error on psql:

psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?