X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=scripts%2Frebuilddb_psql.sh;h=6b15b9212fb3435a059150a791e42e94afd12ea8;hb=122c8677b7004bae4cfe7e2bd49fc1bc3187c72c;hp=9ade515ad719ecf3a8400e174819a2566961e2d0;hpb=99e3b1723bf7d1ece312dd9c3431fa997c6a22b2;p=quix0rs-gnu-social.git diff --git a/scripts/rebuilddb_psql.sh b/scripts/rebuilddb_psql.sh index 9ade515ad7..6b15b9212f 100755 --- a/scripts/rebuilddb_psql.sh +++ b/scripts/rebuilddb_psql.sh @@ -15,7 +15,7 @@ # # 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 +# You MUST specify the statusnet database user and database name on the # command line, e.g. ./rebuilddb_psql.sh myuser mydbname # @@ -27,7 +27,7 @@ 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 < ../db/statusnet_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