diff options
| author | pepperpepperpepper <pepper@scannerjammer.com> | 2015-10-06 20:02:47 -0700 |
|---|---|---|
| committer | pepperpepperpepper <pepper@scannerjammer.com> | 2015-10-06 20:02:47 -0700 |
| commit | 55636242fb42009fac80656ad5106ad2717bcd75 (patch) | |
| tree | ef9d35ac0a116028130be79589d2ebaf3f620892 /dumpfm/postgres_init.sh | |
| parent | 94e22c38100bd68cecaf770241a607d065192b29 (diff) | |
added some new scripts
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 + |