Try, ps -ef | grep postgres and see how many postgres processes are running. You might only need one.
On Mon, Jul 27, 2015 at 6:01 PM, Greg Sabino Mullane <greg@turnstep.com> wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160
Austen Birchall wrote: > postgres=# SHOW data_directory; > /var/lib/pgsql/data ... > postgres=# SHOW data_directory; /var/lib/pgsql/9.4/data ... > 1. How/when is the value of data_directory set - is it set as part of the install?
Yes. It is set when Postgres starts up, and cannot be changed without a restart. The value can be hard-coded in your postgresql.conf file, but usually defaults to the PGDATA environment variable, or the -D option to the 'postgres' program. > 2. Is it possible to change the value of data_directory without doing a frest install?
Yes. But I would be careful, it looks like you have may have two active clusters. I'd document everything clearly before proceeding: use "show port" and "show unix_socket_directories" to learn why you can connect to both clusters at the same time, if that is the case.