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