API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 11th, 2016
95
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 90.36 KB | None | 0 0
raw download clone embed print report
  1. login asroot
  2. root@46.61.225.44's password:
  3. Last login: Mon Jan 11 18:23:16 2016 from 172.16.40.27
  4. [root@rmis66-web ~]# ssh iadmin@192.168.2.114
  5. iadmin@192.168.2.114's password:
  6. Permission denied, please try again.
  7. iadmin@192.168.2.114's password:
  8.  
  9. [root@rmis66-web ~]# ssh root@192.168.2.114
  10. root@192.168.2.114's password:
  11. Permission denied, please try again.
  12. root@192.168.2.114's password:
  13. Permission denied, please try again.
  14. root@192.168.2.114's password:
  15.  
  16. [root@rmis66-web ~]# ssh iadmin@192.168.2.114
  17. iadmin@192.168.2.114's password:
  18. Last login: Mon Jan 11 18:23:32 2016 from 192.168.2.110
  19. iadmin@rmis66-db1:~sudo-i
  20. -bash: sudo-i: command not found
  21. iadmin@rmis66-db1:~sudo -i
  22. [root@rmis66-db1 ~]# history
  23. 1 2016-01-11 18:32:31 kill -9 25254
  24. 2 2015-11-27 13:21:24 ps auxwww | grep postgres
  25. 3 2015-11-27 13:20:57 /etc/init.d/postgresql-9.4 stop
  26. 4 2015-11-27 13:21:31 /etc/init.d/postgresql-9.4 start
  27. 5 2015-11-27 13:21:37 ps afx
  28. 6 2015-11-27 13:27:41 ps -efL | grep postgres
  29. 7 2015-11-27 13:27:43 ps -efL | grep postgres -c
  30. 8 2015-11-27 13:28:02 ls
  31. 9 2015-11-27 14:00:18 ps -afxu|grep postg|wc -l
  32. 10 2015-11-27 14:02:33 cd /etc/pgbouncer/
  33. 11 2015-11-27 14:02:33 ll
  34. 12 2015-11-27 13:58:37 yum install pgbouncer
  35. 13 2015-11-27 14:04:00 cd /etc/pgbouncer/
  36. 14 2015-11-27 14:04:08 vi ./pgbouncer.ini
  37. 15 2015-11-27 14:06:08 vi ./userlist.txt
  38. 16 2015-11-27 14:07:29 /etc/init.d/pgbouncer start
  39. 17 2015-11-27 14:07:41 mkdir -p /var/log/postgresql/
  40. 18 2015-11-27 14:07:43 /etc/init.d/pgbouncer start
  41. 19 2015-11-27 14:07:51 /etc/init.d/pgbouncer star
  42. 20 2015-11-27 14:07:53 mkdir -p /var/log/postgresql
  43. 21 2015-11-27 14:07:58 chmod 777 /var/log/postgresql/
  44. 22 2015-11-27 14:08:02 chmod 777 /var/log/postgresql
  45. 23 2015-11-27 14:08:07 /etc/init.d/pgbouncer star
  46. 24 2015-11-27 14:08:08 /etc/init.d/pgbouncer start
  47. 25 2015-11-27 14:08:48 ip a
  48. 26 2015-11-27 14:08:55 netstat -nlpt
  49. 27 2015-11-27 14:09:46 mkdir -p /var/run/postgresql
  50. 28 2015-11-27 14:09:49 chmod 777 /var/run/postgresql
  51. 29 2015-11-27 14:09:55 /etc/init.d/pgbouncer restart
  52. 30 2015-11-27 14:02:35 mc
  53. 31 2015-11-27 14:12:16 tail -f /var/log/postgresql/pgbouncer.log
  54. 32 2015-11-30 13:06:42 ps -afx
  55. 33 2015-11-30 13:06:50 mc
  56. 34 2015-11-30 13:07:36 export PGPASSWORD="pgbouncer"
  57. 35 2015-11-30 13:07:50 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer -c 'show pools;'
  58. 36 2015-11-30 13:08:36 /etc/init.d/pgbouncer reload
  59. 37 2015-11-30 13:08:38 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer -c 'show pools;'
  60. 38 2015-11-30 13:08:47 /etc/init.d/pgbouncer restart
  61. 39 2015-11-30 13:08:49 ps -afx
  62. 40 2015-11-30 13:08:55 kill -9 862
  63. 41 2015-11-30 13:08:57 /etc/init.d/pgbouncer restart
  64. 42 2015-11-30 13:09:02 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer -c 'show pools;'
  65. 43 2015-11-30 13:09:09 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer -c 'show pools;'
  66. 44 2015-11-30 13:09:10 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer -c 'show pools;'
  67. 45 2015-11-30 13:09:10 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer -c 'show pools;'
  68. 46 2015-11-30 13:09:11 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer -c 'show pools;'
  69. 47 2015-11-30 13:09:12 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer -c 'show pools;'
  70. 48 2015-11-30 13:09:12 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer -c 'show pools;'
  71. 49 2015-11-30 13:09:12 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer -c 'show pools;'
  72. 50 2015-11-30 13:09:12 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer -c 'show pools;'
  73. 51 2015-11-30 13:09:12 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer -c 'show pools;'
  74. 52 2015-11-30 13:25:46 puppet agent -t
  75. 53 2015-11-30 13:38:53 puppet agent -t
  76. 54 2015-11-30 13:44:29 /etc/init.d/zabbix-agentd.sh restart
  77. 55 2015-11-30 14:27:55 zabbix_agentd -c /etc/zabbix/zabbix_agentd.conf -t pg bouncer.maxwait[lsd_кьшы66]
  78. 56 2015-11-30 14:27:59 zabbix_agentd -c /etc/zabbix/zabbix_agentd.conf -t pg bouncer.maxwait[lsd_rmis66]
  79. 57 2015-11-30 14:28:01 zabbix_agentd -c /etc/zabbix/zabbix_agentd.conf -t pg bouncer.maxwait[lsd_rmis66]
  80. 58 2015-11-30 14:28:37 /etc/zabbix/scripts/pgbouncer_cl_wait.sh lsd_rmis66
  81. 59 2015-11-30 14:28:41 bash -x /etc/zabbix/scripts/pgbouncer_cl_wait.sh lsd_ rmis66
  82. 60 2015-11-30 14:28:53 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer - c 'show pools;' -t
  83. 61 2015-11-30 14:29:13 vi /etc/zabbix/scripts/pgbouncer_cl_wait.sh lsd_rmis6 6
  84. 62 2015-11-30 14:29:51 bash -x /etc/zabbix/scripts/pgbouncer_cl_wait.sh lsd_ rmis66
  85. 63 2015-11-30 14:30:20 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer - c 'show pools;' -t| grep 'lsd_rmis66.+| lsd'
  86. 64 2015-11-30 14:30:25 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer - c 'show pools;' -t| grep 'lsd_rmis66'
  87. 65 2015-11-30 13:07:54 mc
  88. 66 2015-11-30 14:58:47 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer - c 'show pools;' -t| grep 'lsd_rmis66'
  89. 67 2015-11-30 14:59:01 export PGPASSWORD="pgbouncer"
  90. 68 2015-11-30 14:59:20 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer - c 'show pools;' -t| grep 'lsd_rmis66'
  91. 69 2015-11-30 14:59:56 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer - c 'show pools;' -t| grep 'lsd_rmis66| lsd '
  92. 70 2015-11-30 15:00:02 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer - c 'show pools;' -t| grep 'lsd.+| lsd '
  93. 71 2015-11-30 15:00:16 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer - c 'show pools;' -t| grep 'lsd\s+| lsd '
  94. 72 2015-11-30 15:00:35 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer - c 'show pools;' -t| grep 'lsd.+| lsd '
  95. 73 2015-11-30 15:00:47 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer - c 'show pools;' -t| grep 'lsd.+| lsd'
  96. 74 2015-11-30 15:00:56 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer - c 'show pools;' -t| egrep 'lsd.+\| lsd'
  97. 75 2015-11-30 15:01:02 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer - c 'show pools;' -t| grep 'lsd.+\| lsd'
  98. 76 2015-11-30 15:01:08 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer - c 'show pools;' -t| egrep 'lsd.+\| lsd'
  99. 77 2015-11-30 15:01:16 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer - c 'show pools;' -t| egrep 'lsd.+\ | lsd'
  100. 78 2015-11-30 15:01:29 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer - c 'show pools;' -t| egrep 'lsd.+\| lsd'
  101. 79 2015-11-30 15:01:38 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer - c 'show pools;' -t| egrep 'lsd.+ \| lsd'
  102. 80 2015-11-30 15:02:01 psql -p 6432 -h 127.0.0.1 -U pgbouncer -d pgbouncer - c 'show pools;' -t| egrep 'lsd.+\| lsd'
  103. 81 2015-11-30 15:03:19 puppet agent -t
  104. 82 2015-11-30 15:04:46 bash -x /etc/zabbix/scripts/pgbouncer_cl_wait.sh lsd_ rmis66
  105. 83 2015-11-30 15:17:17 /etc/init.d/pgbouncer status
  106. 84 2015-11-30 15:17:20 /etc/init.d/pgbouncer restart
  107. 85 2015-11-30 15:17:23 ps -afx
  108. 86 2015-11-30 15:17:29 kill -9 14860
  109. 87 2015-11-30 15:17:31 /etc/init.d/pgbouncer restart
  110. 88 2015-11-30 15:16:14 mc
  111. 89 2015-11-30 16:13:34 puppet agent -t
  112. 90 2015-11-30 16:17:51 ps afx
  113. 91 2015-11-30 16:18:02 ps -ef | grep postgres -c
  114. 92 2015-11-30 16:18:06 ps afx
  115. 93 2015-11-30 16:18:24 htop
  116. 94 2015-11-30 16:19:33 ps -ef | grep postgres -c
  117. 95 2015-11-30 16:26:57 ьс
  118. 96 2015-11-30 16:35:41 dmesg | tail
  119. 97 2015-11-30 16:35:46 dmesg | less
  120. 98 2015-11-30 16:36:18 ps auxwww | grep 29031
  121. 99 2015-11-30 16:16:33 psql -U postgres -h 127.1
  122. 100 2015-11-30 18:19:41 ps afx
  123. 101 2015-11-30 18:19:52 crontab -l
  124. 102 2015-11-30 18:20:28 /usr/bin/pgrep -f 'postgres: autovacuum'
  125. 103 2015-11-30 18:21:35 htop
  126. 104 2015-11-30 18:12:34 htop
  127. 105 2015-11-30 18:32:30 mc
  128. 106 2015-11-30 16:26:58 mc
  129. 107 2015-12-01 14:06:45 less /var/log/postgres/postgresql-2015-12-01.log
  130. 108 2015-12-01 11:35:23 ps -afx
  131. 109 2015-12-01 11:35:29 /etc/init.d/pgbouncer restart
  132. 110 2015-12-01 11:35:35 kill -9 20975
  133. 111 2015-12-01 11:35:36 /etc/init.d/pgbouncer restart
  134. 112 2015-12-01 14:06:07 less /var/log/postgres/postgresql-2015-12-01.log
  135. 113 2015-12-02 14:33:58 iotop
  136. 114 2015-12-02 14:35:07 iostat -mx 5
  137. 115 2015-12-09 18:58:34 fgrep 'msr.id as accession_number' /var/log/postgres/ postgresql-2015-12-09.log
  138. 116 2015-12-09 18:58:42 less /var/log/postgres/postgresql-2015-12-09.log
  139. 117 2015-12-09 19:00:47 fgrep 'db=lsd_rmis66,appname=[unknown],user=pcs' /var /log/postgres/postgresql-2015-12-09.log
  140. 118 2015-12-10 13:03:11 cat /etc/pgbouncer/pgbouncer.ini
  141. 119 2015-12-11 13:42:48 ip a
  142. 120 2015-12-11 14:23:52 ps -fC java
  143. 121 2015-12-11 14:18:56 mc
  144. 122 2015-12-13 20:22:22 /etc/init.d/postgresql-9.4 restart
  145. 123 2015-12-13 20:22:40 /etc/init.d/postgresql-9.4 rstop
  146. 124 2015-12-13 20:22:44 /etc/init.d/postgresql-9.4 stop
  147. 125 2015-12-13 20:23:10 ps -afx
  148. 126 2015-12-13 20:23:26 /etc/init.d/postgresql-9.4 start
  149. 127 2015-12-13 20:23:41 su - postgres
  150. 128 2015-12-13 22:10:53 /etc/init.d/postgresql-9.4 stop
  151. 129 2015-12-13 22:11:01 ps -afx
  152. 130 2015-12-13 22:11:04 /etc/init.d/postgresql-9.4 start
  153. 131 2015-12-13 22:11:11 su - postgres
  154. 132 2015-12-13 20:23:36 screen
  155. 133 2015-12-14 02:03:22 ps -fe |grep vacuum
  156. 134 2015-12-14 02:38:15 ыскуут -ды
  157. 135 2015-12-14 02:38:18 screen -ls
  158. 136 2015-12-13 22:13:48 su - postgres
  159. 137 2015-12-14 02:52:21 ps -afx
  160. 138 2015-12-14 02:52:35 /etc/init.d/postgresql-9.4 stop
  161. 139 2015-12-14 02:53:43 ps -afx
  162. 140 2015-12-14 02:53:50 /etc/init.d/postgresql-9.4 stop
  163. 141 2015-12-14 02:55:02 ps -afx
  164. 142 2015-12-14 02:55:12 mc
  165. 143 2015-12-14 02:55:23 ps -afx
  166. 144 2015-12-14 02:57:48 kill -9 31388
  167. 145 2015-12-14 02:57:50 ps -afx
  168. 146 2015-12-14 02:58:06 /etc/init.d/postgresql-9.4 start
  169. 147 2015-12-14 02:38:28 screen -rD 32617.pts-0.rmis66-db1
  170. 148 2015-12-14 09:45:59 mc
  171. 149 2015-12-14 09:46:39 ps -afx
  172. 150 2015-12-14 09:46:44 ps -afx|grep pgb
  173. 151 2015-12-14 09:46:59 /etc/init.d/pgbouncer restart
  174. 152 2015-12-14 09:47:06 kill -9 6737
  175. 153 2015-12-14 09:47:08 kill -9 6737
  176. 154 2015-12-14 09:47:10 /etc/init.d/pgbouncer restart
  177. 155 2015-12-17 18:11:33 mc
  178. 156 2015-12-18 12:14:05 mc
  179. 157 2015-12-21 12:27:02 скщт
  180. 158 2015-12-21 12:27:19 crontab -l
  181. 159 2015-12-21 12:27:25 /usr/local/bin/pgbadger.sh
  182. 160 2015-12-21 12:46:55 cd /var/lib/pgsql/9.4/
  183. 161 2015-12-21 12:46:57 ls
  184. 162 2015-12-21 12:47:08 cd /var/lib/pgsql/9.4/data/
  185. 163 2015-12-21 12:47:09 ls
  186. 164 2015-12-21 14:47:00 ps -ef | grep postgres
  187. 165 2015-12-21 14:47:06 exit
  188. 166 2015-12-21 14:45:54 mc
  189. 167 2015-12-21 14:47:19 SELECT
  190. 168 2015-12-21 14:47:19 msr.id as accession_number,
  191. 169 2015-12-21 14:47:19 (select pic.code from pim_indiv_c ode pic where pic.indiv_id = pi.id and type_id = (select id from pim_code_type w here code = 'UID') limit 1) as patient_id,
  192. 170 2015-12-21 14:47:19 trim(pi.SURNAME)||' '||substr(pi. NAME,1,1 )||'.'||substr(pi.patr_name,1,1)||'.' as patient_name,
  193. 171 2015-12-21 14:47:19 pi.birth_dt as patient_bth_date,
  194. 172 2015-12-21 14:47:19 (case coalesce(pi.gender_id, -1) when 1 then 'M' when 2 then 'F' else 'O' end) as patient_sex,
  195. 173 2015-12-21 14:47:19 null as patient_size,
  196. 174 2015-12-21 14:47:19 null as patient_weight,
  197. 175 2015-12-21 14:47:19 -- null as study_uid,
  198. 176 2015-12-21 14:47:20 (select coalesce(surname||' ','')| |coalesce(name||' ','')||coalesce(patr_name,'')
  199. 177 2015-12-21 14:47:20 from pim_individual i, pim_emplo yee e, pim_employee_position ep, pim_employee_position_resource epr, sr_srv_res_ involved sri
  200. 178 2015-12-21 14:47:20 where i.id = e.individual_id
  201. 179 2015-12-21 14:47:20 and ep.employee_id = e.id
  202. 180 2015-12-21 14:47:20 and epr.employee_position_id = ep.id
  203. 181 2015-12-21 14:47:20 and epr.id = sri.resource_id
  204. 182 2015-12-21 14:47:20 and sri.service_id = ssr.id
  205. 183 2015-12-21 14:47:20 limit 1
  206. 184 2015-12-21 14:47:20 ) as req_physician,
  207. 185 2015-12-21 14:47:20 ss.name as req_proc_description,
  208. 186 2015-12-21 14:47:20 pem.code as modality,
  209. 187 2015-12-21 14:47:20 peu.modality_aet as scheduled_ae_ title,
  210. 188 2015-12-21 14:47:20 "date"(ssr.planned_date) as start _date,
  211. 189 2015-12-21 14:47:20 "time"(ssr.planned_time) as start _time
  212. 190 2015-12-21 14:47:20 FROM
  213. 191 2015-12-21 14:47:20 md_srv_rendered msr,
  214. 192 2015-12-21 14:47:20 sr_srv_rendered ssr
  215. 193 2015-12-21 14:47:20 left outer join sr_res_group srg on ( ssr.res_group_id = srg.id),
  216. 194 2015-12-21 14:47:20 pci_patient pp,
  217. 195 2015-12-21 14:47:20 pim_individual pi,
  218. 196 2015-12-21 14:47:20 sr_service ss,
  219. 197 2015-12-21 14:47:20 sr_res_group_relationship srgr,
  220. 198 2015-12-21 14:47:20 pim_equipment_unit_resource peur,
  221. 199 2015-12-21 14:47:20 pim_equipment_unit peu,
  222. 200 2015-12-21 14:47:20 pim_equipment_modality pem
  223. 201 2015-12-21 14:47:20 where
  224. 202 2015-12-21 14:47:23 and ssr.customer_id = pi.id
  225. 203 2015-12-21 14:47:23 and pp.id = pi.id
  226. 204 2015-12-21 14:47:23 and ss.id = ssr.service_id
  227. 205 2015-12-21 14:47:23 and srgr.group_id = srg.id
  228. 206 2015-12-21 14:47:23 and peur.id = srgr.resource_id
  229. 207 2015-12-21 14:47:23 and peu.id = peur.equipment_unit_id
  230. 208 2015-12-21 14:47:23 and pem.id = peu.modality_dicom_i d
  231. 209 2015-12-21 14:47:23 -- ----
  232. 210 2015-12-21 14:47:23 and peu.modality_aet like ?
  233. 211 2015-12-21 14:47:23 and ssr.planned_date between ? an d ?
  234. 212 2015-12-21 14:48:25 chkconfig --list
  235. 213 2015-12-21 14:49:24 cd /etc/init.d/postgresql-9.4
  236. 214 2015-12-21 14:49:49 ps ef | grep postgresql-9.4
  237. 215 2015-12-21 14:55:14 find / -name 'pg_log'
  238. 216 2015-12-21 14:56:48 cd SELECT
  239. 217 2015-12-21 14:56:48 msr.id as accession_number,
  240. 218 2015-12-21 14:56:48 (select pic.code from pim_indiv_c ode pic where pic.indiv_id = pi.id and type_id = (select id from pim_code_type w here code = 'UID') limit 1) as patient_id,
  241. 219 2015-12-21 14:56:48 trim(pi.SURNAME)||' '||substr(pi. NAME,1,1 )||'.'||substr(pi.patr_name,1,1)||'.' as patient_name,
  242. 220 2015-12-21 14:56:48 pi.birth_dt as patient_bth_date,
  243. 221 2015-12-21 14:56:48 (case coalesce(pi.gender_id, -1) when 1 then 'M' when 2 then 'F' else 'O' end) as patient_sex,
  244. 222 2015-12-21 14:56:48 null as patient_size,
  245. 223 2015-12-21 14:56:48 null as patient_weight,
  246. 224 2015-12-21 14:56:48 -- null as study_uid,
  247. 225 2015-12-21 14:56:49 (select coalesce(surname||' ','')| |coalesce(name||' ','')||coalesce(patr_name,'')
  248. 226 2015-12-21 14:56:49 from pim_individual i, pim_emplo yee e, pim_employee_position ep, pim_employee_position_resource epr, sr_srv_res_ involved sri
  249. 227 2015-12-21 14:56:49 where i.id = e.individual_id
  250. 228 2015-12-21 14:56:49 and ep.employee_id = e.id
  251. 229 2015-12-21 14:56:49 and epr.employee_position_id = ep.id
  252. 230 2015-12-21 14:56:49 and epr.id = sri.resource_id
  253. 231 2015-12-21 14:56:49 and sri.service_id = ssr.id
  254. 232 2015-12-21 14:56:49 limit 1
  255. 233 2015-12-21 14:56:49 ) as req_physician,
  256. 234 2015-12-21 14:56:49 ss.name as req_proc_description,
  257. 235 2015-12-21 14:56:49 pem.code as modality,
  258. 236 2015-12-21 14:56:49 peu.modality_aet as scheduled_ae_ title,
  259. 237 2015-12-21 14:56:49 "date"(ssr.planned_date) as start _date,
  260. 238 2015-12-21 14:56:49 "time"(ssr.planned_time) as start _time
  261. 239 2015-12-21 14:56:49 FROM
  262. 240 2015-12-21 14:56:49 md_srv_rendered msr,
  263. 241 2015-12-21 14:56:49 sr_srv_rendered ssr
  264. 242 2015-12-21 14:56:49 left outer join sr_res_group srg on ( ssr.res_group_id = srg.id),
  265. 243 2015-12-21 14:56:49 pci_patient pp,
  266. 244 2015-12-21 14:56:49 pim_individual pi,
  267. 245 2015-12-21 14:56:49 sr_service ss,
  268. 246 2015-12-21 14:56:49 sr_res_group_relationship srgr,
  269. 247 2015-12-21 14:56:49 pim_equipment_unit_resource peur,
  270. 248 2015-12-21 14:56:49 pim_equipment_unit peu,
  271. 249 2015-12-21 14:56:49 pim_equipment_modality pem
  272. 250 2015-12-21 14:56:49 where
  273. 251 2015-12-21 14:57:40 cd /pg_data/9.4/data/pg_log
  274. 252 2015-12-21 14:57:45 ls
  275. 253 2015-12-21 14:59:46 tail -500 postgresql-Mon.log
  276. 254 2015-12-21 15:00:14 tail -500 postgresql-Tue.log
  277. 255 2015-12-21 15:01:12 ls
  278. 256 2015-12-21 15:01:48 fgrep ^log ../postgresql.conf
  279. 257 2015-12-21 15:01:52 fgrep log ../postgresql.conf
  280. 258 2015-12-21 15:02:03 grep ^log ../postgresql.conf
  281. 259 2015-12-21 15:02:31 cd /var/log/postgres
  282. 260 2015-12-21 15:02:33 ls
  283. 261 2015-12-21 15:03:09 exit
  284. 262 2015-12-21 15:02:53 mc
  285. 263 2015-12-21 15:03:26 tail -5000 postgresql-2015-12-21.log
  286. 264 2015-12-21 15:04:53 tail -5000 postgresql-2015-12-21.log | grep msr.id as accession_number
  287. 265 2015-12-21 15:05:11 tail -5000 postgresql-2015-12-21.log | grep msr.id
  288. 266 2015-12-21 15:05:26 less postgresql-2015-12-21.log
  289. 267 2015-12-22 02:49:36 vi ./dumps.conf
  290. 268 2015-12-22 02:49:50 nginx -t
  291. 269 2015-12-22 02:49:55 /etc/init.d/nginx reload
  292. 270 2015-12-22 02:48:53 mc
  293. 271 2015-12-22 02:53:36 cd /etc/nginx/conf.d/
  294. 272 2015-12-22 02:53:37 ll
  295. 273 2015-12-22 02:53:39 cat ./dumps.conf
  296. 274 2015-12-22 10:46:45 зы -у
  297. 275 2015-12-22 10:46:46 ps -afx
  298. 276 2015-12-22 10:46:55 /etc/init.d/postgresql-9.4 stop
  299. 277 2015-12-22 10:47:15 ps -afx
  300. 278 2015-12-22 10:47:19 /etc/init.d/postgresql-9.4 start
  301. 279 2015-12-22 14:34:18 ps afx
  302. 280 2015-12-22 14:34:33 curl -D- 127.1/pgbadger
  303. 281 2015-12-22 14:34:35 curl -D- 127.1/pgbadger/
  304. 282 2015-12-22 14:34:38 c /var/www/html/
  305. 283 2015-12-22 14:34:38 ls
  306. 284 2015-12-22 14:34:48 cd /var/www/html/
  307. 285 2015-12-22 14:34:49 ls
  308. 286 2015-12-22 14:35:02 less /etc/nginx/conf.d/dumps.conf
  309. 287 2015-12-22 14:35:27 who
  310. 288 2015-12-22 14:35:29 last
  311. 289 2015-12-22 14:35:36 stat last
  312. 290 2015-12-22 14:35:54 statls
  313. 291 2015-12-22 14:35:56 ls /etc/nginx/
  314. 292 2015-12-22 14:36:05 curl -D 127.1/dumps/
  315. 293 2015-12-22 14:36:10 curl -D- 127.1/dumps/
  316. 294 2015-12-22 14:36:41 stat /etc/nginx/conf.d/dumps.conf
  317. 295 2015-12-22 14:38:23 ls
  318. 296 2015-12-22 14:38:32 vi /etc/nginx/conf.d/dumps.conf
  319. 297 2015-12-22 14:39:09 nginx -t
  320. 298 2015-12-22 14:39:11 nginx -s reload
  321. 299 2015-12-22 14:39:18 curl -D- 127.1/pgbadger/
  322. 300 2015-12-22 14:39:22 vi /etc/nginx/conf.d/dumps.conf
  323. 301 2015-12-22 14:42:52 nginx -t
  324. 302 2015-12-22 14:42:54 nginx -s reload
  325. 303 2015-12-22 15:29:13 df -h
  326. 304 2015-12-23 13:02:44 htop
  327. 305 2015-12-23 21:54:37 ps afx
  328. 306 2015-12-23 21:55:18 cd /var/lib/pgsql/9.4/
  329. 307 2015-12-23 21:55:18 ls
  330. 308 2015-12-23 21:55:20 cd data/
  331. 309 2015-12-23 21:55:21 ls
  332. 310 2015-12-23 21:55:33 ps afx | grep '\-D'
  333. 311 2015-12-23 22:00:44 fgrep archive postgresql.conf
  334. 312 2015-12-23 22:00:59 vi postgresql.conf
  335. 313 2015-12-23 22:02:26 df -h
  336. 314 2015-12-23 22:02:45 ls
  337. 315 2015-12-23 22:02:49 du -cxhs *
  338. 316 2015-12-23 22:02:58 ls pg_xlog/
  339. 317 2015-12-23 22:03:13 echo $((16*2000))
  340. 318 2015-12-23 22:03:17 df -h
  341. 319 2015-12-23 22:03:32 /etc/init.d/postgresql-9.4 reload
  342. 320 2015-12-23 22:03:43 less /var/log/postgres/postgresql-2015-12-23.log
  343. 321 2015-12-23 22:06:25 ls /dumps/
  344. 322 2015-12-23 22:06:30 ls /dumps/daily/
  345. 323 2015-12-23 22:06:31 ls /dumps/daily/12/
  346. 324 2015-12-23 22:06:33 ls /dumps/daily/12/23/
  347. 325 2015-12-23 22:06:36 ls /dumps/daily/12/23/ -lh
  348. 326 2015-12-23 22:06:50 crontab -l
  349. 327 2015-12-23 22:06:59 vi /etc/crontab
  350. 328 2015-12-23 22:07:21 vi /etc/cron.d/postgres_backup
  351. 329 2015-12-23 22:07:33 date
  352. 330 2015-12-23 22:07:41 cat /etc/cron.d/postgres_backup
  353. 331 2015-12-23 22:08:15 touch /var/lib/pgsql/9.4/data/recovery.conf
  354. 332 2015-12-23 22:08:18 ps afx
  355. 333 2015-12-14 02:55:31 mc
  356. 334 2015-12-23 22:08:34 df -h
  357. 335 2015-12-23 22:08:46 vacuumdb --help
  358. 336 2015-12-23 22:10:33 ss -natlp | grep 432
  359. 337 2015-12-23 22:10:46 psql -U postgres -h 127.1 -l
  360. 338 2015-12-23 22:11:00 vacuumdb --help
  361. 339 2015-12-23 23:55:44 зы -фач
  362. 340 2015-12-23 23:55:54 ps -afx|grep vacum
  363. 341 2015-12-23 23:55:59 su - postgres
  364. 342 2015-12-23 22:08:28 screen -r
  365. 343 2015-12-24 00:30:45 ps afx
  366. 344 2015-12-24 00:31:06 df -h
  367. 345 2015-12-24 00:31:18 du -cxhs pg_xlog/
  368. 346 2015-12-24 01:01:09 df -h
  369. 347 2015-12-24 01:02:13 screen -r
  370. 348 2015-12-24 01:02:36 cat > term_all.sql
  371. 349 2015-12-24 01:02:55 while true; do psql -U postgres -h 127.1 -f term_all. sql ; sleep 60; done
  372. 350 2015-12-24 01:04:08 man psql
  373. 351 2015-12-24 01:05:05 while true; do psql -U postgres -h 127.1 -f term_all. sql -o term_all.out ; sleep 60; done
  374. 352 2015-12-24 01:06:01 while true; do psql -U postgres -h 127.1 -f term_all. sql -o term_all.out ; sleep 60; date; done
  375. 353 2015-12-24 01:10:08 date +%h
  376. 354 2015-12-24 01:10:12 date +%H
  377. 355 2015-12-24 01:10:15 man date
  378. 356 2015-12-24 01:10:48 date +%k
  379. 357 2015-12-24 01:10:59 date +%H
  380. 358 2015-12-24 01:11:29 [[ $(date +%H) -ge 7 ]]
  381. 359 2015-12-24 01:11:35 [[ $(date +%H) -ge 7 ]] && echo lol
  382. 360 2015-12-24 01:11:40 [[ $(date +%H) -le 7 ]] && echo lol
  383. 361 2015-12-24 01:11:43 man test
  384. 362 2015-12-24 01:12:10 [[ $(date +%H) -le 7 ]] && echo lol
  385. 363 2015-12-24 01:02:18 screen
  386. 364 2015-12-24 01:13:04 [[ 07 -le 7 ]] && lol
  387. 365 2015-12-24 01:13:08 [[ 07 -le 7 ]] && echo lol
  388. 366 2015-12-24 01:13:12 [[ 08 -le 7 ]] && echo lol
  389. 367 2015-12-24 01:13:26 [[ 09 -le 7 ]] && echo lol
  390. 368 2015-12-24 01:13:31 [[ 06 -le 7 ]] && echo lol
  391. 369 2015-12-24 01:13:47 [[ 8 -le 7 ]] && echo lol
  392. 370 2015-12-24 01:13:54 screen -r
  393. 371 2015-12-24 01:14:02 screen -r 32617.pts-0.rmis66-db1
  394. 372 2015-12-24 01:12:39 while [[ $(date +%H) -le 7 ]]; do psql -U postgres -h 127.1 -f term_all.sql -o term_all.out ; sleep 60; date; done
  395. 373 2015-12-24 01:14:34 man date
  396. 374 2015-12-24 01:15:09 date --date="noon"
  397. 375 2015-12-24 01:15:23 date --date="afternoon"
  398. 376 2015-12-24 01:15:30 date --date="midnigth"
  399. 377 2015-12-24 01:15:34 date --date="midnight"
  400. 378 2015-12-24 01:15:54 date --date="3 hours"
  401. 379 2015-12-24 01:15:59 date --date="7 hours"
  402. 380 2015-12-24 01:16:08 date --date="7 hours" +%H
  403. 381 2015-12-24 01:16:26 [[ $(date --date="7 hours" +%H) -le 7 ]] && echo lol
  404. 382 2015-12-24 01:16:34 [[ $(date --date="7 hours" +%k) -le 7 ]] && echo lol
  405. 383 2015-12-24 01:16:41 [[ $(date --date="6 hours" +%k) -le 7 ]] && echo lol
  406. 384 2015-12-24 01:17:03 while [[ $(date +%k) -le 7 ]]; do psql -U postgres -h 127.1 -f term_all.sql -o term_all.out ; sleep 60; date; done
  407. 385 2015-12-23 23:56:08 screen
  408. 386 2015-12-24 01:14:17 screen -r 11696.pts-3.rmis66-db1
  409. 387 2015-12-23 22:11:50 vacuumdb -d lsd_rmis66 -f -z -h 127.1 -U postgres
  410. 388 2015-12-24 01:18:28 while [[ $(date +%k) -le 5 ]]; do psql -U postgres -h 127.1 -f term_all.sql -o term_all.out ; sleep 60; date; done
  411. 389 2015-12-24 06:43:02 ps afx
  412. 390 2015-12-24 06:43:07 screen -r
  413. 391 2015-12-24 06:43:17 date
  414. 392 2015-12-24 06:43:14 screen -r 11696.pts-3.rmis66-db1
  415. 393 2015-12-24 06:43:29 df -h
  416. 394 2015-12-24 06:43:41 screen -r 29077.pts-0.rmis66-db1
  417. 395 2015-12-24 06:44:13 screen -r
  418. 396 2015-12-24 18:07:01 cat /etc/pgbouncer/pgbouncer.ini|grep -v ^#
  419. 397 2015-12-24 18:07:11 cat /etc/pgbouncer/pgbouncer.ini|grep -v ^#|grep -v " ^;"
  420. 398 2015-12-24 18:08:52 cat /etc/pgbouncer/userlist.txt
  421. 399 2015-12-25 01:48:51 cat /var/lib/pgsql/9.4/data/recovery.conf
  422. 400 2015-12-25 01:48:53 rm /var/lib/pgsql/9.4/data/recovery.conf
  423. 401 2015-12-25 01:48:57 ps afx
  424. 402 2015-12-25 01:49:23 /etc/init.d/crond status
  425. 403 2015-12-25 01:56:35 rm /var/lib/pgsql/9.4/data/recovery.conf
  426. 404 2015-12-28 01:21:17 top
  427. 405 2015-12-28 01:21:32 uptime
  428. 406 2015-12-28 09:54:55 top
  429. 407 2015-12-28 10:32:28 /etc/init.d/pgbouncer restart
  430. 408 2015-12-28 10:32:33 ps -afx|grep pgbo
  431. 409 2015-12-28 10:32:38 kill -9 3179
  432. 410 2015-12-28 10:32:40 /etc/init.d/pgbouncer restart
  433. 411 2015-12-28 10:36:05 perf top
  434. 412 2015-12-28 10:36:23 cat /etc/*release
  435. 413 2015-12-28 10:36:30 /etc/init.d/postgresql-9.4 stop
  436. 414 2015-12-28 10:36:41 ps -afx
  437. 415 2015-12-28 10:36:44 /etc/init.d/postgresql-9.4 start
  438. 416 2015-12-28 10:36:54 ps -afx
  439. 417 2015-12-28 10:31:44 mc
  440. 418 2015-12-29 09:36:20 ps -afx
  441. 419 2015-12-29 09:36:33 ps -afx|grep postgrs
  442. 420 2015-12-29 09:36:37 ps -afx|grep postgres
  443. 421 2015-12-29 09:36:41 ps -afx|grep postgres|wc -l
  444. 422 2015-12-29 09:37:03 ps -afx|grep postgres|grep 127.0.0.1
  445. 423 2015-12-29 09:37:07 ps -afx|grep postgres|grep 127.0.0.1|wc-l
  446. 424 2015-12-29 09:37:09 ps -afx|grep postgres|grep 127.0.0.1|wc -l
  447. 425 2015-12-29 09:37:15 ps -afx|grep postgres
  448. 426 2015-12-29 09:37:28 ps -afx|grep postgres|grep -v "127.0.0.1"
  449. 427 2015-12-29 09:37:31 ps -afx|grep postgres|grep -v "127.0.0.1"|wc -l
  450. 428 2015-12-29 09:38:05 ps -afx|grep postgres|grep -v "127.0.0.1"
  451. 429 2015-12-29 12:43:20 mc
  452. 430 2015-12-29 12:43:50 /etc/init.d/pgbouncer restart
  453. 431 2015-12-29 12:43:55 ps -afx|grep pgbou
  454. 432 2015-12-29 12:44:00 kill -9 20090
  455. 433 2015-12-29 12:44:02 /etc/init.d/pgbouncer restart
  456. 434 2015-12-29 12:49:28 psql -h 192.168.2.150 -d pacsdb
  457. 435 2015-12-29 12:51:42 ps -afx|grep pgbou
  458. 436 2015-12-29 12:51:49 kill -9 8434
  459. 437 2015-12-29 12:51:52 /etc/init.d/pgbouncer restart
  460. 438 2015-12-29 12:55:53 crontab -e
  461. 439 2015-12-29 12:56:01 date
  462. 440 2015-12-29 12:56:08 uptime
  463. 441 2015-12-29 12:56:19 /etc/init.d/crond restart
  464. 442 2015-12-29 12:56:31 yum install at
  465. 443 2015-12-29 12:57:03 /etc/init.d/atd start
  466. 444 2015-12-29 12:57:07 chkconfig atd on
  467. 445 2015-12-29 12:57:17 date
  468. 446 2015-12-29 12:58:12 crontab -e
  469. 447 2015-12-29 12:58:41 tail -f /tmp/select.now
  470. 448 2015-12-29 12:58:42 tail -f /tmp/select.now
  471. 449 2015-12-29 12:58:43 tail -f /tmp/select.now
  472. 450 2015-12-29 12:58:46 date
  473. 451 2015-12-29 12:58:49 date
  474. 452 2015-12-29 12:58:50 date
  475. 453 2015-12-29 12:58:51 date
  476. 454 2015-12-29 12:58:52 date
  477. 455 2015-12-29 12:59:01 date ;tail -f /tmp/select.now
  478. 456 2015-12-29 12:59:05 date ;tail -f /tmp/select.now
  479. 457 2015-12-29 13:17:57 скщте
  480. 458 2015-12-29 13:17:59 crontab -;l
  481. 459 2015-12-29 13:18:03 crontab -l
  482. 460 2015-12-29 13:18:09 cat /usr/local/bin/pgbadger.sh
  483. 461 2015-12-29 13:18:19 date +%Y-%m-%d
  484. 462 2015-12-29 13:18:19 d=$(date +%Y-%m-%d)
  485. 463 2015-12-29 13:18:19 dt=`date +'%Y''-''%m''-''%d'-''%H'-''%M'`
  486. 464 2015-12-29 13:18:31 date +%Y-%m-%d
  487. 465 2015-12-29 13:19:05 /usr/local/bin/pgbadger --exclude-appname pg_dump -j 2 -f stderr -b "2015-12-28 00:00:00" /var/log/postgres/postgresql-2015-12-28.lo g -o /var/www/html/pgbadger/$dt.html
  488. 466 2015-12-29 14:43:48 su - postgres
  489. 467 2015-12-29 12:47:53 mc
  490. 468 2015-12-29 14:44:24 ps -afx|grep pgbouncer
  491. 469 2015-12-29 14:44:42 kill -9 14055 && /etc/init.d/pgbouncer restart
  492. 470 2015-12-30 15:19:21 su - postgres psql -c SELECT pg_terminate_backend(s.p id) FROM pg_stat_activity s WHERE 1=1 AND age(now(), s.query_start) > '00:05:00' and usename = 'pcs' ORDER BY s.query_start;
  493. 471 2015-12-30 15:19:30 su - postgres "psql -c SELECT pg_terminate_backend(s. pid) FROM pg_stat_activity s WHERE 1=1 AND age(now(), s.query_start) > '00:05:00 ' and usename = 'pcs' ORDER BY s.query_start;"
  494. 472 2015-12-30 15:19:50 su - postgres 'psql -c SELECT pg_terminate_backend(s. pid) FROM pg_stat_activity s WHERE 1=1 AND age(now(), s.query_start) > '00:05:00 ' and usename = 'pcs' ORDER BY s.query_start;'
  495. 473 2015-12-30 15:19:57 su - postgres
  496. 474 2015-12-30 15:20:30 su - postgres psql -c "SELECT pg_terminate_backend(s. pid) FROM pg_stat_activity s WHERE 1=1 AND age(now(), s.query_start) > '00:05:00 ' and usename = 'pcs' ORDER BY s.query_start;"
  497. 475 2015-12-30 15:20:50 su - postgres "psql -c \"SELECT pg_terminate_backend( s.pid) FROM pg_stat_activity s WHERE 1=1 AND age(now(), s.query_start) > '00:05: 00' and usename = 'pcs' ORDER BY s.query_start;\""
  498. 476 2015-12-30 15:21:25 ps -afx
  499. 477 2015-12-30 15:21:29 netstat -nlpt
  500. 478 2015-12-30 15:21:55 psql -h 127.0.0.1 -p 5432 -U postgres -c "SELECT pg_t erminate_backend(s.pid) FROM pg_stat_activity s WHERE 1=1 AND age(now(), s.query _start) > '00:05:00' and usename = 'pcs' ORDER BY s.query_start;"
  501. 479 2015-12-30 15:22:05 which psql
  502. 480 2015-12-30 15:22:15 /usr/bin/psql -h 127.0.0.1 -p 5432 -U postgres -c "SE LECT pg_terminate_backend(s.pid) FROM pg_stat_activity s WHERE 1=1 AND age(now() , s.query_start) > '00:05:00' and usename = 'pcs' ORDER BY s.query_start;"
  503. 481 2015-12-30 15:22:20 crontab -e
  504. 482 2015-12-30 17:56:07 date
  505. 483 2015-12-31 15:28:50 pvs
  506. 484 2015-12-31 15:28:59 lvs
  507. 485 2015-12-31 15:34:29 df -h
  508. 486 2015-12-31 15:39:40 echo 8TYG5K9h|passwd --stdin iadmin
  509. 487 2015-12-31 15:55:12 echo xe4Kq9ge|passwd --stdin iadmin
  510. 488 2015-12-31 15:55:56 passwd iadmin
  511. 489 2015-12-31 17:56:50 echo 6kncZ4Qh|passwd --stdin iadmin
  512. 490 2015-12-31 18:02:22 ls -l .ssh/
  513. 491 2015-12-31 18:02:45 crontab -l
  514. 492 2015-12-31 18:05:27 su - postgres
  515. 493 2015-12-31 18:14:49 less .ssh/authorized_keys
  516. 494 2015-12-31 18:15:37 cat /etc/redhat-release
  517. 495 2015-12-31 18:29:18 su - postgres
  518. 496 2015-12-31 18:32:04 crontab -l
  519. 497 2015-12-31 19:12:36 df -h
  520. 498 2015-12-31 19:12:43 cat /etc/fstab
  521. 499 2015-12-31 15:33:55 sudo su -
  522. 500 2016-01-05 20:16:14 ~/etc/init.d/pgbouncer start
  523. 501 2016-01-05 20:16:20 /etc/init.d/pgbouncer start
  524. 502 2016-01-05 20:17:01 chkconfig | grep pgboucer
  525. 503 2016-01-05 20:17:06 chkconfig | grep pgb
  526. 504 2016-01-05 20:17:11 chkconfig | grep p
  527. 505 2016-01-05 20:17:28 chkconfig pgbouncer on
  528. 506 2016-01-05 20:17:57 /etc/init.d/zabbix-agentd.sh restart
  529. 507 2016-01-05 20:19:04 chkconfig | grep zab
  530. 508 2016-01-05 20:19:08 chkconfig | grep za
  531. 509 2016-01-05 20:19:17 chkconfig --lixt
  532. 510 2016-01-05 20:19:20 chkconfig --list
  533. 511 2016-01-11 12:11:15 htop
  534. 512 2016-01-11 12:11:39 iostat -mx 5
  535. 513 2016-01-11 12:12:52 su - postgres
  536. 514 2016-01-11 12:19:05 iostat -mx 10
  537. 515 2016-01-11 12:48:02 crontab -l
  538. 516 2016-01-11 12:48:59 su - postgres
  539. 517 2016-01-11 12:55:06 /etc/init.d/pgbouncer status
  540. 518 2016-01-11 12:55:43 ps ax | grep rep_slave
  541. 519 2016-01-11 12:56:24 ps ax | grep pgbouncer
  542. 520 2016-01-11 12:56:45 less /etc/pgbouncer/pgbouncer.ini
  543. 521 2016-01-11 12:59:29 cat /etc/pgbouncer/userlist.txt
  544. 522 2016-01-11 12:59:34 less /etc/pgbouncer/pgbouncer.ini
  545. 523 2016-01-11 13:05:22 su - postgres
  546. 524 2016-01-11 13:09:16 sudo su - pgbouncer
  547. 525 2016-01-11 13:48:18 iostat -mx 10
  548. 526 2016-01-11 13:51:46 ifconfig
  549. 527 2016-01-11 13:53:08 less /etc/pgbouncer/pgbouncer.ini
  550. 528 2016-01-11 13:59:56 ls -l /etc/pgbouncer
  551. 529 2016-01-11 14:00:20 less /etc/pgbouncer/pgbouncer.ini
  552. 530 2016-01-11 14:22:44 df -h
  553. 531 2016-01-11 14:23:02 du -sch /pg_data/*
  554. 532 2016-01-11 12:19:40 su - postgres
  555. 533 2016-01-11 14:37:28 df -h
  556. 534 2016-01-11 14:37:46 du -sch /pg_data/9.4/*
  557. 535 2016-01-11 14:37:51 du -sch /pg_data/9.4/data/*
  558. 536 2016-01-11 14:38:00 du -sch /pg_data/9.4/data/base/*
  559. 537 2016-01-11 16:12:46 df -h
  560. 538 2016-01-11 16:13:02 su - postgres
  561. 539 2016-01-11 16:42:42 iostat -xm 10
  562. 540 2016-01-11 17:19:38 htop
  563. 541 2016-01-11 13:23:30 su - postgres
  564. 542 2016-01-11 17:43:29 ва -р
  565. 543 2016-01-11 17:43:31 df -h
  566. 544 2016-01-11 17:43:38 ls -l /pg_data/
  567. 545 2016-01-11 17:43:42 ls -l /pg_data/9.4/
  568. 546 2016-01-11 17:43:45 ls -l /pg_data/9.4/backups/
  569. 547 2016-01-11 17:43:52 ls -l /pg_data/9.4/archive/
  570. 548 2016-01-11 17:44:03 df -h
  571. 549 2016-01-11 17:44:26 du -sch /pg_data/*
  572. 550 2016-01-11 17:44:33 du -sch /pg_data/dumps/*
  573. 551 2016-01-11 17:47:20 du -sch /pg_data/dumps/weekly/*
  574. 552 2016-01-11 17:47:36 du -sch /pg_data/dumps/weekly/12/*
  575. 553 2016-01-11 17:47:45 du -sch /pg_data/dumps/weekly/12/26/*
  576. 554 2016-01-11 17:48:10 rm /pg_data/dumps/weekly/12/12/*
  577. 555 2016-01-11 17:48:18 du -sch /pg_data/dumps/weekly/12/12/
  578. 556 2016-01-11 17:48:20 du -sch /pg_data/dumps/weekly/12/12/*
  579. 557 2016-01-11 17:48:27 rm /pg_data/dumps/weekly/12/12/lsd_rmis66-1512120340. backup
  580. 558 2016-01-11 17:48:35 df -h
  581. 559 2016-01-11 17:48:50 du -sch /pg_data/dumps/weekly/12/*
  582. 560 2016-01-11 17:53:24 df -h
  583. 561 2016-01-11 17:55:30 exit
  584. 562 2016-01-11 18:23:43 df -h
  585. 563 2016-01-11 18:24:13 du -sch /pg_data/dumps/weekly/*
  586. 564 2016-01-11 18:24:20 du -sch /pg_data/dumps/weekly/12/*
  587. 565 2016-01-11 18:24:35 du -sch /pg_data/dumps/weekly/12/19/*
  588. 566 2016-01-11 18:24:44 rm /pg_data/dumps/weekly/12/19/lsd_rmis66-1512190340. backup
  589. 567 2016-01-11 18:24:54 df -h
  590. 568 2016-01-11 18:25:26 du -sch /pg_data/9.4/data/base/*
  591. 569 2016-01-11 18:28:52 df -h
  592. 570 2016-01-11 18:32:35 history
  593. [root@rmis66-db1 ~]# df
  594. Filesystem 1K-blocks Used Available Use% Mounted on
  595. /dev/mapper/vg_system-lv_root
  596. 47090616 6931724 37760592 16% /
  597. tmpfs 32985580 4 32985576 1% /dev/shm
  598. /dev/sdb1 243823 61302 169721 27% /boot
  599. /dev/mapper/vg_system-lv_tmp
  600. 999320 1316 945576 1% /tmp
  601. /dev/mapper/vg_postgres-lv_postgres
  602. 773957376 735766700 38190676 96% /pg_data
  603. [root@rmis66-db1 ~]# mc
  604.  
  605. You have new mail in /var/spool/mail/root
  606. [root@rmis66-db1 dumps]# df
  607. Filesystem 1K-blocks Used Available Use% Mounted on
  608. /dev/mapper/vg_system-lv_root
  609. 47090616 6932252 37760064 16% /
  610. tmpfs 32985580 4 32985576 1% /dev/shm
  611. /dev/sdb1 243823 61302 169721 27% /boot
  612. /dev/mapper/vg_system-lv_tmp
  613. 999320 1320 945572 1% /tmp
  614. /dev/mapper/vg_postgres-lv_postgres
  615. 773957376 739215144 34742232 96% /pg_data
  616. [root@rmis66-db1 dumps]# mc
  617.  
  618. You have mail in /var/spool/mail/root
  619. [root@rmis66-db1 weekly]# df
  620. Filesystem 1K-blocks Used Available Use% Mounted on
  621. /dev/mapper/vg_system-lv_root
  622. 47090616 6932764 37759552 16% /
  623. tmpfs 32985580 4 32985576 1% /dev/shm
  624. /dev/sdb1 243823 61302 169721 27% /boot
  625. /dev/mapper/vg_system-lv_tmp
  626. 999320 1320 945572 1% /tmp
  627. /dev/mapper/vg_postgres-lv_postgres
  628. 773957376 644389140 129568236 84% /pg_data
  629. [root@rmis66-db1 weekly]# mc
  630.  
  631. [root@rmis66-db1 data]# du -sh
  632. 524G .
  633. [root@rmis66-db1 data]# du -sh*
  634. du: invalid option -- '*'
  635. Try `du --help' for more information.
  636. You have mail in /var/spool/mail/root
  637. [root@rmis66-db1 data]# du -sh *
  638. 0 archive
  639. 489G base
  640. 6.7M global
  641. 49M pg_clog
  642. 4.0K pg_dynshmem
  643. 8.0K pg_hba.conf
  644. 4.0K pg_ident.conf
  645. 1.8M pg_log
  646. 12K pg_logical
  647. 242M pg_multixact
  648. 12K pg_notify
  649. 4.0K pg_replslot
  650. 4.0K pg_serial
  651. 4.0K pg_snapshots
  652. 4.0K pg_stat
  653. 8.7M pg_stat_tmp
  654. 1.6M pg_subtrans
  655. 4.0K pg_tblspc
  656. 4.0K pg_twophase
  657. 4.0K PG_VERSION
  658. 36G pg_xlog
  659. 4.0K postgresql.auto.conf
  660. 24K postgresql.conf
  661. 24K postgresql.conf.bak
  662. 24K postgresql-template.conf
  663. 4.0K postmaster.opts
  664. 4.0K postmaster.pid
  665. 4.0K term_all.out
  666. 4.0K term_all.sql
  667. [root@rmis66-db1 data]# du -sh *
  668. 0 archive
  669. 489G base
  670. 6.7M global
  671. 49M pg_clog
  672. 4.0K pg_dynshmem
  673. 8.0K pg_hba.conf
  674. 4.0K pg_ident.conf
  675. 1.8M pg_log
  676. 12K pg_logical
  677. 242M pg_multixact
  678. 12K pg_notify
  679. 4.0K pg_replslot
  680. 4.0K pg_serial
  681. 4.0K pg_snapshots
  682. 4.0K pg_stat
  683. 8.7M pg_stat_tmp
  684. 1.6M pg_subtrans
  685. 4.0K pg_tblspc
  686. 4.0K pg_twophase
  687. 4.0K PG_VERSION
  688. 36G pg_xlog
  689. 4.0K postgresql.auto.conf
  690. 24K postgresql.conf
  691. 24K postgresql.conf.bak
  692. 24K postgresql-template.conf
  693. 4.0K postmaster.opts
  694. 4.0K postmaster.pid
  695. 4.0K term_all.out
  696. 4.0K term_all.sql
  697. [root@rmis66-db1 data]# df
  698. Filesystem 1K-blocks Used Available Use% Mounted on
  699. /dev/mapper/vg_system-lv_root
  700. 47090616 6933080 37759236 16% /
  701. tmpfs 32985580 4 32985576 1% /dev/shm
  702. /dev/sdb1 243823 61302 169721 27% /boot
  703. /dev/mapper/vg_system-lv_tmp
  704. 999320 1320 945572 1% /tmp
  705. /dev/mapper/vg_postgres-lv_postgres
  706. 773957376 645530700 128426676 84% /pg_data
  707. You have mail in /var/spool/mail/root
  708. [root@rmis66-db1 data]# cd /pg_data/9.4/data/base/
  709. 1/ 1113426/ 12998/ 13003/ 16404/ 63323/ 63324/ 63325/ 63326/ 63327/ 74516/ pgsql_tmp/
  710. [root@rmis66-db1 data]# cd /pg_data/9.4/data/base/
  711. 1/ 1113426/ 12998/ 13003/ 16404/ 63323/ 63324/ 63325/ 63326/ 63327/ 74516/ pgsql_tmp/
  712. [root@rmis66-db1 data]# cd /pg_data/9.4/data/base/
  713. 1/ 1113426/ 12998/ 13003/ 16404/ 63323/ 63324/ 63325/ 63326/ 63327/ 74516/ pgsql_tmp/
  714. [root@rmis66-db1 data]# cd /pg_data/9.4/data/base/
  715. 1/ 1113426/ 12998/ 13003/ 16404/ 63323/ 63324/ 63325/ 63326/ 63327/ 74516/ pgsql_tmp/
  716. [root@rmis66-db1 data]# cd /pg_data/9.4/data/base/
  717. 1/ 1113426/ 12998/ 13003/ 16404/ 63323/ 63324/ 63325/ 63326/ 63327/ 74516/ pgsql_tmp/
  718. [root@rmis66-db1 data]# cd /pg_data/9.4/data/base/
  719. 1/ 1113426/ 12998/ 13003/ 16404/ 63323/ 63324/ 63325/ 63326/ 63327/ 74516/ pgsql_tmp/
  720. [root@rmis66-db1 data]# cd /pg_data/9.4/data/base/
  721. You have mail in /var/spool/mail/root
  722. [root@rmis66-db1 base]# du -sh *
  723. 6.8M 1
  724. 9.8G 1113426
  725. 6.6M 12998
  726. 6.9M 13003
  727. 350G 16404
  728. 12M 63323
  729. 5.4G 63324
  730. 41M 63325
  731. 7.5M 63326
  732. 7.3M 63327
  733. 7.2M 74516
  734. 126G pgsql_tmp
  735. [root@rmis66-db1 base]# du -sh *
  736. 6.8M 1
  737. 9.8G 1113426
  738. 6.6M 12998
  739. 6.9M 13003
  740. 350G 16404
  741. 12M 63323
  742. 5.4G 63324
  743. 41M 63325
  744. 7.5M 63326
  745. 7.3M 63327
  746. 7.2M 74516
  747. 126G pgsql_tmp
  748. [root@rmis66-db1 base]# du -sh *
  749. 6.8M 1
  750. 9.8G 1113426
  751. 6.6M 12998
  752. 6.9M 13003
  753. 350G 16404
  754. 12M 63323
  755. 5.4G 63324
  756. 41M 63325
  757. 7.5M 63326
  758. 7.3M 63327
  759. 7.2M 74516
  760. 126G pgsql_tmp
  761. [root@rmis66-db1 base]# mc
  762.  
  763. You have mail in /var/spool/mail/root
  764. [root@rmis66-db1 pgsql_tmp]# du -sh *
  765. 1.1G pgsql_tmp10398.203
  766. 1.1G pgsql_tmp10398.204
  767. 1.1G pgsql_tmp10398.205
  768. 610M pgsql_tmp10398.206
  769. 577M pgsql_tmp10398.207
  770. 1.1G pgsql_tmp16474.14
  771. 1.1G pgsql_tmp16474.15
  772. 1.1G pgsql_tmp16474.16
  773. 1.1G pgsql_tmp16474.17
  774. 1.1G pgsql_tmp16474.18
  775. 1.1G pgsql_tmp16474.19
  776. 1.1G pgsql_tmp16474.20
  777. 1.1G pgsql_tmp16474.21
  778. 1.1G pgsql_tmp16474.22
  779. 1.1G pgsql_tmp16474.23
  780. 1.1G pgsql_tmp16474.24
  781. 1.1G pgsql_tmp16474.25
  782. 1.1G pgsql_tmp16474.26
  783. 1.1G pgsql_tmp16474.27
  784. 1.1G pgsql_tmp16474.28
  785. 1.1G pgsql_tmp16474.29
  786. 1.1G pgsql_tmp16474.30
  787. 1.1G pgsql_tmp16474.31
  788. 1.1G pgsql_tmp16474.32
  789. 1.1G pgsql_tmp16474.33
  790. 1.1G pgsql_tmp16474.34
  791. 1.1G pgsql_tmp16474.35
  792. 1.1G pgsql_tmp16474.36
  793. 1.1G pgsql_tmp16474.37
  794. 1.1G pgsql_tmp16474.38
  795. 1.1G pgsql_tmp16474.39
  796. 1.1G pgsql_tmp16474.40
  797. 1.1G pgsql_tmp16474.41
  798. 1.1G pgsql_tmp16474.42
  799. 1.1G pgsql_tmp16474.43
  800. 1.1G pgsql_tmp16474.44
  801. 1.1G pgsql_tmp16474.45
  802. 1.1G pgsql_tmp16474.46
  803. 1.1G pgsql_tmp16474.47
  804. 1.1G pgsql_tmp16474.48
  805. 1.1G pgsql_tmp16474.49
  806. 1.1G pgsql_tmp16474.50
  807. 1.1G pgsql_tmp16474.51
  808. 1.1G pgsql_tmp16474.52
  809. 1.1G pgsql_tmp16474.53
  810. 1.1G pgsql_tmp16474.54
  811. 1.1G pgsql_tmp16474.55
  812. 1.1G pgsql_tmp16474.56
  813. 1.1G pgsql_tmp16474.57
  814. 1.1G pgsql_tmp16474.58
  815. 1.1G pgsql_tmp16474.59
  816. 1.1G pgsql_tmp16474.60
  817. 1.1G pgsql_tmp16474.61
  818. 1.1G pgsql_tmp16474.62
  819. 1.1G pgsql_tmp16474.63
  820. 1.1G pgsql_tmp16474.64
  821. 1.1G pgsql_tmp16474.65
  822. 1.1G pgsql_tmp16474.66
  823. 1.1G pgsql_tmp16474.67
  824. 1.1G pgsql_tmp16474.68
  825. 1.1G pgsql_tmp16474.69
  826. 849M pgsql_tmp16474.70
  827. 1.1G pgsql_tmp24453.0
  828. 1.1G pgsql_tmp24453.1
  829. 1.1G pgsql_tmp24453.10
  830. 1.1G pgsql_tmp24453.11
  831. 1.1G pgsql_tmp24453.12
  832. 1.1G pgsql_tmp24453.13
  833. 1.1G pgsql_tmp24453.14
  834. 1.1G pgsql_tmp24453.15
  835. 1.1G pgsql_tmp24453.16
  836. 1.1G pgsql_tmp24453.17
  837. 1.1G pgsql_tmp24453.18
  838. 1.1G pgsql_tmp24453.19
  839. 1.1G pgsql_tmp24453.2
  840. 1.1G pgsql_tmp24453.20
  841. 1.1G pgsql_tmp24453.21
  842. 1.1G pgsql_tmp24453.22
  843. 1.1G pgsql_tmp24453.23
  844. 1.1G pgsql_tmp24453.24
  845. 1.1G pgsql_tmp24453.25
  846. 1.1G pgsql_tmp24453.26
  847. 1.1G pgsql_tmp24453.27
  848. 1.1G pgsql_tmp24453.28
  849. 1.1G pgsql_tmp24453.29
  850. 1.1G pgsql_tmp24453.3
  851. 1.1G pgsql_tmp24453.30
  852. 1.1G pgsql_tmp24453.31
  853. 1.1G pgsql_tmp24453.32
  854. 1.1G pgsql_tmp24453.33
  855. 1.1G pgsql_tmp24453.34
  856. 1.1G pgsql_tmp24453.35
  857. 1.1G pgsql_tmp24453.36
  858. 1.1G pgsql_tmp24453.37
  859. 1.1G pgsql_tmp24453.38
  860. 1.1G pgsql_tmp24453.39
  861. 1.1G pgsql_tmp24453.4
  862. 1.1G pgsql_tmp24453.40
  863. 1.1G pgsql_tmp24453.41
  864. 1.1G pgsql_tmp24453.42
  865. 1.1G pgsql_tmp24453.43
  866. 1.1G pgsql_tmp24453.44
  867. 1.1G pgsql_tmp24453.45
  868. 1.1G pgsql_tmp24453.46
  869. 1.1G pgsql_tmp24453.47
  870. 1.1G pgsql_tmp24453.48
  871. 1.1G pgsql_tmp24453.49
  872. 1.1G pgsql_tmp24453.5
  873. 1.1G pgsql_tmp24453.50
  874. 1.1G pgsql_tmp24453.51
  875. 1.1G pgsql_tmp24453.52
  876. 1.1G pgsql_tmp24453.53
  877. 1.1G pgsql_tmp24453.54
  878. 1.1G pgsql_tmp24453.55
  879. 1.1G pgsql_tmp24453.56
  880. 1.1G pgsql_tmp24453.57
  881. 1.1G pgsql_tmp24453.58
  882. 1.1G pgsql_tmp24453.59
  883. 1.1G pgsql_tmp24453.6
  884. 1.1G pgsql_tmp24453.60
  885. 1.1G pgsql_tmp24453.61
  886. 1.1G pgsql_tmp24453.62
  887. 1.1G pgsql_tmp24453.63
  888. 1.1G pgsql_tmp24453.64
  889. 1005M pgsql_tmp24453.65
  890. 1.1G pgsql_tmp24453.7
  891. 1.1G pgsql_tmp24453.8
  892. 1.1G pgsql_tmp24453.9
  893. [root@rmis66-db1 pgsql_tmp]# cd ../
  894. You have mail in /var/spool/mail/root
  895. [root@rmis66-db1 base]# du -sh *
  896. 6.8M 1
  897. 9.8G 1113426
  898. 6.6M 12998
  899. 6.9M 13003
  900. 350G 16404
  901. 12M 63323
  902. 5.4G 63324
  903. 41M 63325
  904. 7.5M 63326
  905. 7.3M 63327
  906. 7.2M 74516
  907. 128G pgsql_tmp
  908. [root@rmis66-db1 base]# du -sh *
  909. 6.8M 1
  910. 9.8G 1113426
  911. 6.6M 12998
  912. 6.9M 13003
  913. 350G 16404
  914. 12M 63323
  915. 5.4G 63324
  916. 41M 63325
  917. 7.5M 63326
  918. 7.3M 63327
  919. 7.2M 74516
  920. 131G pgsql_tmp
  921. You have mail in /var/spool/mail/root
  922. [root@rmis66-db1 base]# su postgres
  923. bash-4.1$ history
  924. 1 2016-01-11 18:46:24 cd /pg_data/dumps/
  925. 2 2016-01-11 18:46:24 ll
  926. 3 2016-01-11 18:46:24 pg_restore --help
  927. 4 2016-01-11 18:46:24 psql
  928. 5 2016-01-11 18:46:24 ll
  929. 6 2016-01-11 18:46:24 cd ./dumps/
  930. 7 2016-01-11 18:46:24 pg_restore
  931. 8 2016-01-11 18:46:24 pg_restore --help
  932. 9 2016-01-11 18:46:24 pg_restore -d lsd_rmis66 -v ./lsd_rmis66-1509211806.backup
  933. 10 2016-01-11 18:46:24 psql
  934. 11 2016-01-11 18:46:24 pg_restore -d lsd_rmis66 -v ./lsd_rmis66-1509211806.backup
  935. 12 2016-01-11 18:46:24 +
  936. 13 2016-01-11 18:46:24 psql
  937. 14 2016-01-11 18:46:24 /etc/init.d/postgresql-9.4 reload
  938. 15 2016-01-11 18:46:24 ssh-keygen
  939. 16 2016-01-11 18:46:24 ssh-copy-id postgres@192.168.2.136
  940. 17 2016-01-11 18:46:24 ssh postgres@192.168.2.136
  941. 18 2016-01-11 18:46:24 mc
  942. 19 2016-01-11 18:46:24 cd /pg_data/dumps/
  943. 20 2016-01-11 18:46:24 ll
  944. 21 2016-01-11 18:46:24 psql
  945. 22 2016-01-11 18:46:24 pg_restore --help
  946. 23 2016-01-11 18:46:24 pg_restore -d wls ./dumps/wls.backup -v
  947. 24 2016-01-11 18:46:24 pg_restore -d siei ./dumps/siei.backup -v
  948. 25 2016-01-11 18:46:24 pg_restore -d rls ./dumps/rls.backup -v
  949. 26 2016-01-11 18:46:24 pg_restore -d pacsdb2 ./dumps/pacsdb2.backup -v
  950. 27 2016-01-11 18:46:24 pg_restore -d pacsdb ./dumps/pacsdb.backup -v
  951. 28 2016-01-11 18:46:24 ssh postgres@192.168.2.119
  952. 29 2016-01-11 18:46:24 pwd
  953. 30 2016-01-11 18:46:24 grep scp 9.4/data/postgresql.conf
  954. 31 2016-01-11 18:46:24 cd 9.4/data/
  955. 32 2016-01-11 18:46:24 cd archive/
  956. 33 2016-01-11 18:46:24 ls
  957. 34 2016-01-11 18:46:24 grep scp 9.4/data/postgresql.conf
  958. 35 2016-01-11 18:46:24 grep scp ../data/postgresql.conf
  959. 36 2016-01-11 18:46:24 cd ../
  960. 37 2016-01-11 18:46:24 pwd
  961. 38 2016-01-11 18:46:24 ls -l
  962. 39 2016-01-11 18:46:24 cd ..
  963. 40 2016-01-11 18:46:24 rsync -au archive/ 192.168.2.119:/pg_data/9.4/archive/
  964. 41 2016-01-11 18:46:24 rsync -au archive/00000001000000610000003B 192.168.2.119:/pg_data/9.4/archive/
  965. 42 2016-01-11 18:46:24 rsync -au archive/0000000100000061000000* 192.168.2.119:/pg_data/9.4/archive/
  966. 43 2016-01-11 18:46:24 rsync -au archive/0000000100000062000000* 192.168.2.119:/pg_data/9.4/archive/
  967. 44 2016-01-11 18:46:24 rsync -au archive/0000000100000063000000* 192.168.2.119:/pg_data/9.4/archive/
  968. 45 2016-01-11 18:46:24 rsync -au archive/0000000100000064000000* 192.168.2.119:/pg_data/9.4/archive/
  969. 46 2016-01-11 18:46:24 rsync -au archive/000000010000006[5-7]000000* 192.168.2.119:/pg_data/9.4/archive/
  970. 47 2016-01-11 18:46:24 rsync -au archive/000000010000006[89]000000* 192.168.2.119:/pg_data/9.4/archive/
  971. 48 2016-01-11 18:46:24 rsync -au archive/000000010000006A000000* 192.168.2.119:/pg_data/9.4/archive/
  972. 49 2016-01-11 18:46:24 rsync -au archive/000000010000006[B-F]000000* 192.168.2.119:/pg_data/9.4/archive/
  973. 50 2016-01-11 18:46:24 ls -lt archive/000000010000006F00000099
  974. 51 2016-01-11 18:46:24 ls -lt archive/000000010000007000000000
  975. 52 2016-01-11 18:46:24 rsync -au archive/0000000100000070000000* 192.168.2.119:/pg_data/9.4/archive/
  976. 53 2016-01-11 18:46:24 rsync -au archive/000000010000007[123]000000* 192.168.2.119:/pg_data/9.4/archive/
  977. 54 2016-01-11 18:46:24 ls -lt archive/000000010000007400000000
  978. 55 2016-01-11 18:46:24 date
  979. 56 2016-01-11 18:46:24 rsync -au archive/000000010000007[4-9]000000* 192.168.2.119:/pg_data/9.4/archive/
  980. 57 2016-01-11 18:46:24 rsync -au archive/000000010000007[A-F]000000* 192.168.2.119:/pg_data/9.4/archive/
  981. 58 2016-01-11 18:46:24 ls -lt archive/000000010000008000000000
  982. 59 2016-01-11 18:46:24 date
  983. 60 2016-01-11 18:46:24 rsync -au archive/000000010000008[0-9]000000* 192.168.2.119:/pg_data/9.4/archive/
  984. 61 2016-01-11 18:46:24 rsync -au archive/000000010000008[A-F]000000* 192.168.2.119:/pg_data/9.4/archive/
  985. 62 2016-01-11 18:46:24 rsync -au archive/000000010000009*000000* 192.168.2.119:/pg_data/9.4/archive/
  986. 63 2016-01-11 18:46:24 rsync -au archive/00000001000000[6-8]*000000* 192.168.2.119:/pg_data/9.4/archive/
  987. 64 2016-01-11 18:46:24 rsync -au archive/000000010000009*000000* 192.168.2.119:/pg_data/9.4/archive/
  988. 65 2016-01-11 18:46:24 rsync -au archive/000000010000008*000000* 192.168.2.119:/pg_data/9.4/archive/
  989. 66 2015-10-02 13:19:15 history
  990. 67 2015-10-02 13:19:20 psql lsd_rmis66
  991. 68 2015-10-02 15:12:54 EXIT
  992. 69 2015-10-02 15:12:56 exit
  993. 70 2015-10-02 15:13:59 drop table if exists kaluga_loader_src;
  994. 71 2015-10-02 15:14:04 psql lsd_rmis66
  995. 72 2015-10-06 18:30:06 psql lsd_rmis66 -U app_group_master
  996. 73 2015-10-06 18:30:09 psql lsd_rmis66
  997. 74 2015-10-09 16:11:03 vi nabivalka.sql
  998. 75 2015-10-09 16:11:29 exit
  999. 76 2015-10-09 16:12:17 psql lsd_rmis66
  1000. 77 2015-10-09 16:12:32 psql lsd_rmis66<nabivalka.sql
  1001. 78 2016-01-11 18:46:24 crontab -l
  1002. 79 2016-01-11 18:46:24 /usr/pgsql-9.4/bin/pg_ctl reload
  1003. 80 2015-10-23 19:13:55 psql lsd_rmis66
  1004. 81 2015-11-02 19:16:21 psql lsd_rmis66 -U jenkins
  1005. 82 2015-11-02 19:16:34 exit
  1006. 83 2015-11-02 19:16:48 psql lsd_rmis66 -U jenkins -h 192.168.2.114
  1007. 84 2016-01-11 18:46:24 vacuumdb --help
  1008. 85 2016-01-11 18:46:24 vacuumdb -avz
  1009. 86 2016-01-11 18:46:24 ssh 192.168.2.121
  1010. 87 2016-01-11 18:46:24 psql
  1011. 88 2016-01-11 18:46:24 ulimit 0a
  1012. 89 2016-01-11 18:46:24 ulimit -a
  1013. 90 2016-01-11 18:46:24 vacuumdb --help
  1014. 91 2016-01-11 18:46:24 vacuumdb -afvz
  1015. 92 2016-01-11 18:46:24 psql]
  1016. 93 2016-01-11 18:46:24 psql
  1017. 94 2016-01-11 18:46:24 vacuumdb -afvz
  1018. 95 2016-01-11 18:46:24 vacuumdb --help
  1019. 96 2016-01-11 18:46:24 vacuumdb -afvz
  1020. 97 2016-01-11 18:46:24 psql
  1021. 98 2016-01-11 18:46:24 psql -c "SELECT pg_terminate_backend(s.pid) FROM pg_stat_activity s WHERE 1=1 AND age(now(), s.query_start) > '00:05:00' and usename = 'pcs' ORDER BY s.query_start;"
  1022. 99 2016-01-11 18:46:24 ls -l .ssh/
  1023. 100 2016-01-11 18:46:24 cat .ssh/.id_rsa.pub
  1024. 101 2016-01-11 18:46:24 cat .ssh/id_rsa.pub
  1025. 102 2016-01-11 18:46:24 psql
  1026. 103 2016-01-11 18:46:24 df -h
  1027. 104 2016-01-11 18:46:24 du -sch /pg_data/*
  1028. 105 2016-01-11 18:46:24 du -sch /pg_data/dumps/*
  1029. 106 2016-01-11 18:46:24 cat /etc/fstab
  1030. 107 2016-01-11 18:46:24 less .ssh/authorized_keys
  1031. 108 2016-01-11 18:46:24 exit
  1032. 109 2016-01-11 18:46:24 psql
  1033. 110 2016-01-11 18:46:24 crontab -l
  1034. 111 2016-01-11 18:46:24 exit
  1035. 112 2016-01-11 18:46:24 psql
  1036. 113 2016-01-11 18:46:24 htop
  1037. 114 2016-01-11 18:46:24 exit
  1038. 115 2016-01-11 18:46:24 psql
  1039. 116 2016-01-11 18:46:24 htop
  1040. 117 2016-01-11 18:46:24 psql -с "select pid, usename, datname, client_addr, query_start, query from pg_stat_activity where state = 'active' order by query_start;" > active_query_20160111_1028
  1041. 118 2016-01-11 18:46:24 psql -c "select pid, usename, datname, client_addr, query_start, query from pg_stat_activity where state = 'active' order by query_start;" > active_query_20160111_1028
  1042. 119 2016-01-11 18:46:24 less active_query_20160111_1028
  1043. 120 2016-01-11 18:46:24 psql -c "\x; select pid, usename, datname, client_addr, query_start, query from pg_stat_activity where state = 'active' order by query_start;" > active_query_20160111_1028
  1044. 121 2016-01-11 18:46:24 vim getactive.sql
  1045. 122 2016-01-11 18:46:24 psql -f getactive.sql > active_query_20160111_1030
  1046. 123 2016-01-11 18:46:24 less active_query_20160111_1030
  1047. 124 2016-01-11 18:46:24 psql
  1048. 125 2016-01-11 18:46:24 psql -f getactive.sql > active_query_20160111_1033
  1049. 126 2016-01-11 18:46:24 date
  1050. 127 2016-01-11 18:46:24 less active_query_20160111_1033
  1051. 128 2016-01-11 18:46:24 htop
  1052. 129 2016-01-11 18:46:24 crontab -l
  1053. 130 2016-01-11 18:46:24 exit
  1054. 131 2016-01-11 18:46:24 psql -f getactive.sql > active_query_20160111_1051
  1055. 132 2016-01-11 18:46:24 less active_query_20160111_1051
  1056. 133 2016-01-11 18:46:24 psql
  1057. 134 2016-01-11 18:46:24 psql -p 6543 pgbouncer
  1058. 135 2016-01-11 18:46:24 less /etc/pgbouncer/pgbouncer.ini
  1059. 136 2016-01-11 18:46:24 psql -p 6432 pgbouncer
  1060. 137 2016-01-11 18:46:24 less /etc/pgbouncer/pgbouncer.ini
  1061. 138 2016-01-11 18:46:24 psql -h localhost -p 6432
  1062. 139 2016-01-11 18:46:24 psql -h localhost -p 6432 -U pgbouncer
  1063. 140 2016-01-11 18:46:24 less /etc/pgbouncer/pgbouncer.ini
  1064. 141 2016-01-11 18:46:24 id pgbouncer
  1065. 142 2016-01-11 18:46:24 exit
  1066. 143 2016-01-11 18:46:24 psql
  1067. 144 2016-01-11 18:46:24 df -h
  1068. 145 2016-01-11 18:46:24 psql
  1069. 146 2016-01-11 18:46:24 df -h
  1070. 147 2016-01-11 18:46:24 psql
  1071. 148 2016-01-11 18:46:24 учше
  1072. 149 2016-01-11 18:46:24 exit
  1073. 150 2016-01-11 18:46:24 psql
  1074. 151 2016-01-11 18:46:24 ls -l
  1075. 152 2016-01-11 18:46:24 vim getlock.sql
  1076. 153 2016-01-11 18:46:24 psql -f getlock.sql > getlock_20160111_1132
  1077. 154 2016-01-11 18:46:24 less getlock_20160111_1132
  1078. 155 2016-01-11 18:46:24 psql -f getactive.sql > active_query_20160111_1133
  1079. 156 2016-01-11 18:46:24 psql
  1080. 157 2016-01-11 18:46:24 ls -l
  1081. 158 2016-01-11 18:46:24 df -h
  1082. 159 2016-01-11 18:46:24 ls -l /pg_data
  1083. 160 2016-01-11 18:46:24 ls -l /pg_data/9.4/
  1084. 161 2016-01-11 18:46:24 ls -l /pg_data/9.4/archive/
  1085. 162 2016-01-11 18:46:24 less /pg_data/9.4/data/postgresql.conf
  1086. 163 2016-01-11 18:46:39 history
  1087. bash-4.1$ date
  1088. Mon Jan 11 18:47:27 YEKT 2016
  1089. You have new mail in /var/spool/mail/root
  1090. bash-4.1$ psql -U lsd_rmis66
  1091. psql: FATAL: Peer authentication failed for user "lsd_rmis66"
  1092. bash-4.1$ psql -U lsd_rmis66 -h 127.0.0.1
  1093. Password for user lsd_rmis66:
  1094. You have mail in /var/spool/mail/root
  1095. bash-4.1$ psql -d lsd_rmis66 -h 127.0.0.1
  1096. psql (9.4.4)
  1097. Type "help" for help.
  1098.  
  1099. lsd_rmis66=# SELECT l.locktype
  1100. ,pg_class.relname AS table_name
  1101. --,pg_cancel_backend(s.pid)
  1102. ,l.transactionid
  1103. ,l.virtualtransaction
  1104. ,l.virtualxid
  1105. ,l.mode
  1106. ,l.granted
  1107. ,s.pid AS process_id
  1108. ,s.waiting
  1109. ,age(now(), s.query_start)
  1110. ,query
  1111. FROM pg_stat_activity s
  1112. LEFT JOIN pg_locks l ON l.pid = s.pid AND l.pid <> pg_backend_pid() AND l.mode <> 'AccessShareLock'
  1113. LEFT JOIN pg_class ON l.relation = pg_class.oid
  1114. WHERE s.xact_start IS NOT NULL -- выводит все активные соединения, транзакции и запросы
  1115. -- s.state = 'active' -- фильтр только на активные SQL запросы
  1116. -- AND lower(s.query) like 'exp%' -- фильтр по тексту запроса
  1117. -- AND age(now(), s.query_start) > '00:10:00' -- фильтр по времени работы
  1118. ORDER BY s.query_start;
  1119. locktype | table_name | transactionid | virtualtransaction | virtualxid | mode | granted | process_id | waiting | age |
  1120.  
  1121. q
  1122. uery
  1123.  
  1124.  
  1125. ---------------+------------------------------------------------------+---------------+--------------------+------------+--------------------------+---------+------------+---------+------------------+-------------------------------------
  1126. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  1127. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  1128. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  1129. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  1130. ----------------------------------------
  1131. virtualxid | | | 248/156286 | 248/156286 | ExclusiveLock | t | 16474 | f | 02:10:01.441149 | with recursive param as (select to_d
  1132. ate($1,'dd.mm.yyyy') d1, to_date($2,'dd.mm.yyyy') d2, $3::integer cln, $4::text regs, $5::integer dep, $6::text as fl, $7::integer as dctr),
  1133.  
  1134.  
  1135.  
  1136. +
  1137. | | | | | | | | | | all_deps as (
  1138.  
  1139.  
  1140.  
  1141.  
  1142. +
  1143. | | | | | | | | | | select pd.id,fl from param join pim_
  1144. department pd on pd.org_id = cln and pd.id = dep union
  1145.  
  1146.  
  1147.  
  1148. +
  1149. | | | | | | | | | | select pd.id,fl from all_deps join p
  1150. im_department pd on pd.parent_id = all_deps.id and trim(fl)='true'),
  1151.  
  1152.  
  1153.  
  1154. +
  1155. | | | | | | | | | | -- тип прикрепления
  1156.  
  1157.  
  1158.  
  1159.  
  1160. +
  1161. | | | | | | | | | | rt_ as (select to_number(trim(regexp
  1162. _split_to_table(regs,',')),'999999') id from param),
  1163.  
  1164.  
  1165.  
  1166. +
  1167. | | | | | | | | | | rt as (
  1168.  
  1169.  
  1170.  
  1171.  
  1172. +
  1173. | | | | | | | | | | select distinct rt.id
  1174.  
  1175.  
  1176.  
  1177.  
  1178. +
  1179. | | | | | | | | | | from md_reg_type rt
  1180.  
  1181.  
  1182.  
  1183.  
  1184. +
  1185. | | | | | | | | | | cross join param
  1186.  
  1187.  
  1188.  
  1189.  
  1190. +
  1191. | | | | | | | | | | left join rt_ rt1 on rt1.id = rt.i
  1192. d or regs is null
  1193.  
  1194.  
  1195.  
  1196. +
  1197. | | | | | | | | | | where regs is null or rt1.id = rt.i
  1198. d),
  1199.  
  1200.  
  1201.  
  1202. +
  1203. | | | | | | | | | |
  1204.  
  1205.  
  1206.  
  1207.  
  1208. +
  1209. | | | | | | | | | | positions as (
  1210.  
  1211.  
  1212.  
  1213.  
  1214. +
  1215. | | | | | | | | | | select distinct pep.id
  1216.  
  1217.  
  1218.  
  1219.  
  1220. +
  1221. | | | | | | | | | | from param
  1222.  
  1223.  
  1224.  
  1225.  
  1226. +
  1227. | | | | | | | | | | left join all_deps on true
  1228.  
  1229.  
  1230.  
  1231.  
  1232. +
  1233. | | | | | | | | | | join pim_position pp on pp.organiz
  1234. ation_id = param.cln and (pp.department_id = all_deps.id or dep is null)
  1235.  
  1236.  
  1237.  
  1238. +
  1239. | | | | | | | | | | join pim_department pd on pd.id =
  1240. pp.department_id
  1241.  
  1242.  
  1243.  
  1244. +
  1245. | | | | | | | | | | join pim_department_kind k on k.id
  1246. = pd.kind_id
  1247.  
  1248.  
  1249.  
  1250. +
  1251. | | | | | | | | | | left join pim_department_kind par_
  1252. k on par_k.id
  1253. virtualxid | | | 189/109965 | 189/109965 | ExclusiveLock | t | 10398 | f | 00:21:51.405306 | with recursive param as (select to_d
  1254. ate($1,'dd.mm.yyyy') d1, to_date($2,'dd.mm.yyyy') d2, $3::integer cln, $4::text regs, $5::integer dep, $6::text as fl, $7::integer as dctr),
  1255.  
  1256.  
  1257.  
  1258. +
  1259. | | | | | | | | | | all_deps as (
  1260.  
  1261.  
  1262.  
  1263.  
  1264. +
  1265. | | | | | | | | | | select pd.id,fl from param join pim_
  1266. department pd on pd.org_id = cln and pd.id = dep union
  1267.  
  1268.  
  1269.  
  1270. +
  1271. | | | | | | | | | | select pd.id,fl from all_deps join p
  1272. im_department pd on pd.parent_id = all_deps.id and trim(fl)='true'),
  1273.  
  1274.  
  1275.  
  1276. +
  1277. | | | | | | | | | | -- тип прикрепления
  1278.  
  1279.  
  1280.  
  1281.  
  1282. +
  1283. | | | | | | | | | | rt_ as (select to_number(trim(regexp
  1284. _split_to_table(regs,',')),'999999') id from param),
  1285.  
  1286.  
  1287.  
  1288. +
  1289. | | | | | | | | | | rt as (
  1290.  
  1291.  
  1292.  
  1293.  
  1294. +
  1295. | | | | | | | | | | select distinct rt.id
  1296.  
  1297.  
  1298.  
  1299.  
  1300. +
  1301. | | | | | | | | | | from md_reg_type rt
  1302.  
  1303.  
  1304.  
  1305.  
  1306. +
  1307. | | | | | | | | | | cross join param
  1308.  
  1309.  
  1310.  
  1311.  
  1312. +
  1313. | | | | | | | | | | left join rt_ rt1 on rt1.id = rt.i
  1314. d or regs is null
  1315.  
  1316.  
  1317.  
  1318. +
  1319. | | | | | | | | | | where regs is null or rt1.id = rt.i
  1320. d),
  1321.  
  1322.  
  1323.  
  1324. +
  1325. | | | | | | | | | |
  1326.  
  1327.  
  1328.  
  1329.  
  1330. +
  1331. | | | | | | | | | | positions as (
  1332.  
  1333.  
  1334.  
  1335.  
  1336. +
  1337. | | | | | | | | | | select distinct pep.id
  1338.  
  1339.  
  1340.  
  1341.  
  1342. +
  1343. | | | | | | | | | | from param
  1344.  
  1345.  
  1346.  
  1347.  
  1348. lsd_rmis66=# \q
  1349. bash-4.1$ \q
  1350. bash: q: command not found
  1351. You have mail in /var/spool/mail/root
  1352. bash-4.1$ exit
  1353. exit
  1354. You have mail in /var/spool/mail/root
  1355. [root@rmis66-db1 base]# du -sh *
  1356. 6.8M 1
  1357. 9.8G 1113426
  1358. 6.6M 12998
  1359. 6.9M 13003
  1360. 350G 16404
  1361. 12M 63323
  1362. 5.4G 63324
  1363. 41M 63325
  1364. 7.5M 63326
  1365. 7.3M 63327
  1366. 7.2M 74516
  1367. 137G pgsql_tmp
  1368. [root@rmis66-db1 base]# du -sh *
  1369. 6.8M 1
  1370. 9.8G 1113426
  1371. 6.6M 12998
  1372. 6.9M 13003
  1373. 350G 16404
  1374. 12M 63323
  1375. 5.4G 63324
  1376. 41M 63325
  1377. 7.5M 63326
  1378. 7.3M 63327
  1379. 7.2M 74516
  1380. 137G pgsql_tmp
  1381. [root@rmis66-db1 base]# du -sh *
  1382. 6.8M 1
  1383. 9.8G 1113426
  1384. 6.6M 12998
  1385. 6.9M 13003
  1386. 350G 16404
  1387. 12M 63323
  1388. 5.4G 63324
  1389. 41M 63325
  1390. 7.5M 63326
  1391. 7.3M 63327
  1392. 7.2M 74516
  1393. 137G pgsql_tmp
  1394. [root@rmis66-db1 base]# du -sh *
  1395. 6.8M 1
  1396. 9.8G 1113426
  1397. 6.6M 12998
  1398. 6.9M 13003
  1399. 350G 16404
  1400. 12M 63323
  1401. 5.4G 63324
  1402. 41M 63325
  1403. 7.5M 63326
  1404. 7.3M 63327
  1405. 7.2M 74516
  1406. 137G pgsql_tmp
  1407. [root@rmis66-db1 base]# df
  1408. Filesystem 1K-blocks Used Available Use% Mounted on
  1409. /dev/mapper/vg_system-lv_root
  1410. 47090616 6934540 37757776 16% /
  1411. tmpfs 32985580 4 32985576 1% /dev/shm
  1412. /dev/sdb1 243823 61302 169721 27% /boot
  1413. /dev/mapper/vg_system-lv_tmp
  1414. 999320 1320 945572 1% /tmp
  1415. /dev/mapper/vg_postgres-lv_postgres
  1416. 773957376 658498376 115459000 86% /pg_data
  1417. [root@rmis66-db1 base]# htop
  1418. You have mail in /var/spool/mail/root
  1419. [root@rmis66-db1 base]# mc
  1420.  
  1421. [root@rmis66-db1 base]# du -sh *
  1422. 6.8M 1
  1423. 9.8G 1113426
  1424. 6.6M 12998
  1425. 6.9M 13003
  1426. 350G 16404
  1427. 12M 63323
  1428. 5.4G 63324
  1429. 41M 63325
  1430. 7.5M 63326
  1431. 7.3M 63327
  1432. 7.2M 74516
  1433. 141G pgsql_tmp
  1434. [root@rmis66-db1 base]# du -sh *
  1435. 6.8M 1
  1436. 9.8G 1113426
  1437. 6.6M 12998
  1438. 6.9M 13003
  1439. 350G 16404
  1440. 12M 63323
  1441. 5.4G 63324
  1442. 41M 63325
  1443. 7.5M 63326
  1444. 7.3M 63327
  1445. 7.2M 74516
  1446. 143G pgsql_tmp
  1447. You have mail in /var/spool/mail/root
  1448. [root@rmis66-db1 base]# du -sh *
  1449. 6.8M 1
  1450. 9.8G 1113426
  1451. 6.6M 12998
  1452. 6.9M 13003
  1453. 350G 16404
  1454. 12M 63323
  1455. 5.4G 63324
  1456. 41M 63325
  1457. 7.5M 63326
  1458. 7.3M 63327
  1459. 7.2M 74516
  1460. 143G pgsql_tmp
  1461. [root@rmis66-db1 base]# df
  1462. Filesystem 1K-blocks Used Available Use% Mounted on
  1463. /dev/mapper/vg_system-lv_root
  1464. 47090616 6935524 37756792 16% /
  1465. tmpfs 32985580 4 32985576 1% /dev/shm
  1466. /dev/sdb1 243823 61302 169721 27% /boot
  1467. /dev/mapper/vg_system-lv_tmp
  1468. 999320 1320 945572 1% /tmp
  1469. /dev/mapper/vg_postgres-lv_postgres
  1470. 773957376 664760100 109197276 86% /pg_data
  1471. You have mail in /var/spool/mail/root
  1472. [root@rmis66-db1 base]# df
  1473. Filesystem 1K-blocks Used Available Use% Mounted on
  1474. /dev/mapper/vg_system-lv_root
  1475. 47090616 6936060 37756256 16% /
  1476. tmpfs 32985580 4 32985576 1% /dev/shm
  1477. /dev/sdb1 243823 61302 169721 27% /boot
  1478. /dev/mapper/vg_system-lv_tmp
  1479. 999320 1320 945572 1% /tmp
  1480. /dev/mapper/vg_postgres-lv_postgres
  1481. 773957376 664811668 109145708 86% /pg_data
  1482. You have mail in /var/spool/mail/root
  1483. [root@rmis66-db1 base]# htop
  1484.  
  1485. 1 [|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||99.4%] Tasks: 214, 3 thr; 10 running
  1486. 2 [|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||99.4%] Load average: 9.28 8.30 7.50
  1487. 3 [||||||||| 7.5%] Uptime: 5 days, 22:53:40
  1488. 4 [||||||||||||||| 13.4%]
  1489. 5 [||||||||||||||||||||||||||||||||||||||||| 36.9%]
  1490. 6 [||||||||||| 9.4%]
  1491. 7 [|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||96.9%]
  1492. 8 [|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||98.7%]
  1493. 9 [ 0.0%]
  1494. 10 [|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||99.4%]
  1495. 11 [|||||||||||||||||| 15.9%]
  1496. 12 [|||||||||||||||||||||||||||||||||| 30.6%]
  1497. 13 [||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| 92.5%]
  1498. 14 [||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| 55.0%]
  1499. 15 [|||||||||||||||||||||| 19.7%]
  1500. 16 [|||||||||||||||||| 15.8%]
  1501. 17 [||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||100.0%]
  1502. 18 [|||||||| 6.3%]
  1503. 19 [||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||100.0%]
  1504. 20 [ 0.0%]
  1505. 21 [|||||||||||||||||||||||||||||||||||| 32.9%]
  1506. 22 [||||||||||| 8.9%]
  1507. 23 [|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| 82.4%]
  1508. 24 [||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| 86.8%]
  1509. Mem[|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||33595/64424MB]
  1510. Swp[| 10/8191MB]
  1511.  
  1512. PID USER PRI NI VIRT RES SHR S CPU% MEM% TIME+ Command
  1513. 5403 postgres 20 0 8719M 2047M 2004M R 98.0 3.2 6:22.28 postgres: lsd lsd_rmis66 127.0.0.1(44459) idle
  1514. 16474 postgres 20 0 15.6G 14.9G 7947M R 97.0 23.7 2h25:20 postgres: rep_slave lsd_rmis66 127.0.0.1(38771) SELECT
  1515. 13017 postgres 20 0 8693M 710M 691M R 97.0 1.1 0:11.83 postgres: lsd lsd_rmis66 127.0.0.1(44828) SELECT
  1516. 7630 postgres 20 0 8719M 1319M 1275M R 97.0 2.0 1:33.48 postgres: lsd lsd_rmis66 127.0.0.1(44571) idle
  1517. 7640 postgres 20 0 8716M 1701M 1661M R 97.0 2.6 2:55.15 postgres: lsd lsd_rmis66 127.0.0.1(44576) idle
  1518. 7647 postgres 20 0 8720M 1740M 1694M R 97.0 2.7 4:28.88 postgres: lsd lsd_rmis66 127.0.0.1(44583) idle
  1519. 10398 postgres 20 0 17.9G 17.2G 7990M R 95.0 27.4 1h13:53 postgres: rep_slave lsd_rmis66 127.0.0.1(38449) SELECT
  1520. 7643 postgres 20 0 8719M 1815M 1770M R 95.0 2.8 5:39.86 postgres: lsd lsd_rmis66 127.0.0.1(44579) idle
  1521. 26998 postgres 20 0 8751M 5651M 5574M S 84.0 8.8 1:42.90 postgres: lsd lsd_rmis66 127.0.0.1(43960) idle
  1522. 8410 postgres 20 0 8770M 4646M 4560M S 79.0 7.2 47:44.61 postgres: int lsd_rmis66 127.0.0.1(39970) SELECT
  1523. 13020 postgres 20 0 8700M 351M 327M R 77.0 0.5 0:03.50 postgres: lsd lsd_rmis66 127.0.0.1(44830) idle
  1524. 28483 postgres 20 0 8759M 8051M 7967M S 23.0 12.5 7:32.62 postgres: lsd lsd_rmis66 127.0.0.1(42513) SELECT
  1525. 13264 postgres 20 0 8755M 7439M 7359M S 11.0 11.5 2:59.33 postgres: lsd lsd_rmis66 127.0.0.1(43301) idle
  1526. 3970 postgres 20 0 8756M 7763M 7684M S 11.0 12.1 4:13.92 postgres: lsd lsd_rmis66 127.0.0.1(42884) idle
  1527. 13022 postgres 20 0 8714M 1157M 1118M S 10.0 1.8 1:29.14 postgres: lsd lsd_rmis66 127.0.0.1(44832) idle
  1528. 14515 postgres 20 0 8692M 360M 342M S 10.0 0.6 0:01.21 postgres: lsd lsd_rmis66 127.0.0.1(44906) SELECT
  1529. 24709 postgres 20 0 8748M 5468M 5394M S 10.0 8.5 2:55.40 postgres: lsd lsd_rmis66 127.0.0.1(43844) SELECT
  1530. 23547 postgres 20 0 8725M 2640M 2590M S 10.0 4.1 8:33.51 postgres: lsd lsd_rmis66 127.0.0.1(43801) idle
  1531. 10536 postgres 20 0 9851M 9190M 8039M D 9.0 14.3 33:51.64 postgres: utl lsd_rmis66 127.0.0.1(38465) SELECT
  1532. 10446 postgres 20 0 8729M 8063M 8005M D 8.0 12.5 1h02:10 postgres: rep_slave lsd_rmis66 127.0.0.1(38454) SELECT
  1533. 3606 pgbouncer 20 0 21344 4728 540 S 7.0 0.0 4h53:47 /usr/bin/pgbouncer -d -q /etc/pgbouncer/pgbouncer.ini
  1534. 10899 postgres 20 0 8742M 7546M 7477M S 6.0 11.7 4:09.37 postgres: lsd lsd_rmis66 127.0.0.1(43198) idle
  1535. 24706 postgres 20 0 8747M 5040M 4968M S 3.0 7.8 1:50.64 postgres: lsd lsd_rmis66 127.0.0.1(43841) idle
  1536. 14534 root 20 0 111M 3140 1208 R 3.0 0.0 0:00.37 htop
  1537. 7638 postgres 20 0 8715M 1389M 1346M S 2.0 2.2 2:34.46 postgres: lsd lsd_rmis66 127.0.0.1(44574) idle
  1538. 24707 postgres 20 0 8761M 6219M 6139M S 2.0 9.7 2:14.28 postgres: lsd lsd_rmis66 127.0.0.1(43842) idle
  1539. 11876 postgres 20 0 8760M 4004M 3927M S 2.0 6.2 20:36.50 postgres: int lsd_rmis66 127.0.0.1(41749) SELECT
  1540. 5405 postgres 20 0 8715M 1574M 1535M S 1.0 2.4 3:34.83 postgres: lsd lsd_rmis66 127.0.0.1(44461) idle
  1541. 13955 postgres 20 0 8675M 2166M 2158M S 0.0 3.4 0:06.36 postgres: pcs lsd_rmis66 127.0.0.1(44881) idle
  1542. 7644 postgres 20 0 8720M 1323M 1282M S 0.0 2.1 2:28.87 postgres: lsd lsd_rmis66 127.0.0.1(44580) idle
  1543. 9359 postgres 39 19 9109M 121M 114M S 0.0 0.2 0:07.04 postgres: autovacuum worker process lsd_rmis66
  1544. 10076 postgres 20 0 8677M 5337M 5330M S 0.0 8.3 5:37.12 postgres: cas cas 127.0.0.1(38280) idle
  1545. 3540 postgres 39 19 8784M 245M 238M S 0.0 0.4 0:10.14 postgres: autovacuum worker process lsd_rmis66
  1546. F1Help F2Setup F3SearchF4FilterF5Tree F6SortByF7Nice -F8Nice +F9Kill F10Quit
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!