From 318972c503849ca50a1fb62217ae713973108a43 Mon Sep 17 00:00:00 2001 From: Jonas Smedegaard Date: Sun, 11 Dec 2005 21:05:09 +0000 Subject: Avoid owner in Postgres dumps --- localdumpsql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'localdumpsql') diff --git a/localdumpsql b/localdumpsql index bb364fe..a6dabe4 100755 --- a/localdumpsql +++ b/localdumpsql @@ -3,7 +3,7 @@ # /usr/local/sbin/localdumpsql # Copyright 2001-2003 Jonas Smedegaard # -# $Id: localdumpsql,v 1.14 2003-11-20 15:15:39 jonas Exp $ +# $Id: localdumpsql,v 1.15 2005-12-11 21:05:09 jonas Exp $ # # MySQL/PostgreSQL maintenance script # @@ -68,7 +68,7 @@ function mysqldump_user_db() { $mysql_bin --add-drop-table --add-locks --all --q function postgresvalid() { [ -x $postgres_bin -a -x /usr/lib/postgresql/bin/pg_ctl ]; } function postgres_users() { echo "root"; } #FIXME function postgres_db_user() { if [ -n "$1" ]; then echo "$1"; else su -s /bin/sh postgres -c "/usr/bin/psql -t -c 'select datname from pg_database order by datname' -d template1 | sed -e 's/ //' | grep -v '^template[01]$'"; fi; } -function postgresdump_user_db() { su -s /bin/sh postgres -c "$postgres_bin $2"; } +function postgresdump_user_db() { su -s /bin/sh postgres -c "$postgres_bin -O $2"; } # Check for valid input for sqltype in $sqltypes; do -- cgit v1.2.3