From: rob stone <floriparob@gmail.com>
To: PegoraroF10 <marcos@f10.com.br>
To: pgsql-general@postgresql.org
Subject: Re: Server goes to Recovery Mode when run a SQL
Date: Mon, 04 Feb 2019 16:57:10 +1100
Message-ID: <0689b9bcac79f7f5e76ed69dd4baea012d6a3d33.camel@gmail.com> (raw)
In-Reply-To: <1549211574297-0.post@n3.nabble.com>
References: <1549209182255-0.post@n3.nabble.com>
<37bc715f-12e2-84ac-6492-88d7b6306777@aklaver.com>
<1549211574297-0.post@n3.nabble.com>
Olá Marcos,
> My original query, which worked for some days and then went to
> recovery mode
> was ...
If it was working and then ceased to function, did any of the following
occur:-
1) Postgres version changed?
2) OS version changed?
3) Schema changes affecting the tables/views used in your query?
I assume that you have a development data base. Can you bump up the log
level on that, run the query and see any errors in the log.
Cheers,
Robert
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: floriparob@gmail.com, marcos@f10.com.br
Subject: Re: Server goes to Recovery Mode when run a SQL
In-Reply-To: <0689b9bcac79f7f5e76ed69dd4baea012d6a3d33.camel@gmail.com>
* 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