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 1erdoX-0001Wk-Bg for pgsql-docs@arkaria.postgresql.org; Fri, 02 Mar 2018 06:05: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 1erdoV-0001gm-EQ for pgsql-docs@arkaria.postgresql.org; Fri, 02 Mar 2018 06:05:03 +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 1erdoV-0001gS-2z for pgsql-docs@lists.postgresql.org; Fri, 02 Mar 2018 06:05:03 +0000 Received: from mail-lf0-x243.google.com ([2a00:1450:4010:c07::243]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1erdoO-00083B-1m for pgsql-docs@lists.postgresql.org; Fri, 02 Mar 2018 06:05:01 +0000 Received: by mail-lf0-x243.google.com with SMTP id y19so11788775lfd.4 for ; Thu, 01 Mar 2018 22:04:55 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=MjWZOuhNmbLGsfY6MdTHmuzEk3Jgae2JAWRLe8Adc6E=; b=m2V0IurVW8WQpW//s89Itlv2g77jXzRNxChNdis3HZ+ltaGiVUt+ljUyjFUUTce6VJ v24Tnwk7t0UUN/61blHhb0hzD93X+rYxxyH3t5pcqHHeLPo9j9AZ7cF4hARqJ8FiQ5Gj QQvJizjQ1FaaaZWWdJ3KS1Bu2G3pcHOqldFAPWLcG6Ozvv9bSleRd4zdVz1ur02QRx64 AJlViZlR59CncgjG7CIhlIxALfOb4mEedAu2DGSE2dJjvc2OGsgEsCj8uXKskvEcJ7BX hPM/sdNSFJPbfTIkA+TlBwoYI3XRaRGOWN64nuHRHd/xwFu1AxRcVHZVY1iflmAe+r8U OXMg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=MjWZOuhNmbLGsfY6MdTHmuzEk3Jgae2JAWRLe8Adc6E=; b=S3p0+Onojp5P2TTqnEZoCQeeLHM40deyfeYfqGQNttOoHrdKdR/rRlK8w1cq5nGnEQ Z1Z84J84KIMcRosppKfLo+X9VhQ159jYZz0qWFtIow/DTpmnPBovyEk9avO5KLxOagGi uR7+o/nd/TNbNf6F09f3M3i3VBRxxyjirerTsbf8nfHHyHhp+8I1a8ipCmwedHyqwe2P xE3NVjDjnkoG+dkoCJc+bkhOYWJQjXY1jh5fQcA3wRQr/Y8bUHdxi6Y7z+74RM67MEfa 0TqstqScGkhIDLwiabXq39+yjO1a77sT2hLw3CptiZDT2Jksz6961GhGZpZ7ZFZve5b5 5Q2A== X-Gm-Message-State: AElRT7E1JDQNc9G+lS7UInBKZig5aL41ISvRAwl/bW/iMHVMjCwabcCh tTaO2Wg61cLD9Ml5mOfNs3Y1t+OmM7p1g+AzbBo= X-Google-Smtp-Source: AG47ELtZV+9GA7+zMLXLIQ16oFQD8HzmRG5KBHvHFRLLSuG69Pc1XxWBMGMfAVAIdT36B9OYTOxqoZPAF/jv5jXclaE= X-Received: by 10.46.42.67 with SMTP id q64mr2918664ljq.133.1519970692986; Thu, 01 Mar 2018 22:04:52 -0800 (PST) MIME-Version: 1.0 From: Greg k Date: Fri, 02 Mar 2018 06:04:42 +0000 Message-ID: Subject: Postgres 10 and the pg_ctl "--wait" option To: pgsql-docs@lists.postgresql.org Content-Type: multipart/alternative; boundary="f403043a1c10397d16056667c182" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --f403043a1c10397d16056667c182 Content-Type: text/plain; charset="UTF-8" In PostreSql 10, the documentation for pg_ctl and the "--wait" option says "Startup is considered complete when the PID file indicates that the server is ready to accept connections." When I do a point-in-time recovery followed by a start with "/usr/pgsql-10/bin/pg_ctl start -D /data -w -t 86400", I then try to connect immediately after pg_ctl finishes. But I get a connection error "psql: FATAL: the database system is starting up" . It seems the postmaster.pid file state goes from 'starting' to 'standby' to 'ready' but pg_ctl is saying the server is ready to accept connections when the postmaster.pid file says 'standby'. Am I misunderstanding the documentation? Thanks, Greg --f403043a1c10397d16056667c182 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
In PostreSql 10, the documentation for pg_ctl and the= "--wait" option says "Startup is considered complete when t= he PID file indicates that the server is ready to accept connections."=

When I do a point-in-time recovery followed by a = start with "/usr/pgsql-10/bin/pg_ctl start -D /data -w -t 86400",= I then try to connect immediately after pg_ctl finishes. But I get a conne= ction error "psql: FATAL:=C2=A0 the database system is starting up&quo= t; . It seems the postmaster.pid file state goes from 'starting' to= 'standby' to 'ready' but pg_ctl is saying the server is re= ady to accept connections when the postmaster.pid file says 'standby= 9;. Am I misunderstanding the documentation?

Thank= s,
Greg
--f403043a1c10397d16056667c182--