Postgresql crashdown and recovery failure

2021-06-10 Thread xiebin (F)
Hi, My database (Postgresql 12.5) server uses remote storage as data directory. I powered off the database server and started postgresql (same version) on another server, with same data. However it failed. I checked wal logs and found that the content around latest checkpoint is empty. (about 1

Postgresql crashdown and recovery failure

2021-06-10 Thread xiebin (F)
Hi, My database (Postgresql 12.5) server uses remote storage as data directory. I powered off the database server and started postgresql (same version) on another server, with same data. However it failed. I checked wal logs and found that the content around latest checkpoint is empty. (about 1

答复: Security issues concerning pgsql replication

2020-10-27 Thread xiebin (F)
-authentication.html Xie Bin 发件人: Magnus Hagander [mailto:mag...@hagander.net] 发送时间: 2020年10月27日 17:00 收件人: xiebin (F) 抄送: pgsql-gene...@postgresql.org; zhubo (C) ; Zhuzheng (IT) ; houxiaowei ; yangshaobo (A) ; mapinghu ; Songyunpeng ; luoqi (F) 主题: Re: Security issues concerning pgsql

Security issues concerning pgsql replication

2020-10-27 Thread xiebin (F)
Hi, I was setting up a master/slave pgsql(version 12.4) cluster using stream replication. I found 3 ways to authenticate, but all of them has some security issue. 1. Disable authentication. cat pg_hba.conf host all all0/0 md5 host replication xie