自动化测试环境SigmationTF中PostgreSQL的使用指导.docxVIP

自动化测试环境SigmationTF中PostgreSQL的使用指导访问postgres数据库为保证可以访问postgres数据库，必需要设置root的权限（Allow root to run any commands anywhere） [root@MC /var/log]#cd /etc [root@MC /etc]#chmod 666 sudoers[root@MC /etc]#vim sudoerssupport ALL=(ALL) NOPASSWD:ALLadmin ALL=(ALL) NOPASSWD:/sbin/ifconfig, /sbin/reboot, /sbin/poweroff, /usr/sbin/network_config_save, \ /usr/sbin/update_ip, /sbin/ethtool, /bin/hostname, /sbin/route, /opt/sigma-rt/tf/tools/reloadtfadmin ALL=(ALL) /usr/sbin/update_image, /usr/sbin/install_lic, /usr/sbin/vmware-install.sh, /usr/sbin/vmware-uninstall.shapache ALL=(ALL) NOPASSWD:/usr/bin/crontab, /usr/sbin/ldap_config##必需添加如下配置，否则，无法访问root ALL=(ALL) ALL使用命令sudo -u postgrespsql访问postgres数据库。sudo -u postgrespsqlpostgres=# \l List of databases Name | Owner | Encoding -----------+----------+----------postgres |postgres | UTF8sat | postgres | UTF8 template0 | postgres | UTF8 template1 | postgres | UTF8(4 rows)连接sigmation TF的后台数据库sat。postgres=# \c sat;You are now connected to database sat.列出sat的所有的表。sat=# \dt List of relations Schema | Name | Type | Owner --------+-------------------------+-------+-------public | saddress | table | satpublic | sbtsparams | table | satpublic | sbugtrack | table | satpublic | scheckpoint | table | satpublic | sconn_2002_8t_cpos | table | satpublic | sconn_2002_e1_p4_ge | table | satpublic | sconn_backup_tf_file | table | satpublic | sconn_fr1002 | table | satpublic | sconn_fr1002_allge | table | satpublic | sconn_nrose | table | satpublic | sconn_s5700 | table | satpublic | sconn_testbedname | table | satpublic | sconn_tsr | table | satpublic | sconn_zebos | table | satpublic | scontrollibrary | table | satpublic | sdevice_2002_8t_cpos | table | satpublic | sdevice_2002_e1_p4_ge | table | satpubli