Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fAebN-0000zF-G4 for pgsql-admin@arkaria.postgresql.org; Mon, 23 Apr 2018 16:46:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fAebM-0006Zb-5k for pgsql-admin@arkaria.postgresql.org; Mon, 23 Apr 2018 16:46:04 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fAebL-0006ZR-Ob for pgsql-admin@lists.postgresql.org; Mon, 23 Apr 2018 16:46:03 +0000 Received: from mail-ot0-x233.google.com ([2607:f8b0:4003:c0f::233]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fAebJ-0002vt-Fc for pgsql-admin@postgresql.org; Mon, 23 Apr 2018 16:46:02 +0000 Received: by mail-ot0-x233.google.com with SMTP id y10-v6so4961059otg.10 for ; Mon, 23 Apr 2018 09:46:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=to:from:subject:message-id:date:user-agent:mime-version :content-transfer-encoding:content-language; bh=vXIuE4UEF96n3sTojXJH+2UNlqXZQBwQ7OtyKh8ShKE=; b=A2Q6j494QPsXH75cgzDfwQ0iQQBeC5+Gbwo7zOYXGpwVGH+endsC8UVZ3fCuZJU2+M 6g6ltouVT1k4uhcr0XT/BOcdCEC+fyC1+qbXeG7xH1YDK6sxsa3LClb9HgK8wh2nvFIJ 5+8Zeck3DGVk1yZbxBfIJTfRgiIHG839fNUWhS/HB7GmefdHilWfUWuu3MbhHU6Qp2rF aT4ZjUIwKU+7DdVaymGv4lk84I9DwUpNJMo3rfFaaSvVPkM7vVczt5rV3HAVTy8FZdhF I1QekHwxNEN73aO5CTLC+KJxrDhOE27VwXM3v+xxNpKbfdMwgFrB7pHsqlVfyye7ZHPk WLLA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:to:from:subject:message-id:date:user-agent :mime-version:content-transfer-encoding:content-language; bh=vXIuE4UEF96n3sTojXJH+2UNlqXZQBwQ7OtyKh8ShKE=; b=VK2dVZPMbrr+S3NEJ5u1ME0LTm9p/fyLGQSKw44r5K9hONndSGQR77wEQOUudAQGk5 CdI6u8Q/ax0f2kzz6rDD2lSbF5HoO68281Wjtu+tYwuD7jkASmRxu6ZkSeZlzK/gsbWP Bn7u+vG1btmt43uJXox42fAX7I33gJyfHHEmQfHYtt7E/Zfi2MVtQtdDTxthnqvob9rB aJqzOuv4uC3gaKyaKJCmEx6W6nJV+Gtknus8MzXUJK6EEodqD5E473NALCI5e2m4af0T MXafuadXV/mBcOIHaQHwOtR9XhyhfE2orEgRtvMcrLUItqWgE71w5ViDEKjDktxTF9bY 8MTQ== X-Gm-Message-State: ALQs6tCJQq/NERHNfBYsn5n5kebUWtMuWVYRCaLG+CU9/+qGitmdpEJR n7zPRMTCRKxDVi9rPucjIN6ctw== X-Google-Smtp-Source: AIpwx4/7FkTuc6GMkO6KEze86UFnh0tenF6ArFlxS+DJNpdDjCn13BhIw1AnchH65IQ7DYmV/1Aopw== X-Received: by 2002:a9d:14e7:: with SMTP id r36-v6mr13398365otr.142.1524501960272; Mon, 23 Apr 2018 09:46:00 -0700 (PDT) Received: from [192.168.1.10] (ip70-171-116-89.no.no.cox.net. [70.171.116.89]) by smtp.googlemail.com with ESMTPSA id d128-v6sm7185004oia.53.2018.04.23.09.45.59 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 23 Apr 2018 09:45:59 -0700 (PDT) To: "pgsql-admin@postgresql.org" From: Ron Subject: Health checks after machine crash? Message-ID: Date: Mon, 23 Apr 2018 11:45:58 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.7.0 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi, v8.4 (Yes, it's archaic.  Upgrade plan is in progress.) What queries should I run against the catalog tables to see whether or not the cluster is healthy after reboot? Thanks -- Angular momentum makes the world go 'round.