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"?
Something quite weird is happening. I have been working on a Django project for awhile, and everything has been going fine, but yesterday I quit using wifi, and started using ethernet.
I upgraded a server with a Rails application to Ubuntu 12.04 from 10.04 and cannot connect to Postgresql database now...
Here is the error message from Rails app:
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"
Also the pg_ctl start is not recognized as a command.
EDIT:
Tur
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 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?
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 have installed postgresql using pacman & now it doesn't start.
Hello,
I want to start PostgreSQL to use secure loging. Therefore i want to create a remote secure connection using the hostssl option in pg_hba.conf. However it is claimed that the PostgreSQL server must also be running with the -l (SSL) and -i (TCP/IP) options.
I'm trying to setup rails 3.0.10 on a Ubuntu VPS server. I'm using postgres 9.0.4, Apache and passenger.