diff options
Diffstat (limited to 'dumpfm/postgres_init.sh')
| -rw-r--r-- | dumpfm/postgres_init.sh | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/dumpfm/postgres_init.sh b/dumpfm/postgres_init.sh new file mode 100644 index 0000000..7bd6cc8 --- /dev/null +++ b/dumpfm/postgres_init.sh @@ -0,0 +1,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 + |