Re: Move cluster to new host, upgraded version - Mailing list pgsql-general

From Tom Lane
Subject Re: Move cluster to new host, upgraded version
Date
Msg-id 7982.1542209462@sss.pgh.pa.us
Whole thread Raw
In response to Re: Move cluster to new host, upgraded version  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Move cluster to new host, upgraded version
List pgsql-general
Rich Shepard <rshepard@appl-ecosys.com> writes:
>    ps ax | grep postgres
> shows a number of processes, but psql tells me there's no server running,
> and there is no postmaster.opts or postmaster.pid in the data directory.

Perhaps those are associated with some other data directory?

You could try using lsof on one of them to see what its current working
directory is (or on Linux, examine /proc/NN/cwd).  lsof on whichever
one(s) is/are postmasters would also tell you what sockets they're
listening on.

            regards, tom lane


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Move cluster to new host, upgraded version
Next
From: Rich Shepard
Date:
Subject: Re: Move cluster to new host, upgraded version