PG备份与恢复介绍: pg_dump、pg_dumpall、pg_restore、pg_basebackup、pg_rman
PG备份逻辑备份和物理备份:
逻辑备份工具
pg_dump、pg_dumpall
物理备份工具
pg_basebackup、pg_rman(第三方备份工具)
一、pg逻辑备份与恢复12345678910111213141516postgres=#...
Oracle12c/19c克隆PDB
一、从PDB$SEED克隆1234567891011121314151617181920212223242526272829303132333435363738394041SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED-----...
一、安装pip1.pip介绍pip类似RedHat里面的yum，安装Python包非常方便
2.pip下载1# wget "https://pypi.python.org/packages/source/p/pip/pip-1.5.4.tar.gz#md5=834b2904f92d46aaa333267fb1c922bb" --no-check-certificate
...
Oracle select as of 闪回恢复数据
123select * from test_zby as of timestamp (systimestamp - interval '20' minute);select * from test_zby as of timestamp sysdate - 20/1440;
一、Linux rman备份脚本1.练气期版123456789101112131415161718192021222324252627run{ CONFIGURE CONTROLFILE AUTOBACKUP OFF; crosscheck archivelog all; crosscheck backup; crossche...
Centos安装Mysql5.6
一、准备工作1.删除系统存在的Mysql123456789101112131415If you have previously installed MySQL using your operating system nativepackage management system, such as Yum or APT, you may experienc...
一、下载1.二进制包下载
https://yum.postgresql.org/rpmchart/
1https://www.postgresql.org/download/
2.源码安装包下载
https://www.postgresql.org/ftp/source/
123https://www.postgresql.org/download/The source code ...
Mysql配置SSL安全连接
一、SSL简介SSL（Secure Socket Layer：安全套接字层）利用数据加密、身份验证和消息完整性验证机制，为基于TCP等可靠连接的应用层协议提供安全性保证。
SSL协议提供的功能主要有：
数据传输的机密性：利用对称密钥算法对传输的数据进行加密。
身份验证机制：基于证书利用数字签名方法对服务器和客户端进行身份验证，其中客户端的身份验证是可选的。...
统计Oracle数据库进程和会话数
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293...
Oracle批量清理数据脚本，利用游标自动化删除数据JOB
1234567891011121314151617181920212223242526272829303132333435create sequence seq_id minvalue 1maxvalue 99999999999999999999start with 1increment by 1cache 20; begi...
