https://www.postgresqltutorial.com/how-to-delete-duplicate-rows-in-postgresql/
Arquivo da categoria: Banco de Dados
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-1MongoDB user dando permissão
db.createUser({
user: '<user>',
pwd: '<password>',
roles: ["userAdminAnyDatabase",
"dbAdminAnyDatabase",
"readWriteAnyDatabase"]
})