Rich Shepard <rshepard@xxxxxxxxxxxxxxx> 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
