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?
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
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?
when I wanna doing anything with Synaptic or apt-get or stop , start, restart postgresql I will recivied following error
Setting up postgresql-common (114) ...
* Starting PostgreSQL 8.4 database server * Insecure directory in $ENV{PATH} while running with -T switch at /usr/bin/pg_ctlcluster line 63.
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
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.
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 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.
Email this page
