DB-PostgreSQL9.5-CentOS-6

来源：互联网发布：网络防诈骗的班会编辑：程序博客网时间：2024/05/17 01:18
[root@winkey ~]# rpm -qa|grep postgres[root@winkey ~]# ll /zwf-temptotal 484076drwxr-xr-x 9 root root       4096 Mar 24 09:50 apache-tomcat-7.0.67-rw-r--r-- 1 root root    8886737 Mar 24 00:19 apache-tomcat-7.0.67.tar.gzdrwxrwsr-x 9  100 users      4096 Feb 19  2015 eclipse-rw-r--r-- 1 root root  264956749 Mar 24 00:42 eclipse-jee-luna-SR2-linux-gtk-x86_64.tar.gzdrwxr-xr-x 8 uucp   143      4096 Dec 13 08:50 jdk1.8.0_121-rw-r--r-- 1 root root  183246769 Mar 24 10:52 jdk-8u121-linux-x64.tar.gz-rw-r--r-- 1 root root   37200356 Mar 24 00:27 postgresql-9.5.6-1-linux-x64.rundrwxrwxr-x 6 root root       4096 Jul 17  2015 redis-3.0.3-rw-r--r-- 1 root root    1360959 Mar 24 00:21 redis-3.0.3.tar.gz-rw-r--r-- 1 root root      10460 Mar 24 12:34 spring-instrument-tomcat-4.1.5.RELEASE.jar[root@winkey ~]# chmod +x /zwf-temp/postgresql-9.5.6-1-linux-x64.run[root@winkey ~]# ll /zwf-temptotal 484076drwxr-xr-x 9 root root       4096 Mar 24 09:50 apache-tomcat-7.0.67-rw-r--r-- 1 root root    8886737 Mar 24 00:19 apache-tomcat-7.0.67.tar.gzdrwxrwsr-x 9  100 users      4096 Feb 19  2015 eclipse-rw-r--r-- 1 root root  264956749 Mar 24 00:42 eclipse-jee-luna-SR2-linux-gtk-x86_64.tar.gzdrwxr-xr-x 8 uucp   143      4096 Dec 13 08:50 jdk1.8.0_121-rw-r--r-- 1 root root  183246769 Mar 24 10:52 jdk-8u121-linux-x64.tar.gz-rwxr-xr-x 1 root root   37200356 Mar 24 00:27 postgresql-9.5.6-1-linux-x64.rundrwxrwxr-x 6 root root       4096 Jul 17  2015 redis-3.0.3-rw-r--r-- 1 root root    1360959 Mar 24 00:21 redis-3.0.3.tar.gz-rw-r--r-- 1 root root      10460 Mar 24 12:34 spring-instrument-tomcat-4.1.5.RELEASE.jar[root@winkey ~]# ===图形化直接出来了[root@winkey /]# netstat -ntlpActive Internet connections (only servers)Proto Recv-Q Send-Q Local Address               Foreign Address             State       PID/Program name   tcp        0      0 127.0.0.1:8005              0.0.0.0:*                   LISTEN      2124/java           tcp        0      0 0.0.0.0:8009                0.0.0.0:*                   LISTEN      2124/java           tcp        0      0 0.0.0.0:6380                0.0.0.0:*                   LISTEN      2193/redis-server * tcp        0      0 0.0.0.0:8080                0.0.0.0:*                   LISTEN      2124/java           tcp        0      0 0.0.0.0:22                  0.0.0.0:*                   LISTEN      1943/sshd           tcp        0      0 0.0.0.0:5432                0.0.0.0:*                   LISTEN      5372/postgres       tcp        0      0 127.0.0.1:25                0.0.0.0:*                   LISTEN      2045/master         tcp        0      0 127.0.0.1:6010              0.0.0.0:*                   LISTEN      5423/sshd           tcp        0      0 127.0.0.1:6011              0.0.0.0:*                   LISTEN      2274/sshd[root@winkey /]# ll /zwf/PostgreSQL9.5/bintotal 8984-rwxr-xr-x 1 root daemon   53840 Feb  7 15:06 clusterdb-rwxr-xr-x 1 root daemon   53904 Feb  7 15:06 createdb-rwxr-xr-x 1 root daemon   65920 Feb  7 15:06 createlang-rwxr-xr-x 1 root daemon   58384 Feb  7 15:06 createuser-rwxr-xr-x 1 root daemon   49840 Feb  7 15:06 dropdb-rwxr-xr-x 1 root daemon   65920 Feb  7 15:06 droplang-rwxr-xr-x 1 root daemon   49816 Feb  7 15:06 dropuser-rwxr-xr-x 1 root daemon  833328 Feb  7 15:06 ecpg-rwxr-xr-x 1 root daemon   90928 Feb  7 15:06 initdb-rwxr-xr-x 1 root daemon   23984 Feb  7 15:06 oid2name-rwxr-xr-x 1 root daemon   16360 Feb  7 15:06 pg_archivecleanup-rwxr-xr-x 1 root daemon   65952 Feb  7 15:06 pg_basebackup-rwxr-xr-x 1 root daemon   74808 Feb  7 15:06 pgbench-rwxr-xr-x 1 root daemon   25208 Feb  7 15:06 pg_config-rwxr-xr-x 1 root daemon   33024 Feb  7 15:06 pg_controldata-rwxr-xr-x 1 root daemon   37672 Feb  7 15:06 pg_ctl-rwxr-xr-x 1 root daemon  346960 Feb  7 15:06 pg_dump-rwxr-xr-x 1 root daemon   75096 Feb  7 15:06 pg_dumpall-rwxr-xr-x 1 root daemon   26680 Feb  7 15:06 pg_isready-rwxr-xr-x 1 root daemon   46776 Feb  7 15:06 pg_receivexlog-rwxr-xr-x 1 root daemon   49496 Feb  7 15:06 pg_recvlogical-rwxr-xr-x 1 root daemon   41184 Feb  7 15:06 pg_resetxlog-rwxr-xr-x 1 root daemon  136192 Feb  7 15:06 pg_restore-rwxr-xr-x 1 root daemon   71672 Feb  7 15:06 pg_rewind-rwxr-xr-x 1 root daemon   23904 Feb  7 15:06 pg_standby-rwxr-xr-x 1 root daemon   17656 Feb  7 15:06 pg_test_fsync-rwxr-xr-x 1 root daemon   13256 Feb  7 15:06 pg_test_timing-rwxr-xr-x 1 root daemon   91520 Feb  7 15:06 pg_upgrade-rwxr-xr-x 1 root daemon   62784 Feb  7 15:06 pg_xlogdump-rwxr-xr-x 1 root daemon    2257 Feb  7 14:44 pltcl_delmod-rwxr-xr-x 1 root daemon    2407 Feb  7 14:44 pltcl_listmod-rwxr-xr-x 1 root daemon   11485 Feb  7 14:44 pltcl_loadmod-rwxr-xr-x 1 root daemon 5892736 Feb  7 15:06 postgreslrwxrwxrwx 1 root root         8 Mar 24 17:01 postmaster -> postgres-rwxr-xr-x 1 root daemon     763 Feb  7 14:45 psql-rwxr-xr-x 1 root daemon  453512 Feb  7 15:06 psql.bin-rwxr-xr-x 1 root daemon   55536 Feb  7 15:06 reindexdb-rwxr-xr-x 1 root daemon   59408 Feb  7 15:06 vacuumdb-rwxr-xr-x 1 root daemon   22296 Feb  7 15:06 vacuumlo[root@winkey /]# /zwf/PostgreSQL9.5/bin/psql.binPassword: psql.bin: FATAL:  password authentication failed for user "root"[root@winkey /]# su - postgres-bash-4.1$ /zwf/PostgreSQL9.5/bin/psql.binPassword: psql.bin (9.5.6)Type "help" for help.postgres=# helpYou are using psql, the command-line interface to PostgreSQL.Type:  \copyright for distribution terms       \h for help with SQL commands       \? for help with psql commands       \g or terminate with semicolon to execute query       \q to quitpostgres=#  postgres=# CREATE SEQUENCE sys_user_contact_way_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;CREATE SEQUENCE
翻开厚厚的文档~ 找答案就好了~ 为什么要求人家要记住呢~
这不是好比你要人家匹配上：加法交换律 a + b = b + a 嚒。
我们其实只要记住后面公式就好了。
阅读全文
0 0