{"action":"created","issue":{"url":"https://api.github.com/repos/zalando/pg_view/issues/7","labels_url":"https://api.github.com/repos/zalando/pg_view/issues/7/labels{/name}","comments_url":"https://api.github.com/repos/zalando/pg_view/issues/7/comments","events_url":"https://api.github.com/repos/zalando/pg_view/issues/7/events","html_url":"https://github.com/zalando/pg_view/issues/7","id":24630530,"number":7,"title":"Problem with PG 9.3","user":{"login":"DaniloE","id":6231566,"avatar_url":"https://avatars.githubusercontent.com/u/6231566?v=3","gravatar_id":"","url":"https://api.github.com/users/DaniloE","html_url":"https://github.com/DaniloE","followers_url":"https://api.github.com/users/DaniloE/followers","following_url":"https://api.github.com/users/DaniloE/following{/other_user}","gists_url":"https://api.github.com/users/DaniloE/gists{/gist_id}","starred_url":"https://api.github.com/users/DaniloE/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DaniloE/subscriptions","organizations_url":"https://api.github.com/users/DaniloE/orgs","repos_url":"https://api.github.com/users/DaniloE/repos","events_url":"https://api.github.com/users/DaniloE/events{/privacy}","received_events_url":"https://api.github.com/users/DaniloE/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":{"login":"alexeyklyukin","id":339913,"avatar_url":"https://avatars.githubusercontent.com/u/339913?v=3","gravatar_id":"","url":"https://api.github.com/users/alexeyklyukin","html_url":"https://github.com/alexeyklyukin","followers_url":"https://api.github.com/users/alexeyklyukin/followers","following_url":"https://api.github.com/users/alexeyklyukin/following{/other_user}","gists_url":"https://api.github.com/users/alexeyklyukin/gists{/gist_id}","starred_url":"https://api.github.com/users/alexeyklyukin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alexeyklyukin/subscriptions","organizations_url":"https://api.github.com/users/alexeyklyukin/orgs","repos_url":"https://api.github.com/users/alexeyklyukin/repos","events_url":"https://api.github.com/users/alexeyklyukin/events{/privacy}","received_events_url":"https://api.github.com/users/alexeyklyukin/received_events","type":"User","site_admin":false},"milestone":null,"comments":19,"created_at":"2013-12-20T15:46:49Z","updated_at":"2015-12-17T09:30:45Z","closed_at":"2014-01-30T17:11:06Z","body":"Hi there,\r\n\r\ni tried to run pg_view with PG 9.3, but there i always got the message \"No suitable PostgreSQL instances detected, exiting...\". I found the reason for the issue and I think it's the easiest way, when i post you my diff:\r\n```\r\n--- pg_view.py_doesntwork   2013-12-20 16:09:19.000000000 +0100\r\n+++ pg_view.py  2013-12-20 16:18:36.000000000 +0100\r\n@@ -2677,7 +2677,7 @@\r\n             logger.error('failed to read {0}'.format(stat_file_name))\r\n             continue\r\n         # read PostgreSQL processes. Avoid zombies\r\n-        if len(stat_fields) < STAT_FIELD_START_TIME + 1 or stat_fields[STAT_FIELD_PROCESS_NAME] != '(postgres)' \\\r\n+        if len(stat_fields) < STAT_FIELD_START_TIME + 1 or stat_fields[STAT_FIELD_PROCESS_NAME] != '(postmaster)' \\\r\n             or stat_fields[STAT_FIELD_STATE] == 'Z':\r\n             if stat_fields[STAT_FIELD_STATE] == 'Z':\r\n                 logger.warning('zombie process {0}'.format(pid))\r\n@@ -2703,7 +2703,7 @@\r\n                 if cmd_line:\r\n                     fields = cmd_line.split('\\x00')\r\n                     if len(fields) > 2:\r\n-                        data_dir = fields[2]\r\n+                        data_dir = fields[4]\r\n                         postmaster_data_dirs.append(data_dir)\r\n                         postmaster_pids.append(pid)\r\n     return dict(zip(postmaster_data_dirs, postmaster_pids))\r\n```\r\nI hope that helps, if it's a configuration-problem on my instance, sorry for the post.\r\nI'm using the official repo from PG for the Installation and started the instance via Init-Script, if this is necessary."},"comment":{"url":"https://api.github.com/repos/zalando/pg_view/issues/comments/165394477","html_url":"https://github.com/zalando/pg_view/issues/7#issuecomment-165394477","issue_url":"https://api.github.com/repos/zalando/pg_view/issues/7","id":165394477,"user":{"login":"sgnatjuk","id":16321331,"avatar_url":"https://avatars.githubusercontent.com/u/16321331?v=3","gravatar_id":"","url":"https://api.github.com/users/sgnatjuk","html_url":"https://github.com/sgnatjuk","followers_url":"https://api.github.com/users/sgnatjuk/followers","following_url":"https://api.github.com/users/sgnatjuk/following{/other_user}","gists_url":"https://api.github.com/users/sgnatjuk/gists{/gist_id}","starred_url":"https://api.github.com/users/sgnatjuk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sgnatjuk/subscriptions","organizations_url":"https://api.github.com/users/sgnatjuk/orgs","repos_url":"https://api.github.com/users/sgnatjuk/repos","events_url":"https://api.github.com/users/sgnatjuk/events{/privacy}","received_events_url":"https://api.github.com/users/sgnatjuk/received_events","type":"User","site_admin":false},"created_at":"2015-12-17T09:30:45Z","updated_at":"2015-12-17T09:30:45Z","body":"Hi!\r\nPlease tell me if I could talk with his you in their native language?\r\nI am afraid that I can not describe the problem in detail.\r\nI use a special patched version postgreskl to 1S8.\r\nLink - https://www.postgrespro.ru/products/1c_build\r\nMost likely this problem.\r\nIn Conf. File specified: #unix_socket_directory = '' # (change requires restart)\r\n\r\nThe parameter description is written:\r\nAn empty value specifies not listening on any Unix-domain sockets, in which case only TCP/IP sockets can be used to connect to the server. The default value is normally /tmp, but that can be changed at build time. This parameter can only be set at server start.\r\n\r\nlistens to port 5432\r\nI connect on the TСP IP and using this port, but with other programs.\r\nHelp me please."}}