11

[lubuntu] PostgreSQL v9.x - Install from source code

view full story
linux-howto

http://ubuntuforums.org – 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. Please not a adduser command to add a postgres user. I downloaded the 8.4 sources from ubuntu but did not find any of those pre installation or post installation scripts apt-get run during a normal apt-get install. Does any one knows how can i add the postgres user the same way apt-get d (Hardware)

colm's picture
Submitted by colm on 02/29/2012 – Made popular on 02/29/2012

Stories similar to [lubuntu] PostgreSQL v9.x - Install from source code

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.

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

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'm trying to get this command to work as the user postgres (so I can ship wal files):

rsync -a /tmp/test postgres@server2:/tmp/test

But I get the error:

Permission denied (publickey).

I've run ssh-keygen eval `ssh-agent` and ssh-add as postgres user on server1.

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.

What are the permissions for /var/lib/pgsql? A fresh yum install of postgresql-server sets the directory and all subdirs to postgres:postgres 700. I believe all files in /var/lib/pgsql/data after... [by Winter]

I have a PostgreSQL server running on a remote Debian Squeeze server. I would like to login with the user postgres using the ident and md5 method at the same time. The former is needed for debian maintenance.

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?