Scripts

Repositório com scripts de automatização de tarefas

REFERÊNCIAS:

PRINT OUTPUT OF SQL QUERY

• https://dba.stackexchange.com/questions/14770/access-columns-returned-by-psql-from-bash

GET DATABASE SIZE

• https://stackoverflow.com/questions/18907047/postgres-db-size-command

FORMATE DATE IN SHELL

• https://www.cyberciti.biz/faq/linux-unix-formatting-dates-for-display/

CREATE SHELL SCRIPT WITH FLAGS

• http://mywiki.wooledge.org/BashFAQ/035

MULTIPLICATE VALUES IN SHELL SCRIPT

• https://stackoverflow.com/questions/15213127/variables-multiplication

GET DISK SIZE IN BYTES

• https://superuser.com/questions/468194/partition-used-and-available-size-in-bytes

GETOPTS

• https://stackoverflow.com/questions/14447406/bash-shell-script-check-for-a-flag-and-grab-its-value

DUMP POSTGRESQL

• https://www.postgresql.org/docs/9.3/app-pgdump.html

PGPASS

• http://www.londatiga.net/it/database-it/how-to-use-postgresql-pgdump-in-crontab-without-password/

BASH HEADER

• http://code.activestate.com/recipes/577862-bash-script-to-create-a-header-for-bash-scripts/

GET ALL PARAMETERS EXCEPT FIRST

• https://stackoverflow.com/questions/9057387/process-all-arguments-except-the-first-one-in-a-bash-script

PASS OUTPUT TO COMMAND

• https://unix.stackexchange.com/questions/9597/giving-grep-output-to-rm

GET ONLY FILENAME FROM LS

• https://stackoverflow.com/questions/8518750/to-show-only-file-name-without-the-entire-directory-path

PG_DUMP WITHOUT OWNER

• https://coderwall.com/p/hy8jpa/dump-postgresql-without-owner-and-privileges

PG_DUMP INSERTS INSTEAD COPY

• https://stackoverflow.com/questions/2857989/using-pg-dump-to-only-get-insert-statements-from-one-table-within-database