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
| aom | |
| bdw-gc | |
| brotli | |
| c-ares | |
| cairo | |
| clang-format | |
| docbook | |
| docbook-xsl | |
| docker | |
| fontconfig |
gusdewa
/ pg_dump_restore.sql
Last active
August 9, 2021 08:15
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
| pg_dump -h hostname -p 5432 -U username -Fc dbname > dbname_$(date +"%Y-%m-%d").dump | |
| -- WITH CERT | |
| pg_dump "port=<port> host=<host> user=<user> dbname=<db> sslcert=<cert> sslkey=<key> sslrootcert=<ca.crt> sslmode=verify-ca" -Fc > dbname_$(date +"%Y-%m-%d").dump | |
| pg_restore -U username -d dbname_target -h hostname -p 5432 --disable-triggers filebackup.dump |
gusdewa
/ get_all_functions.sql
Last active
June 16, 2021 05:36
Postgres List All Functions with Parameters
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 | |
| routines.routine_name, | |
| parameters.data_type, | |
| parameters.ordinal_position | |
| FROM | |
| information_schema.routines | |
| LEFT JOIN information_schema.parameters ON | |
| routines.specific_name = parameters.specific_name | |
| WHERE | |
| routines.specific_schema = 'public' |
gusdewa
/ windows-choco
Created
November 20, 2017 15:11
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
| @"%SystemRoot%\System32\WindowsPowerShell\v1.0\powershell.exe" -NoProfile -InputFormat None -ExecutionPolicy Bypass -Command "iex ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1'))" && SET "PATH=%PATH%;%ALLUSERSPROFILE%\chocolatey\bin" | |
| choco feature enable -n=allowGlobalConfirmation | |
| cup googlechrome adobereader firefox 7zip.install notepadplusplus.install vlc git.install nodejs.install putty.install powershell ruby visualstudiocode paint.net github python fiddler calibre 7zip yarn cmder foobar2000 | |