Replication slot used in logical decoding of documental database give error: got sequence entry 258 for toast chunk 538757697 instead of seq 0

2021-04-30 Thread silvio brandani
Hi, our setup: Postgres server is running on CentOS release 6.10 (Final) instance. Server Version is PostgreSQL 9.5.9 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-18), 64-bit With the following parameters set: wal_level = 'logical' # replica < logical max_rep

Re: tool to migrate database

2021-04-29 Thread silvio brandani
concepts similar and related to migration/replication are applied with the software tcapture , please give a look at https://www.tcapture.net/ Il giorno gio 29 apr 2021 alle ore 16:34 Bruce Momjian ha scritto: > On Tue, Mar 23, 2021 at 09:49:57AM +0100, Joel Jacobson wrote: > > I recently rea