Databases
PostgreSQL¶
Shell¶
Check full quick cheat
\l
list tables\c database
\dt
list tables
sudo -i -u postgres
Create dump¶
pg_dump dbname > outfile
pg_dumpall > outfile
pg_dump dbname | gzip > filename.gz # Large database
Restore dump¶
psql dbname < infile
gunzip -c filename.gz | psql dbname # Large database
MongoDB¶
Authentication¶
use admin
db.auth('admin', 'xxx')
db.createUser({
user: "admin",
pwd: "admin",
roles: [
{"role": "userAdminAnyDatabase", "db": "admin"},
{"role": "dbAdminAnyDatabase", "db": "admin"},
{"role": "readWriteAnyDatabase", "db": "admin"}
]
}
With IP restriction
db.createUser({
user: "db",
pwd: "xxx",
roles: [ { role: "readWrite", db: "db" }],
authenticationRestrictions: [
{
clientSource: ["xxx.xxx.xxx.0/24", "127.0.0.1"]
}
]
})
Copy dump¶
db.runCommand({ copydb:1, fromhost: '127.0.0.1', fromdb: 'db', todb:'db'})`