level 1
但若清水
楼主
从主库备份完成后,修改完配置文件,启动从库一直是这个状态无法启动流复制,有没有大佬遇到过同样的问题,求支持。谢谢
[root@PG1 ~]# systemctl status postgresql-11
● postgresql-11.service - PostgreSQL 11 database server
Loaded: loaded (/usr/lib/systemd/system/postgresql-11.service; enabled; vendor preset: disabled)
Active: active (running) since Mon 2020-09-14 10:36:58 CST; 1 day 6h ago
Docs: https://www.postgresql.org/docs/11/static/
Process: 175604 ExecStartPre=/usr/pgsql-11/bin/postgresql-11-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
Main PID: 175611 (postmaster)
CGroup: /system.slice/postgresql-11.service
├─175611 /usr/pgsql-11/bin/postmaster -D /data/postgresql
├─175612 postgres: 11/main: logger
├─175613 postgres: 11/main: startup recovering 00000001000007830000008F
├─175617 postgres: 11/main: checkpointer
├─175618 postgres: 11/main: background writer
└─175621 postgres: 11/main: stats collector
Sep 14 10:36:58 pg1 postmaster[175611]: 2020-09-14 10:36:58.266 CST [175611] LOG: 00000: ...432
Sep 14 10:36:58 pg1 postmaster[175611]: 2020-09-14 10:36:58.266 CST [175611] LOCATION: St...593
Sep 14 10:36:58 pg1 postmaster[175611]: 2020-09-14 10:36:58.266 CST [175611] LOG: 00000: ...432
Sep 14 10:36:58 pg1 postmaster[175611]: 2020-09-14 10:36:58.266 CST [175611] LOCATION: St...593
Sep 14 10:36:58 pg1 postmaster[175611]: 2020-09-14 10:36:58.266 CST [175611] LOG: 00000: ...32"
Sep 14 10:36:58 pg1 postmaster[175611]: 2020-09-14 10:36:58.266 CST [175611] LOCATION: St...587
Sep 14 10:36:58 pg1 postmaster[175611]: 2020-09-14 10:36:58.877 CST [175611] LOG: 00000: ...ess
Sep 14 10:36:58 pg1 postmaster[175611]: 2020-09-14 10:36:58.877 CST [175611] HINT: Future...s".
Sep 14 10:36:58 pg1 postmaster[175611]: 2020-09-14 10:36:58.877 CST [175611] LOCATION: Sy...668
Sep 14 10:36:58 pg1 systemd[1]: Started PostgreSQL 11 database server.
Hint: Some lines were ellipsized, use -l to show in full.
[root@pg1 ~]#
2020年09月15日 08点09分
1
[root@PG1 ~]# systemctl status postgresql-11
● postgresql-11.service - PostgreSQL 11 database server
Loaded: loaded (/usr/lib/systemd/system/postgresql-11.service; enabled; vendor preset: disabled)
Active: active (running) since Mon 2020-09-14 10:36:58 CST; 1 day 6h ago
Docs: https://www.postgresql.org/docs/11/static/
Process: 175604 ExecStartPre=/usr/pgsql-11/bin/postgresql-11-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
Main PID: 175611 (postmaster)
CGroup: /system.slice/postgresql-11.service
├─175611 /usr/pgsql-11/bin/postmaster -D /data/postgresql
├─175612 postgres: 11/main: logger
├─175613 postgres: 11/main: startup recovering 00000001000007830000008F
├─175617 postgres: 11/main: checkpointer
├─175618 postgres: 11/main: background writer
└─175621 postgres: 11/main: stats collector
Sep 14 10:36:58 pg1 postmaster[175611]: 2020-09-14 10:36:58.266 CST [175611] LOG: 00000: ...432
Sep 14 10:36:58 pg1 postmaster[175611]: 2020-09-14 10:36:58.266 CST [175611] LOCATION: St...593
Sep 14 10:36:58 pg1 postmaster[175611]: 2020-09-14 10:36:58.266 CST [175611] LOG: 00000: ...432
Sep 14 10:36:58 pg1 postmaster[175611]: 2020-09-14 10:36:58.266 CST [175611] LOCATION: St...593
Sep 14 10:36:58 pg1 postmaster[175611]: 2020-09-14 10:36:58.266 CST [175611] LOG: 00000: ...32"
Sep 14 10:36:58 pg1 postmaster[175611]: 2020-09-14 10:36:58.266 CST [175611] LOCATION: St...587
Sep 14 10:36:58 pg1 postmaster[175611]: 2020-09-14 10:36:58.877 CST [175611] LOG: 00000: ...ess
Sep 14 10:36:58 pg1 postmaster[175611]: 2020-09-14 10:36:58.877 CST [175611] HINT: Future...s".
Sep 14 10:36:58 pg1 postmaster[175611]: 2020-09-14 10:36:58.877 CST [175611] LOCATION: Sy...668
Sep 14 10:36:58 pg1 systemd[1]: Started PostgreSQL 11 database server.
Hint: Some lines were ellipsized, use -l to show in full.
[root@pg1 ~]#