Re: postgresql version 13 repo question

2021-07-04 Thread Yi Sun
Yi Sun 于2021年6月30日周三 下午2:33写道: > Hello, > > As our env os version is different, some is centos 7.4, some is 7.5 and > 7.6 ..., and there is only one company repo, as I compare the packages size > and date, seems same, If we can just use 7.6 packages please? > >

Re: Doubt on pgbouncer

2021-07-04 Thread Rama Krishnan
Thank you for the clarification. On Sat, 3 Jul, 2021, 23:20 Ben Chobot, wrote: > Rama Krishnan wrote on 7/3/21 8:35 AM: > > > Hi Team, > > How can I split read and write queries using pgbouncer > > > You do it with your application. Make a pgbouncer database for read/write > queries and point

Re: Damaged (during upgrade?) table, how to repair?

2021-07-04 Thread Adrian Klaver
On 7/4/21 12:29 PM, W.P. wrote: >> So you have backup of the failed machine's disk stored somewhere else? To be clear the 1TB disk is working where and with what OS? 1TB DISC is connected to OrangePi4 (as I have copied disc "sector by sector" from 500GB to 1TB, some months ago, I can't

Re: Damaged (during upgrade?) table, how to repair?

2021-07-04 Thread W.P.
W dniu 04.07.2021 o 21:10, Adrian Klaver pisze: On 7/4/21 11:59 AM, W.P. wrote: W dniu 04.07.2021 o 19:48, Adrian Klaver pisze: On 7/4/21 9:33 AM, W.P. wrote: W dniu 02.07.2021 o 21:05, Adrian Klaver pisze: On 7/2/21 10:18 AM, W.P. wrote: W dniu 02.07.2021 o 17:16, Adrian Klaver pisze:

Re: Damaged (during upgrade?) table, how to repair?

2021-07-04 Thread W.P.
>> So you have backup of the failed machine's disk stored somewhere else? No, I have disc from this machine, looks not damaged (random files). Only problem that OS does not boot beyond "emergency mode". I would say your second sentence contradicts your first. Nope ;). There was 1 500GB

Re: Damaged (during upgrade?) table, how to repair?

2021-07-04 Thread Adrian Klaver
On 7/4/21 11:59 AM, W.P. wrote: W dniu 04.07.2021 o 19:48, Adrian Klaver pisze: On 7/4/21 9:33 AM, W.P. wrote: W dniu 02.07.2021 o 21:05, Adrian Klaver pisze: On 7/2/21 10:18 AM, W.P. wrote: W dniu 02.07.2021 o 17:16, Adrian Klaver pisze: So you have backup of the failed machine's disk

Re: Damaged (during upgrade?) table, how to repair?

2021-07-04 Thread W.P.
W dniu 04.07.2021 o 19:48, Adrian Klaver pisze: On 7/4/21 9:33 AM, W.P. wrote: W dniu 02.07.2021 o 21:05, Adrian Klaver pisze: On 7/2/21 10:18 AM, W.P. wrote: W dniu 02.07.2021 o 17:16, Adrian Klaver pisze: So you have backup of the failed machine's disk stored somewhere else? No, I

Re: Damaged (during upgrade?) table, how to repair?

2021-07-04 Thread Adrian Klaver
On 7/4/21 9:33 AM, W.P. wrote: W dniu 02.07.2021 o 21:05, Adrian Klaver pisze: On 7/2/21 10:18 AM, W.P. wrote: W dniu 02.07.2021 o 17:16, Adrian Klaver pisze: So you have backup of the failed machine's disk stored somewhere else? No, I have disc from this machine, looks not damaged

Re: Damaged (during upgrade?) table, how to repair?

2021-07-04 Thread Adrian Klaver
On 7/4/21 9:33 AM, W.P. wrote: W dniu 02.07.2021 o 21:05, Adrian Klaver pisze: On 7/2/21 10:18 AM, W.P. wrote: W dniu 02.07.2021 o 17:16, Adrian Klaver pisze: So you have backup of the failed machine's disk stored somewhere else? No, I have disc from this machine, looks not damaged

Re: Damaged (during upgrade?) table, how to repair?

2021-07-04 Thread W.P.
W dniu 02.07.2021 o 21:05, Adrian Klaver pisze: On 7/2/21 10:18 AM, W.P. wrote: W dniu 02.07.2021 o 17:16, Adrian Klaver pisze: So you have backup of the failed machine's disk stored somewhere else? No, I have disc from this machine, looks not damaged (random files). Only problem that

Re: Logical Replication - Single Destination Table With Multiple Source Tables - How to Handle Structure Changes

2021-07-04 Thread Vijaykumar Jain
On Sun, 4 Jul 2021 at 15:53, Avi Weinberg wrote: > I'm using logical replication to copy data from multiple tables to a > single destination table. At times the structure of the source table needs > to change. However, not all source table will have their structure updated > at the same time.

Logical Replication - Single Destination Table With Multiple Source Tables - How to Handle Structure Changes

2021-07-04 Thread Avi Weinberg
I'm using logical replication to copy data from multiple tables to a single destination table. At times the structure of the source table needs to change. However, not all source table will have their structure updated at the same time. Let's assume, for example, a column type needs to be