Re: Move cluster to new host, upgraded version

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Move cluster to new host, upgraded version
Date: 2018-11-14 15:31:02
Message-ID: 7982.1542209462@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Rich Shepard <rshepard(at)appl-ecosys(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2018-11-14 15:50:52 Re: Move cluster to new host, upgraded version
Previous Message Adrian Klaver 2018-11-14 15:05:55 Re: Move cluster to new host, upgraded version