PostgreSQL: Backup and Restore DB

backup: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

restore:# mysql -u root -p[root_password] [database_name] < dumpfilename.sql

Count number of records in array:
db.data_records.count( { dataset_id: { $in: [ 2509, 2224, 2128, 2145, 2472, 2249 ] } } )

Count number of records NOT in array:
db.data_records.count( { dataset_id: { $nin: [ 2509, 2224, 2128, 2145, 2472, 2249...

SELECT table_schema 'DB Name', 
        round(Sum(data_length + index_length) / 1024 / 1024, 1) 'DB size in MB'
FROM   information_schema.tables 
GROUP  BY table_schema; 

SELECT table_schema "Data Base Name",
sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB",
sum( data_free )/ 1024 / 1024 "Free Space in MB"
FROM information_schema.TABLES
GROUP BY table_schema ;

\q;

sudo -u postgres psql

tar -zcvf archive-name.tar.gz directory-name

The resulting .tar.gz file is actually the product of two different things, tar basically just packages a group of files into a single file bundle but doesn’t offer compression on it’s own, thus t...