gusdewa

aom
bdw-gc
brotli
c-ares
cairo
clang-format
docbook
docbook-xsl
docker
fontconfig

gusdewa

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

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

@"%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