1

Source of launchd job: org.postgresql.postgres

view story
linux-howto

http://serverfault.com – 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.plist', which has completely different config-params then the loaded job. I also did an '# mdfind org.postgresql.postgres', but that didn't give me any clue either. So... Where did this job come from? C (HowTos)

grtyyu's picture
Submitted by grtyyu on 10/16/2012

Stories similar to Source of launchd job: org.postgresql.postgres

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.

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.

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

Context:

I'm automatically installing postgresql-9.1 on an Ubuntu server with apt-get. This creates the required postgres user.

The Postgres data is on an external volume that survives reinstalls. This data is obviously owned by the postgres user.

The problem I'm having is that the ownership is not recorded under the name postgres, but under the UID that postgres had at creation time.

postgres logfile 27 weeks 3 days ago

I have installed postgres on f18 x86_64 with the following packages

rpm -qa | grep postgres postgresql-libs-9.2.2-1.fc18.x86_64 postgresql-server-9.2.2-1.fc18.x86_64 postgresql-9.2.2-1.fc18.x86_64

These are the instructions I could find to setup and start postgres

su - cd /usr/lib64/pgsql su postgres

$ initdb -D /var/lib/pgsql/data $ pg_ctl -D /v

Hello!

Running Ubuntu 13.04 since it's release. Suddenly I am having problem with Postgres, googled and tried out some suggestions for getting postgres right again - but failing :Setting up postgresql-common (140) ... * Starting PostgreSQL 9.1 database server * The PostgreSQL server failed to start.

I have a 12.04 box running postgresql 9.1.8-0ubuntu12.04, which serves a Java webapp (an Atlassian Confluence wiki). I'm trying to take advantage of powernap's IOMonitor feature. However, if I uncomment the corresponding line in /etc/powernap/config:

[IOMonitor] postgres-io = "postgres"

...