Thread: 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