Ekaterina Amez Gonzalez <registrosekaterina@xxxxxxxxx> writes: > I tried what was suggested: reindexing and running "refresh collation" > alter after that and everything seems to work ok so this looks like an easy > wat to migrate from one server to another. Plus I feel more comfortable > using streaming replication than logical replication, and also I find it > more useful when you need to replicate the whole cluster. > So my question is: is there anything I'm missing here, some kind of problem > that could hit my face after moving to the new server? That will almost certainly blow up in your face. Physical replication assumes that the source and replica databases are to be kept bitwise identical. What you've described is already not bitwise identical because (a) the collation versions recorded for the indexes are different and (b) reindexing would have rebuilt the indexes, so that there's no reason to expect that all the index entries are in the same physical spots as before. Moreover, the entire point of all this worry about collation versions is that (c) the logical ordering of the indexes might now be different. So enabling physical replication at this point would surely make a mess of the replica's indexes. You'll have to use logical replication for this. regards, tom lane
