1

How to create permanent Symbolic link in /tmp folder to start postgres ?

view story
linux-howto

http://stackoverflow.com – 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 ? I am sure there is a better solution then to keep on creating the /tmp link after every reboot I am on ubuntu 12.10 btw Thanks (HowTos)

linuxletgo's picture
Submitted by linuxletgo on 01/21/2013

Stories similar to How to create permanent Symbolic link in /tmp folder to start postgres ?

postgres logfile 27 weeks 2 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

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'm trying to setup rails 3.0.10 on a Ubuntu VPS server. I'm using postgres 9.0.4, Apache and passenger.

PostgreSQL doesn't start 33 weeks 1 day ago

I have installed postgresql using pacman & now it doesn't start.

Hello all,

I can't start postgresql and logs are empty. Here is the complete steps I did so far:

I just installed Opensuse 11.2, got it up to date. Then I zypped in postgresql and postgresql-server.

When I first did rcpostgresql start, after a while (a minute or so of waiting) I got a message "could not start server". Bummer.

I'm trying to install enkompass 3.0 on windows server 2008 x64 standart and each time I try to install it, it ends up with tis error:

Calling custom action PostgreSQLActions!PostgreSQLActions.CustomActions.SetupPostgresSQL Beginning SetupPostgresSQL Postgresql directory, C:\Program Files (x86)\cPanel\postgres\pgsql-8.4\bin, does not exist. Unzipping C:\Program Files (x86)\cPanel\postgres\p

I have installed postgresql via apt-get install postgresql, but have an error, don't make the folder /etc/postgresql/9.1.

The error on psql:

psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

i have installed the postgre via apt-get install postgresql, but have a error, dont make the folder /etc/postgresql/9.1

the error on 'psql':

psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

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?