https://blog.youkuaiyun.com/snakeeyszh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/snakeeys/article/details/142959035https://blog.youkuaiyun.com/snakeeys/article/details/142959035snakeeysTue, 15 Oct 2024 17:06:45 +0800https://blog.youkuaiyun.com/snakeeys/article/details/141643792https://blog.youkuaiyun.com/snakeeys/article/details/141643792snakeeysWed, 28 Aug 2024 16:34:08 +0800https://blog.youkuaiyun.com/snakeeys/article/details/141297162https://blog.youkuaiyun.com/snakeeys/article/details/141297162snakeeysSun, 18 Aug 2024 11:13:53 +0800select pg_is_in_recovery() 显示F表示是主库，T表示从。shell>select pg_is_in_recovery() 显示F表示是主库，T表示从。在文件末尾增加一行，增加replica的用户，来进行数据库同步操作。配置pg_hba.conf文件，配置文件在安装设置的data目录下。Shell>pg_ctl stop -D "目录" -m fast。shell>pg_ctl start -D "数据目录"在业务表添加或修改数据，在从库上查看数据是否正确。]]>https://blog.youkuaiyun.com/snakeeys/article/details/141297126https://blog.youkuaiyun.com/snakeeys/article/details/141297126snakeeysSun, 18 Aug 2024 11:11:24 +0800https://blog.youkuaiyun.com/snakeeys/article/details/141296971https://blog.youkuaiyun.com/snakeeys/article/details/141296971snakeeysSun, 18 Aug 2024 11:01:32 +0800https://blog.youkuaiyun.com/snakeeys/article/details/141296912https://blog.youkuaiyun.com/snakeeys/article/details/141296912snakeeysSun, 18 Aug 2024 10:58:29 +0800创建控制文件。]]>https://blog.youkuaiyun.com/snakeeys/article/details/141296900https://blog.youkuaiyun.com/snakeeys/article/details/141296900snakeeysSun, 18 Aug 2024 10:57:28 +0800https://blog.youkuaiyun.com/snakeeys/article/details/141296890https://blog.youkuaiyun.com/snakeeys/article/details/141296890snakeeysSun, 18 Aug 2024 10:56:48 +0800https://blog.youkuaiyun.com/snakeeys/article/details/141296850https://blog.youkuaiyun.com/snakeeys/article/details/141296850snakeeysSun, 18 Aug 2024 10:54:35 +0800https://blog.youkuaiyun.com/snakeeys/article/details/141296745https://blog.youkuaiyun.com/snakeeys/article/details/141296745snakeeysSun, 18 Aug 2024 10:48:44 +0800https://blog.youkuaiyun.com/snakeeys/article/details/141296724https://blog.youkuaiyun.com/snakeeys/article/details/141296724snakeeysSun, 18 Aug 2024 10:47:09 +0800https://blog.youkuaiyun.com/snakeeys/article/details/141296712https://blog.youkuaiyun.com/snakeeys/article/details/141296712snakeeysSun, 18 Aug 2024 10:46:10 +0800https://blog.youkuaiyun.com/snakeeys/article/details/139435526https://blog.youkuaiyun.com/snakeeys/article/details/139435526snakeeysTue, 04 Jun 2024 10:42:34 +0800alter database backup controlfile to trace as '/home/oracle/con.trace';sql>shutdown imme]]>