summaryrefslogtreecommitdiff
path: root/scripts/rebuilddb_psql.sh
diff options
context:
space:
mode:
authorCiaranG <ciaran@ciarang.com>2009-03-08 11:58:27 +0000
committerCiaranG <ciaran@ciarang.com>2009-03-08 11:58:27 +0000
commita89d7ceab0baeeaa4cc69684ae4c342a63814e2f (patch)
tree9ed29a2c807c2b11c85c7e005807b66f4a71ecbd /scripts/rebuilddb_psql.sh
parenta5b9f59cb235a05eaf74465d421508b4b8471488 (diff)
PostgreSQL - added equivalent of the MySQL-specific rebuilddb.sh script, for upgrading
Diffstat (limited to 'scripts/rebuilddb_psql.sh')
-rwxr-xr-xscripts/rebuilddb_psql.sh34
1 files changed, 34 insertions, 0 deletions
diff --git a/scripts/rebuilddb_psql.sh b/scripts/rebuilddb_psql.sh
new file mode 100755
index 000000000..ac169c205
--- /dev/null
+++ b/scripts/rebuilddb_psql.sh
@@ -0,0 +1,34 @@
+#!/bin/bash
+#
+# ******************************* WARNING *********************************
+# Do not run this script until you have read and understood the information
+# below, AND backed up your database. Failure to observe these instructions
+# may result in losing all the data in your database.
+#
+# This script is used to upgrade Laconica's PostgreSQL database to the
+# latest version. It does the following:
+#
+# 1. Dumps the existing data to /tmp/rebuilddb_psql.sql
+# 2. Clears out the objects (tables, etc) in the database schema
+# 3. Reconstructs the database schema using the latest script
+# 4. Restores the data dumped in step 1
+#
+# You MUST run this script as the 'postgres' user.
+# You MUST be able to write to /tmp/rebuilddb_psql.sql
+# You MUST specify the laconica database user and database name on the
+# command line, e.g. ./rebuilddb_psql.sh myuser mydbname
+#
+
+user=$1
+DB=$2
+
+cd `dirname $0`
+
+pg_dump -a -D --disable-trigger $DB > /tmp/rebuilddb_psql.sql
+psql -c "drop schema public cascade; create schema public;" $DB
+psql -c "grant all privileges on schema public to $user;" $DB
+psql $DB < ../db/laconica_pg.sql
+psql $DB < /tmp/rebuilddb_psql.sql
+for tab in `psql -c '\dts' $DB -tA | cut -d\| -f2`; do
+ psql -c "ALTER TABLE \"$tab\" OWNER TO $user;" $DB
+done