3642) /usr/pgsql-11/bin/postgres "-D" "/var/lib/pgsql/11/data" 2018年PostgreSQL中国技术大会 -bash-4.1$ cd /var/lib/pgsql/11/data -bash-4.1$ ll total 128 drwx------ 5 postgres postgres 4096 Dec 8 11:16 base postgres 4096 Dec 8 11:16 global drwx------ 2 postgres postgres 4096 Dec 8 11:16 log -bash-4.1$ cd log -bash-4.1$ ll total 4 -rw------- 1 postgres postgres 186 Dec 8 11:16 postgresql- Sat.log -bash-4 11:16:27.035 EST [3642] LOG: database system is ready to accept connections -bash-4.1$ -bash-4.1$ cd /var/lib/pgsql/9.4/data -bash-4.1$ ll total 120 drwx------ 5 postgres postgres 4096 Dec 8 11:22

、常⽤SQL⼤全 ⼤全 1. psql客⼾端常⽤ \h 获取SQL命令的帮助 \? 获取psql命令的帮助 \q 退出 2. ⼀般选项 \c [数据库名]－[⽤⼾名] 连接到新数据库 \cd [⽬录名] 改变当前的⼯作⽬录 \encoding [编码] 显⽰或设置客⼾端编码 \h [名字] SQL命令的语法帮助 \set [名字 ［值］] 设置内部变量 \timing 查询计时开关切换（默认关闭） tgz为例。 3）安装Zeppelin 安装Zeppelin只需如下命令解压⼆进制安装包即可： tar zxvf zeppelin-0.6.2-bin-all.tgz 启动Zeppelin: cd /data/zeppelin-0.6.2-bin-all (Zeppelin的安装⽬录) 接⼊第三⽅ BI ⼯具 Greenplum数据仓库 UDW Copyright © 2012-2021 安装Python3: wget https://www.python.org/ftp/python/3.5.0/Python-3.5.0.tar.xz tar Jxvf Python-3.5.0.tar.xz cd Python-3.5.0 ./configure --prefix=/usr/local/python3 make && make install echo 'export PATH=$PA

​shmall​=​524288 kern​.​maxfiles​=​65535 kern​.​maxfilesperproc​=​65535 net​.​inet​.​tcp​.​msl​=​60 $ cd gpAux/gpdemo $ source $HOME/gpdb.master/greenplum_path.sh $ export PGHOST=`hostname` $ make $ --disable-gpfdist \ --disable-gpfdist --prefix=/home/gpadmin/gpdb.master $ make $ make install $ cd gpAux/gpdemo $ source /home/gpadmin/gpdb.master/greenplum_path.sh $ export PGHOST=`hostname` $ make

3. Prepare to use the ISO as a source disk for installing CentOS. 1. Select Add New Device -> CD/DVD Drive. 2. Select Datastore ISO File from the drop-down menu. 3. Navigate to the correct location Select Guest OS -> Install VMware Tools…. 2. Select Mount. This mounts an ISO file as a virtual CD-ROM. 3. Retrieve the IP address of the adapter connected to the gp-virtual-external port group. binary. $ mkdir -p /mnt/cdrom $ mount /dev/cdrom /mnt/cdrom 7. Extract the installation file. $ cd /tmp $ tar -xzvf /mnt/cdrom/VMwareTools*.tar.gz 8. Umount the ISO. VMware Greenplum 6 Documentation

3. Prepare to use the ISO as a source disk for installing CentOS. 1. Select Add New Device -> CD/DVD Drive. 2. Select Datastore ISO File from the drop-down menu. 3. Navigate to the correct location Select Guest OS -> Install VMware Tools⋯. 2. Select Mount. This mounts an ISO file as a virtual CD-ROM. 3. Retrieve the IP address of the adapter connected to the gp-virtual-external port group. binary. $ mkdir -p /mnt/cdrom $ mount /dev/cdrom /mnt/cdrom 7. Extract the installation file. $ cd /tmp $ tar -xzvf /mnt/cdrom/VMwareTools*.tar.gz 8. Umount the ISO. VMware Tanzu Greenplum 6 Documentation

group. 3. Prepare to use the ISO as a source disk for installing CentOS. 1. Select Add New Device → CD/DVD Drive. 2. Select Datastore ISO File from the drop-down menu. 3. Navigate to the correct location Select Guest OS → Install VMware Tools.... 2. Select Mount. This mounts an ISO file as a virtual CD-ROM. 3. Retrieve the IP address of the adapter connected to the gp-virtual-external port group. 4 binary. $ mkdir -p /mnt/cdrom $ mount /dev/cdrom /mnt/cdrom 7. Extract the installation file. $ cd /tmp VMware Tanzu Greenplum 6 Documentation VMware, Inc. 330 $ tar -xzvf /mnt/cdrom/VMwareTools*

3. Prepare to use the ISO as a source disk for installing CentOS. 1. Select Add New Device -> CD/DVD Drive. 2. Select Datastore ISO File from the drop-down menu. 3. Navigate to the correct location Select Guest OS -> Install VMware Tools⋯. 2. Select Mount. This mounts an ISO file as a virtual CD-ROM. 3. Retrieve the IP address of the adapter connected to the gp-virtual-external port group. binary. $ mkdir -p /mnt/cdrom $ mount /dev/cdrom /mnt/cdrom 7. Extract the installation file. $ cd /tmp $ tar -xzvf /mnt/cdrom/VMwareTools*.tar.gz 8. Umount the ISO. $ umount /mnt/cdrom 9. Install

initialization configuration file (gpinitsystem_config) and host file (hostfile_gpinitsystem). For example: $ cd ~ $ gpinitsystem -c gpconfigs/gpinitsystem_config -h gpconfigs/hostfile_gpinitsystem For a fully have a standby master host, copy your environment file to the standby master as well. For example: $ cd ~ $ scp .bashrc :`pwd` Next Steps After your system is up and running, the next /etc/group Note: We strongly recommend that customers change their passwords after initial setup. cd /etc chown root:root passwd shadow group gshadow chmod 644 passwd group chmod 400 shadow gshadow

initialization configuration file (gpinitsystem_config) and host file (hostfile_gpinitsystem). For example: $ cd ~ Note: You can initialize your Greenplum system with primary segments only and deploy mirrors later have a standby master host, copy your environment file to the standby master as well. For example: $ cd ~ $ scp .bashrc :`pwd` Next Steps After your system is up and running, the next /etc/group Note: We strongly recommend that customers change their passwords after initial setup. cd /etc chown root:root passwd shadow group gshadow chmod 644 passwd group chmod 400 shadow gshadow

initialization configuration file (gpinitsystem_config) and host file (hostfile_gpinitsystem). For example: $ cd ~ $ gpinitsystem -c gpconfigs/gpinitsystem_config -h gpconfigs/hostfile_gpinitsystem For a fully have a standby master host, copy your environment file to the standby master as well. For example: $ cd ~ $ scp .bashrc standby_hostname:`pwd` Next Steps After your system is up and running, the next /etc/group Note: We strongly recommend that customers change their passwords after initial setup. cd /etc chown root:root passwd shadow group gshadow chmod 644 passwd group chmod 400 shadow gshadow