Closed hfriedr closed 10 years ago
Hi,
Sorry for the late reply, the PostgreSQL auto detection code in pg_view has been revamped recently. Please, pull the latest version and let me know if you still have a problem.
Thanks. The problem has gone away in the latest version. (Moreover, the script now auto-detects postmaster processes running as 'postmaster' as well as ones running as 'postgres' all without editing the script.)
When running pg_view 1.1.0 on a box running three postmaster processes on various ports (PostgreSQL 9.2), we seem to get three times the same output, including three times the exact same process ID's. Is there something wrong with multi-postmaster support?
(I edited the script slightly, replacing ('postgres') by ('postmaster') to get around the "No suitable instances detected" issue.)
The idea to support multiple postmaster processes and to auto-detect the ports etc. certainly sounds good, but it looks like something is not quite right with that, or am I seeing things?