林晓东 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
