PostgreSQL: List all users

sudo -u postgres psql

$ cat /etc/passwd

var collectionNames = db.getCollectionNames(), stats = [];
collectionNames.forEach(function (n) { stats.push(db[n].stats()); });
stats = stats.sort(function(a, b) { return b['size'] - a['size']; });
for (var c in stats) { print(sta...

1. Create the user

   $ adduser user_name

2. Give root privileges

   $ visudo

Add user to privileges

user_name ALL=(ALL:ALL) ALL

mysql>CREATE DATABASE memcachedSample;
mysql>CREATE USER 'web20'@'localhost' IDENTIFIED BY 'web20';
mysql>GRANT ALL PRIVILEGES ON memcachedSample.* TO 'web20'@'localhost';
mysql>exit;

Backup:
$ pg_dump -U {user-name} {source_db} -f {dumpfilename.sql}

Restore:
$ psql -U {user-name} -d {desintation_db}-f {dumpfilename.sql}

\q;

sudo passwd user_name