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?
I am new to linux and wants to understand the reason for using some commands. I am trying to install PostgreSQL on CentOs by following the instructions here.
First we do rpm -ivh pgdg-centos91-9.1-4.noarch.rpm which installs the rpm package into the system.
I have installed postgresql using pacman. And followed the wiki to get started. But, I got stuck at starting the server.
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"?
PostgreSQL is one of the most versatile, powerful and reliable object-relational database systems available. The enterprise-class open source database is in use by some of the largest companies in the world, handling exceptionally large workloads. But you knew all of that already, so let's talk about a few features in PostgreSQL you probably didn't know about already.
I installed PostgreSQL 9.1.2 on my fedora 16 in a method similar to mentioned here, and tested it, which means that my installation is working fine.
But when I do: service postgresql initdb or even service postgresql-9.0 initdb I get the error:
Redirecting to /bin/systemctl initdb postgresql.service
Unknown operation initdb
And because of this, I am unable to start pgAdmin3 too.
What am I mi
I have a postgres 8.4 install on ubuntu 10.04.
I created a cluster on a disk that is not mountable anymore.
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.