initdb --locale en_US.UTF-8 -E UTF8 -D '/mnt/sdb1/DUMPFM_BACKUP/pg' postgres -D /mnt/sdb1/DUMPFM_BACKUP/pg #fix whatever issues with permissions #createdb dumpfm #createuser postgres #psql ... # # # #REVOKE CONNECT ON DATABASE dumpfm FROM PUBLIC; GRANT CONNECT ON DATABASE database_name TO postgres; #psql -U postgres -d dumpfm < /mnt/sdb1/DUMPFM_BACKUP/dumpfmpgsql-1444088905.sql