WARNING: database my_db has a collation version mismatch
DETAIL: The database was created using collation version 2.17, but the operating system provides version 2.34.
HINT:
Rebuild all objects in this database that use the default collation
and run ALTER DATABASE my_db REFRESH COLLATION VERSION, or build
PostgreSQL with the right library version.
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?
Thanks in advance,
Ekaterina