[root@pgserver ~]# ps -ef |grep postg
postgres 1074 1 0 Mar22 ? 00:00:08 /usr/local/pgsql/bin/postgres
postgres 1076 1074 0 Mar22 ? 00:00:00 postgres: checkpointer process
postgres 1077 1074 0 Mar22 ? 00:00:10 postgres: writer process
postgres 1078 1074 0 Mar22 ? 00:00:10 postgres: wal writer process
postgres 1079 1074 0 Mar22 ? 00:00:14 postgres: autovacuum launcher process
postgres 1080 1074 0 Mar22 ? 00:00:19 postgres: stats collector process
postgres 1081 1074 0 Mar22 ? 00:00:00 postgres: bgworker: logical replication launcher
root 25924 25899 0 18:11 pts/2 00:00:00 grep --color=auto postg
pg102 27582 1 0 Mar25 ? 00:00:01 /usr/local/pg102/bin/postgres
pg102 27584 27582 0 Mar25 ? 00:00:00 postgres: checkpointer process
pg102 27585 27582 0 Mar25 ? 00:00:04 postgres: writer process
pg102 27586 27582 0 Mar25 ? 00:00:04 postgres: wal writer process
pg102 27587 27582 0 Mar25 ? 00:00:03 postgres: autovacuum launcher process
pg102 27588 27582 0 Mar25 ? 00:00:04 postgres: stats collector process
pg102 27589 27582 0 Mar25 ? 00:00:00 postgres: bgworker: logical replication launcher
[root@pgserver ~]# su - pg102
Last login: Wed Mar 21 02:38:36 EDT 2018 on pts/1
[pg102@pgserver ~]$ psql
psql: FATAL: role "pg102" does not exist
[pg102@pgserver ~]$ history
1 exit
2 /usr/local/pg102/bin/initdb -D /usr/local/pg102/data
3 wzir
4 exit
5 ls -rlt
6 vi .bash_profile
7 exit
8 pg_ctl start
9 exit
10 vi .bash_profile
11 exit
12 pg_ctl start
13 pg_ctl stop
14 cd $PGDATA
15 ls -lrt
16 cd postgresql.conf
17 vi postgresql.conf
18 pg_ctl start
19 ps -ef |grep postg
20 pwd
21 make install USE_PGXS=1
22 exit
23 which pg_config
24 pg_config --pgxs
25 man pg_config
26 exit
27 make install USE_PGXS=1
28 cd
29 cd /root/
30 exit
31 cd /tmp/pg_query_state-PG10
32 ls -lrt
33 make install USE_PGXS=1
34 cd /usr/local/pgsql
35 ls -lrt
36 cd include
37 ls -lrt
38 pg_ctl stop
39 pwd
40 cd ..
41 ls -lrt
42 exit
43 ll
44 tar -xvf postgresql-10.2.tar
45 exit
46 ll
47 unzip pg_query_state-PG10.zip
48 cd postgresql-10.2
49 ls -lrt
50 cd /home/
51 ls -lrt
52 cd pg102
53 ls -lrt
54 cd postgresql-10.2
55 git apply /home/pg102/pg_query_state-PG10/*.zip
56 git apply /home/pg102/pg_query_state-PG10/*.patch
57 ./configure --prefix=/usr/local/pg102
58 make
59 su
60 make install USE_PGXS=1
61 ls -lrt /usr/local/pg102/lib/postgresql/pgxs/src/makefiles/pgxs.mk
62 ls -lrt /usr/local/pg102/lib/postgresql/pgxs/src/makefiles/../../src/Makefile.global
63 cd /usr/local/pg102/lib/postgresql/pgxs/src/makefiles/
64 pwd
65 ls -lrt
66 cd ..
67 ls -lrt
68 cd ..
69 ls -lrt
70 cd ..
71 ls -lrt
72 pwd
73 cd pgxs
74 ls -lrt
75 cd src
76 ls -lrt
77 cd makefiles/
78 ls -lrt
79 cd ..
80 ls -lrt
81 cd ..
82 pwd
83 ls -lrt
84 cd ..
85 ls -lrt
86 pwd
87 cd ..
88 ls -lrt
89 pwed
90 pwd
91 find . -name Makefile.global
92 find . -name Makefile
93 find . -name "Makefile"
94 find . -name Makefile
95 ls -lrt
96 make install
97 make install
98 pwd
99 ls -lrt
100 cd postgresql-10.2
101 ls -lrt
102 make install
103 cd ..
104 ls -lrt
105 cd pg_query_state-PG10
106 ls -lrt
107 make install USE_PGXS=1
108 cd /usr/local/pg102/data
109 mkdir /usr/local/pg102/data
110 chown pg102 /usr/local/pg102/data
111 /usr/local/pg102/bin/initdb -D /usr/local/pg102/data
112 pg_ctl start
113 pg_ctl stop
114 cd $PGDATA
115 ls -lrt
116 vi postgresql.conf
117 pg_ctl start
118 pwd
119 ps -ef |grep postg
120 cd
121 ll
122 cd $PGDATA
123 vi postgresql.conf
124 pg_ctl restart
125 psql
126 psql --help
127 psql -p 5532
128 psql -p 553
129 psql -p 5532
130 pwd
131 psql -h 192.168.80.148 -p 5532
132 cat /etc/hosts
133 exit
134 psql --help
135 psql -h 192.168.80.148 -p 5532 -U postgres
136 pg_ctl status
137 ifconfig |more
138 psql -h 192.168.80.148 -p 5532 -U postgres
139 pg_ctl status
140 cd $PGDATA
141 ls -lrt
142 more postmaster.pid
143 pg_ctl stop
144 pg_ctl start
145 psql -h 127.0.0.1 -p 5532 -U postgres
146 psql -h 127.0.0.1 -p 5532
147 psql -h 127.0.0.1 -p 5532 -U postgres
148 psql -h 127.0.0.1 -p 5532 -U pg102
149 pslq --help
150 psql --help
151 psql -v
152 psql -B
153 psql -V
154 ls -lrt
155 cd base
156 ls -lrt
157 cd 1
158 ls -lrt
159 cd ..
160 ls -lrt
161 cd 13211
162 ls -lrt
163 cd ..
164 ls -lrt
165 cd ..
166 ls -lrt
167 cd global/
168 ls -lrt
169 more pg_control
170 cd ..
171 ls -lrt
172 pwd
173 psql
174 psql -h 127.0.0.1 -p 5532
175 psql -h 127.0.0.1 -p 5532 -U root
176 psql -h 127.0.0.1 -p 5532 -U postgres
177 psql -h 127.0.0.1 -p 5532 -U pg102
178 psql -h 127.0.0.1 -p 5532
179 su - podtgres
180 su - postgres
181 exit
182 env |grep PG
183 psql -p 5532 -U pg102 -d postgres
184 psql -p 5532 -U pg102 -d postgres
185 ls -lrt
186 cd pg_query_state-PG10
187 ls -lrt
188 cd tests
189 ls -lrt
190 python
191 ps -ef |grep local
192 psql -p 5532 -U pg102 -d postgres
193 psql
194 history
195 psql -p 5532 -U pg102 -d postgres
196 env |grep PGDATA
197 pg_ctl start
198 psql -p 5532 -U pg102 -d postgres
199 psql -p 5532 -d postgres
200 psql -d postgres
201 psql -p 5532 -d postgres
202 psql --help
203 history
204 psql --help
205 ll
206 cd postgresql-10.2
207 ls
208 ./configure --help
209 psql
210 history
[pg102@pgserver ~]$ psql -p 5532
psql: FATAL: database "pg102" does not exist
[pg102@pgserver ~]$ psql -p 5532 -U pg102
psql: FATAL: database "pg102" does not exist
[pg102@pgserver ~]$ psql -p 5532 -U pg102 -d postgres
psql (10.2)
Type "help" for help.
postgres=#
psql登录时的一点故事
最新推荐文章于 2022-11-14 16:22:51 发布