1

[ubuntu] Upgrading Postgres 9.2

view story
linux-howto

http://ubuntuforums.org – 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 don't want to have two PostgreSQL on my system. (Hardware)

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

Stories similar to [ubuntu] Upgrading Postgres 9.2

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

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 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

How do I upgrade to Postgres 9.2? 36 weeks 17 hours ago

Just recently, I've read that PostgreSQL 9.2 is released. My Ubuntu 12.04 has PostgreSQL 9.1.5 installed. How can I update to 9.2 version? I tried apt-get update and apt-get upgrade but no updates for PostgreSQL.

I need to compile and install postgresql from source code in a fresh install, no use of apt-get or dpkg and no postgres user created yet. Compiling and installing is already done, i need those script to start and stop the postgresql service and the creating of postgres user the exactly same way ubuntu does.

I installed Postgresql 8.4 on my VPS with Ubuntu 10.04. Default setup, nothing unusual. After the installation the dbserver is automatically started and is running great. The installer also sets a init.d script in place.

This script however, doesn't seem to affect Postgres.

$ sudo /etc/init.d/postgresql stop

The above line is not stopping the server.

This appears to be very messy, so I would like to remove all trace of PostgreSQL on my system. I followed various instructions found on the web, but to no avail. After that, what's the best way to install 9.1?

I'm trying to run a cronjob to backup my database every day.

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?