Franklin Anderson de O. Souza franklinbr
franklinbr
/ gist:8e8616a5ffaa2916864e
Created
October 7, 2015 14:58
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ProjudiPje (M:) | |
| Mais_antigo (N:) | |
| Geral (T:) | |
| Local Disk (R:) | |
| New Volume (K:) | |
| Helios_Antigo (O:) | |
| BkpDiversos_Antigo (Q:) | |
| Local Disk (S:) | |
franklinbr
/ postgresql log
Created
September 28, 2015 18:56
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 2015-09-28 09:57:13 AMT [839]: [27-1] user=usuario,db=BancoDeDados,app=[unknown],client=192.168.1.1 ERROR: relation "tb_log" does not exist at character 13 | |
| 2015-09-28 09:57:13 AMT [839]: [28-1] user=usuario,db=BancoDeDados,app=[unknown],client=192.168.1.1 STATEMENT: insert into tb_log (dt_log, ds_id_entidade, id_usuario, ds_ip, ds_entidade, ds_package, tp_operacao, id_pagina, id_log) values ($1, $2, $3, $4, $5, $6, $7, $8, $9) | |
| 2015-09-28 09:57:28 AMT [839]: [29-1] user=usuario,db=BancoDeDados,app=[unknown],client=192.168.1.1 ERROR: relation "tb_log" does not exist at character 13 | |
| 2015-09-28 09:57:28 AMT [839]: [30-1] user=usuario,db=BancoDeDados,app=[unknown],client=192.168.1.1 STATEMENT: insert into tb_log (dt_log, ds_id_entidade, id_usuario, ds_ip, ds_entidade, ds_package, tp_operacao, id_pagina, id_log) values ($1, $2, $3, $4, $5, $6, $7, $8, $9) | |
| 2015-09-28 09:57:38 AMT [822]: [1-1] user=usuario,db=BancoDeDados,app=[unknown],client=192.168.1.1 ERROR: relation "tb_log" does not exist at character 13 | |
| 20 |
franklinbr
/ foobar
Created
September 25, 2015 23:16
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Backups (J:) | |
| New Volume (K:) | |
| Backup AMS 01 (L:) | |
| ProjudiPJE_Antigo (M:) | |
| Maia_antigo(N:) | |
| Helios_Antigo(O:) | |
| Backup AMS 02(P:) | |
| BkpDiversos_Antigo(Q:) | |
| Local Disk (R:) | |
| Geral (T:) |
franklinbr
/ sql server
Created
September 17, 2015 19:38
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT DISTINCT | |
| ' a '+SUBSTRING(CAST(run_date AS VARCHAR(10)), 7,2) + '/' + SUBSTRING(CAST(run_date AS VARCHAR(10)), 5,2)+ '/' + SUBSTRING(CAST(run_date AS VARCHAR(10)), 1,4), | |
| +' aa '+CASE run_status WHEN 1 THEN '<span class="sucesso">Sucesso</span>' WHEN 0 THEN '<span class="falhou">Falhou</span>' WHEN 3 THEN '<span class="cancelado">Cancelado</span>' END, | |
| +' bb '+sj.name 'Job', | |
| +' cc '+(SELECT Min(message) FROM msdb.dbo.sysjobhistory A WHERE A.job_id = sj.job_id AND A.run_status IN (0,3)) | |
| FROM msdb.dbo.sysjobs sj | |
| INNER JOIN msdb.dbo.sysjobsteps sjs ON sjs.job_id = sj.job_id | |
| INNER JOIN msdb.dbo.sysjobhistory sjh ON sj.job_id = sjh.job_id | |
| AND CONVERT(VARCHAR(10), sjh.run_date, 112) >= CONVERT(VARCHAR(10), GETDATE()-1, 112) | |
| --order by run_date desc; |
franklinbr
/ blocked pg
Created
September 15, 2015 16:14
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT kl.pid AS blocking_pid, | |
| ka.usename AS blocking_user, | |
| ka.query AS blocking_query, | |
| bl.pid AS blocked_pid, | |
| a.usename AS blocked_user, | |
| a.query AS blocked_query, | |
| To_char(Age(Now(), a.query_start),'HH24h:MIm:SSs') AS age | |
| FROM pg_catalog.pg_locks bl | |
| JOIN pg_catalog.pg_stat_activity a | |
| ON bl.pid = a.pid |
franklinbr
/ saida log
Created
September 10, 2015 14:34
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Verificacoes Iniciais... | |
| Thu Sep 10 01:00:17 AMT 2015 - Iniciando backup - Precatorio... | |
| Thu Sep 10 01:01:26 AMT 2015 - Backup completo! | |
| Thu Sep 10 01:01:26 AMT 2015 - Iniciando compactacao - Precatorio... | |
| Precatorios.sql | |
| /root/scripts/rotina | |
| Thu Sep 10 01:07:26 AMT 2015 - Compactacao Concluida! | |
| Thu Sep 10 01:07:26 AMT 2015 - Conectando servidor sbd-backup... | |
| Thu Sep 10 01:07:26 AMT 2015 - Conexao efetuada! | |
| Thu Sep 10 01:07:26 AMT 2015 - Enviando compactacao para servidor de sbd-backup... |
franklinbr
/ postgresql log II
Created
August 27, 2015 18:28
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| < 2015-08-25 11:28:51.667 AMT >LOG: MultiXact member wraparound protections are now enabled | |
| < 2015-08-25 11:28:51.671 AMT >LOG: database system is ready to accept connections | |
| < 2015-08-25 11:28:51.671 AMT >LOG: autovacuum launcher started | |
| < 2015-08-25 12:04:13.951 AMT >LOG: database system was interrupted; last known up at 2015-08-25 11:40:52 AMT | |
| < 2015-08-25 12:04:13.966 AMT >LOG: starting archive recovery | |
| < 2015-08-25 12:04:13.986 AMT >LOG: restored log file "000000010000000000000007" from archive | |
| < 2015-08-25 12:04:13.988 AMT >LOG: redo starts at 0/7000100 | |
| < 2015-08-25 12:04:13.989 AMT >LOG: consistent recovery state reached at 0/70001C8 | |
| < 2015-08-25 12:04:14.007 AMT >LOG: restored log file "000000010000000000000008" from archive | |
| < 2015-08-25 12:04:14.217 AMT >LOG: restored log file "000000010000000000000009" from archive |
franklinbr
/ convert2html.sh
Created
August 26, 2015 19:12
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| if [ $# -gt 0 ] | |
| then | |
| arquivo="$1.html" | |
| cat /dev/null > ${arquivo} | |
| echo "<html>" >> ${arquivo} | |
| echo "<head>" >> ${arquivo} | |
| echo "<meta charset=\"UTF-8\">" >> ${arquivo} |
franklinbr
/ postgresql log
Created
August 24, 2015 23:01
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| < 2015-08-24 18:41:02.431 AMT >LOG: starting archive recovery | |
| < 2015-08-24 18:41:02.455 AMT >LOG: restored log file "000000010000000000000007" from archive | |
| < 2015-08-24 18:41:02.457 AMT >LOG: redo starts at 0/7000028 | |
| < 2015-08-24 18:41:02.458 AMT >LOG: consistent recovery state reached at 0/70088B8 | |
| < 2015-08-24 18:41:02.477 AMT >LOG: restored log file "000000010000000000000008" from archive | |
| < 2015-08-24 18:41:02.687 AMT >LOG: restored log file "000000010000000000000009" from archive | |
| < 2015-08-24 18:41:02.907 AMT >LOG: restored log file "00000001000000000000000A" from archive | |
| < 2015-08-24 18:41:03.124 AMT >LOG: restored log file "00000001000000000000000B" from archive | |
| < 2015-08-24 18:41:03.341 AMT >LOG: restored log file "00000001000000000000000C" from archive | |
| cp: cannot stat `/backup/postgresql/archive/00000001000000000000000D': No such file or directory |
franklinbr
/ log pg
Created
August 24, 2015 22:44
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| < 2015-08-24 18:16:05.454 AMT >LOG: MultiXact member wraparound protections are now enabled | |
| < 2015-08-24 18:16:05.455 AMT >LOG: autovacuum launcher started | |
| < 2015-08-24 18:16:05.455 AMT >LOG: database system is ready to accept connections | |
| < 2015-08-24 18:41:02.413 AMT >LOG: database system was interrupted; last known up at 2015-08-24 18:22:55 AMT | |
| < 2015-08-24 18:41:02.431 AMT >LOG: starting archive recovery | |
| < 2015-08-24 18:41:02.455 AMT >LOG: restored log file "000000010000000000000007" from archive | |
| < 2015-08-24 18:41:02.457 AMT >LOG: redo starts at 0/7000028 | |
| < 2015-08-24 18:41:02.458 AMT >LOG: consistent recovery state reached at 0/70088B8 | |
| < 2015-08-24 18:41:02.477 AMT >LOG: restored log file "000000010000000000000008" from archive | |
| < 2015-08-24 18:41:02.687 AMT >LOG: restored log file "000000010000000000000009" from archive |