Re: Server goes to Recovery Mode when run a SQL

From: rob stone <floriparob(at)gmail(dot)com>
To: PegoraroF10 <marcos(at)f10(dot)com(dot)br>, pgsql-general(at)postgresql(dot)org
Subject: Re: Server goes to Recovery Mode when run a SQL
Date: 2019-02-04 05:57:10
Message-ID: 0689b9bcac79f7f5e76ed69dd4baea012d6a3d33.camel@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vijaykumar Jain 2019-02-04 07:14:14 FDW, too long to run explain
Previous Message Syed Jafri 2019-02-04 05:34:57 JSONB Array of Strings (with GIN index) versus Split Rows (B-Tree Index)