what's the error meaning? on mast/slavery replication .

林晓东 wrote:

hi,all
I got this when setup two replication server:

致命错误: 在主用服务器和备用服务器之间，数据库系统标识符是不一样的。
详细信息: 主用服务器的标识符是6551342231479624101，备用服务器的标识符是6551367700460643417。
---fatal erro: in main and backup server ,the database 's system id is not same...
what's mean of this ,how to deal with ?

You need to start the standby with a physical backup of the database,
e.g. using pg_basebackup.
You cannot restore a database dump taken with pg_dump to start
streaming replication, because that is a logical backup (there is
no guarantee that the same data are in the same block of the same file).

Yours,
Laurenz Albe

--
+43-670-6056265
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26, A-2700 Wiener Neustadt
Web: https://www.cybertec-postgresql.com