dumpfm/postgres_init.sh


1
2
3
4
5
6
7
8
9
10
11
12
13

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