Message-ID: <3062c3953f78637800eec4339bf4f4eff877f32b.camel@gmail.com>
Subject: Re: Server goes to Recovery Mode when run a SQL
From: rob stone <floriparob@gmail.com>
To: PegoraroF10 <marcos@f10.com.br>, pgsql-general@postgresql.org
Date: Tue, 05 Feb 2019 09:05:41 +1100
In-Reply-To: <1549294429092-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>
	 <0689b9bcac79f7f5e76ed69dd4baea012d6a3d33.camel@gmail.com>
	 <1549278827534-0.post@n3.nabble.com>
	 <7719c8bd-2e98-8a67-d01d-3b111e8d669c@aklaver.com>
	 <1549294429092-0.post@n3.nabble.com>
Content-Type: text/plain; charset="UTF-8"
User-Agent: Evolution 3.30.4-1 
Mime-Version: 1.0
Content-Transfer-Encoding: 8bit
Precedence: bulk

Olá Marcos,

On Mon, 2019-02-04 at 08:33 -0700, PegoraroF10 wrote:
> About replication ... Logical Replication with CREATE
> PUBLICATION/SUBSCRIPTION.
> 
> Yes, some DDL commands were ran on that server but none of them were
> related
> with that select.
> Let me explain better. We have a single server with a single database
> on it.
> Each customer has its own schema and connects to it to work
> exclusively on
> that schema. So, sometimes we add some customer or change something
> on an
> old one. But this DDL change we could ran is not related with that
> schema we
> are talking. Schemas can have different structures but that schema
> which
> puts my server on recovery mode was not changed.
> 
> Maybe something related happened some days ago. When we start a new
> customer
> we add a schema, put all their tables on it and it´s ok. Our server
> has
> today 90 schemas and each schema has 100 tables, resulting in 9000
> tables.
> Some days ago we added 5 new customers on same day, so we added 500
> tables.
> Then, when we did that some selects on system tables were very very
> slow and
> that was only solved when we did a REINDEX DATABASE. Even REINDEX
> SYSTEM did
> not solve. Is this problem related with recovery mode of my server ?
> 
> 

I trust that you saved the output from your "create" scripts. I would
find those five log files and see if any errors occurred.

Also, you would have to run them on the "subscriber" server first. So,
if you "diff'd" the log files for "escola-53" (or whatever) from the
publication and the subscriber servers, they should be similar in all
respects? I don't know the answer to that question.

Chapter 31.4 in the doco is interesting reading.

Cheers,
Robert