From: Michael Paquier <michael@paquier.xyz>
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: PegoraroF10 <marcos@f10.com.br>
Cc: pgsql-general@postgresql.org
Subject: Re: Server goes to Recovery Mode when run a SQL
Date: Mon, 4 Feb 2019 10:07:09 +0900
Message-ID: <20190204010709.GC1881@paquier.xyz> (raw)
In-Reply-To: <cfcb3858-d169-652c-71a7-5d77f295085a@aklaver.com>
References: <1549209182255-0.post@n3.nabble.com>
<37bc715f-12e2-84ac-6492-88d7b6306777@aklaver.com>
<1549211574297-0.post@n3.nabble.com>
<cfcb3858-d169-652c-71a7-5d77f295085a@aklaver.com>
On Sun, Feb 03, 2019 at 10:05:46AM -0800, Adrian Klaver wrote:
> On 2/3/19 8:32 AM, PegoraroF10 wrote:
>> I have a complex query which puts my server in recovery mode every time I
>> run it.
>> I don´t need to say that recovery mode is a situation you don´t want your
>> server goes to.
Do you mean that your server crashes after running a SQL query? That
could be a bug.
> Well actually that is how standby_servers run:
>
> https://www.postgresql.org/docs/11/warm-standby.html
>
> "... while each standby server operates in continuous recovery mode, reading
> the WAL files from the primary."
>
> Is this server a standby?
If you could post a self-contained test case, that would be really
helpful to see if there is an actual bug. You can obfuscate the
schema if need be, as long as the problem can be reproduced that's
fine.
--
Michael
Attachments:
signature.asc (application/pgp-signature, 832B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: michael@paquier.xyz, adrian.klaver@aklaver.com, marcos@f10.com.br
Subject: Re: Server goes to Recovery Mode when run a SQL
In-Reply-To: <20190204010709.GC1881@paquier.xyz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox