https://serverfault.com/questions/285219/pgpass-with-postgresql-not-working/914090
https://stackoverflow.com/questions/16786011/postgresql-pgpass-not-working
Arquivo da categoria: Banco de Dados
Loop on tables with PL/pgSQL in Postgres 9.0+
How To Delete Duplicate Rows in PostgreSQL
PostgreSQL ODBC Driver (psqlODBC) connection strings
GTID_PURGED variable makes mysql dump non backward compatible
Rails + Postgres drop error: database is being accessed by other users
Easy and scalable solution for mysql database backup to AWS S3 bucket
Mysql2::Error: Out of sort memory, consider increasing server sort buffer size using docker-compose.yml
[MY-013131] [Server] Out of sort memory, consider increasing server sort buffer size!
SET GLOBAL sort_buffer_size = 1024 * 1024 * 4;DUMP do MongoDB
mongodump --host $HOST --port 27017 --username $USER --db $DB_NAME --password $PASSWORD --out $BACKUPROOT --authenticationDatabase admin --authenticationMechanism SCRAM-SHA-1