Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gqfsq-0005ud-Nt for pgsql-general@arkaria.postgresql.org; Mon, 04 Feb 2019 15:10:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gqfsp-0007ZQ-4X for pgsql-general@arkaria.postgresql.org; Mon, 04 Feb 2019 15:10:03 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gqfso-0007ZH-Ou for pgsql-general@lists.postgresql.org; Mon, 04 Feb 2019 15:10:02 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gqfsm-0000pG-3g for pgsql-general@postgresql.org; Mon, 04 Feb 2019 15:10:01 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id 4A54221B13; Mon, 4 Feb 2019 10:09:59 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute6.internal (MEProxy); Mon, 04 Feb 2019 10:09:59 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= subject:to:references:from:message-id:date:mime-version :in-reply-to:content-type:content-transfer-encoding; s=fm2; bh=d z/h93zqx6bGlQ8Aut7289w+rOGx1h0iRAdVV7r4NJY=; b=CAIdInRb6/Tx9G5ag boiQ56j2voQKfBTdQy6/qKvduRVYokOttr8GQureHayyzmL0lna+UHzRnTYeFw+X Ks7gygpCtsVn++6Vi6VTQC7lnPEMFuih/BSpH8bWKxw8oyW7PYRPxaF+YBjBbokM Y7GWKpvu+UF8iDON4HrFXL0Kbwi3bvjmBbimkUf+HL08jYBA0mzTyKoaHFk7ih/i yrzkviNghohdGj3k94dPwgC9CePsDFJdoYMHw9vkIabwtfkbh1tbPh8yjAskpQex ZA5MuZnVaJQVyhU1NdnrJOF0hreRxeH3XuXiQVA5T1eFQr82nUYNpKuYDsNCxit8 UaIZw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm1; bh=dz/h93zqx6bGlQ8Aut7289w+rOGx1h0iRAdVV7r4N JY=; b=fnTtS2bDwJMoNAvL4TDRfaUjg/EhAryo1X0h/bPXnRjn5Xg2JuGfmt4lw cLb0Igsz2YUQXpF+O+buK1GHlREWB+KnsIfbG9rCaS576b+mrYt3tM1xVvb0aof7 1DCobdjeRFww7EmmP7uGzqOptfJACnq+2QjWgNpcn8wOB8j5X7zXjOaASEayynbW R+kcDKsE+fnWUpRI2+5BOx5jRcX1ihadoyYJs8fFgmIi4bMtI+TsISLrwyvy+kks PGUqOG1OudszVIPgvBsIz4UpFAYAmX7TB3G259n8vci6bppU+eHc8uOFvLIjLQDR wHGurjeRf0iKcdEd+60QwLukTcMkw== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedtledrkeeggdejfecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfhuthenuceurghilhhouhhtmecufedt tdenucenucfjughrpefuvfhfhffkffgfgggjtgfgsehtkeertddtfeejnecuhfhrohhmpe etughrihgrnhcumfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgv rhdrtghomheqnecuffhomhgrihhnpehpohhsthhgrhgvshhqlhdqrghrtghhihhvvgdroh hrghenucfkphepjedurddvuddvrdduhedtrddvtddvnecurfgrrhgrmhepmhgrihhlfhhr ohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhmnecuvehluhhsth gvrhfuihiivgeptd X-ME-Proxy: Received: from [192.168.1.4] (unknown [71.212.150.202]) by mail.messagingengine.com (Postfix) with ESMTPA id 2D76910312; Mon, 4 Feb 2019 10:09:58 -0500 (EST) Subject: Re: Server goes to Recovery Mode when run a SQL To: PegoraroF10 , pgsql-general@postgresql.org References: <1549209182255-0.post@n3.nabble.com> <37bc715f-12e2-84ac-6492-88d7b6306777@aklaver.com> <1549211574297-0.post@n3.nabble.com> <0689b9bcac79f7f5e76ed69dd4baea012d6a3d33.camel@gmail.com> <1549278827534-0.post@n3.nabble.com> From: Adrian Klaver Message-ID: <7719c8bd-2e98-8a67-d01d-3b111e8d669c@aklaver.com> Date: Mon, 4 Feb 2019 07:09:57 -0800 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.3.0 MIME-Version: 1.0 In-Reply-To: <1549278827534-0.post@n3.nabble.com> Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2/4/19 3:13 AM, PegoraroF10 wrote: > Nothing was change, Postgres 10, Ubuntu 16.04 and Schema was the same, before > and after that problem. Well something changed or you would not be having a problem. > Well, that database is replicated and on replicated server that problem > doesn´t occur. Define what you mean by replicated? > > > > -- > Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html > > -- Adrian Klaver adrian.klaver@aklaver.com