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 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
I am running postgresql but with every system reboot, the symbolic link /tmp/.s.PGSQL.5432 gets deleted so I have to manually create it through
sudo ln -s /tmp/.s.PGSQL.5432 /var/run/postgresql/.s.PGSQL.5432
and only then postgres start. Is there anyway I can automate this (say the command running at the time system starts) ? also why this /tmp link for postgres ?
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 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'm trying to setup rails 3.0.10 on a Ubuntu VPS server. I'm using postgres 9.0.4, Apache and passenger.
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.
Email this page
