templarzq的专栏

greenplum获取表结构

源码编译配置：1、进入依赖库目录，拉取代码并编译：cd gpdir/depends/ ./configuremake2、编译代码：ubuntu: sudo apt-get install libperl-dev libcurl4-openssl-devcentos： yum install gcc gcc-c++ flex bison readline-devel bzip2 zlib zlib-devel make cmake git libzstd libzstd-...

1. patronictl pause2. pg_ctl stop pg3.pg recover （物理恢复）4. 修改 dcs中的sysid： pg_controldata |grep "Database system identifier" ETCDCTL_API=2 etcdctl --endpoints 192.168.2.3:2379 set /"PATRONI_NAMESPACE"/ "PATRONI_SCOPE"/initialize sysid..

pg13不再使用recovery.conf，直接合并到Postgresql.conf里：wal_level = replicaarchive_mode = onarchive_command = 'echo "start archive."'restore_command = 'echo "begin PITR"'recovery_target_time = '2021-10-18 10:02:15' //恢复到指定时间，也可指定其他方式，//包括recovery_targe,reco

忘记密码，修改my.cnf[mysqld] skip-grant-tables=1 重设密码use mysqlUPDATE user SET Password = password ( '123456' ) WHERE User = 'root' ; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123...

discovery.zen.minimum_master_nodes: 1discovery.zen.ping_timeout: 10sthreadpool.bulk.queue_size: 5000threadpool.search.queue_size:1000http.cors.enabled: truehttp.cors.allow-origin: "*"number_of...

show variables like '%max_connections%';set GLOBAL max_connections=2000;

https://docs.oracle.com/database/121/JJDBC/dbchgnf.htm#JJDBC28815

create or replace function date_to_unix_ts( PDate in date ) return number is   l_unix_ts number;begin   l_unix_ts := ( PDate - date '1970-01-01' ) * 60 * 60 * 24;   return l_unix_ts;end;

shift+ctrl+X，打开脚本运行，脚本如下：'******************************************************************************'* File:     pdm2excel.txt'* Title:    pdm export to excel'* Purpose:  To export the tab

C:/Windows/SysWOW64下odbcad32.exe

http://zh.wikipedia.org/wiki/Paxos%E7%AE%97%E6%B3%95

（一）          系统需求Ubuntu 11.10 x64  Gcc 4.6.1Oracle 10g for linux_x86_64Swap分区：>1GB如果不够，执行以下指令：$   dd if=/dev/zero of=/tmp/tmp.swap bs=1M count=100$   swapon  –s$   chmod 600 /tmp/tmp

从官网下载mysql在windows xp上安装完之后用workbench怎么也连不上，报“cannt connet to localhost”之类的10061错误，找了很多文章也是没用，最后还是老外的一篇帖子搞定：   在my.ini的server section下添加：     [mysqld]     ...........     bind-address=0.0.0.