Commit2fc0487

committed

Allow pg_dumpall to preserve database ownership.

1 parent029873a commit2fc0487Copy full SHA for 2fc0487

File tree

-3

lines changed

-3

lines changed

Lines changed: 4 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -5,18 +5,19 @@`
`5`	`5`	`# It also dumps the pg_user table`
`6`	`6`	`#`
`7`	`7`	`# to adapt to System V vs. BSD 'echo'`
`8`		`-set -x`
	`8`	`+#set -x`
`9`	`9`	`ifecho'\\'\| grep'\\\\'>/dev/null2>&1`
`10`	`10`	`then`
`11`	`11`	`BS='\'# BSD`
`12`	`12`	`else`
`13`	`13`	`BS='\\'# System V`
`14`	`14`	`fi`
`15`		`-psql -l -A -q -t\|cut -d"\|" -f1\| grep -v'^template1$'\| \`
`16`		`-whileread DATABASE`
	`15`	`+psql -l -A -q -t\|cut -d"\|" -f1-2\|tr'\|'''\|grep -v'^template1'\| \`
	`16`	`+whileread DATABASE USER`
`17`	`17`	`do`
`18`	`18`	`echo"${BS}connect template1"`
`19`	`19`	`echo"create database$DATABASE;"`
	`20`	`+echo"update pg_database set datdba =$USER where datname = '$DATABASE';"`
`20`	`21`	`echo"${BS}connect$DATABASE"`
`21`	`22`	`pg_dump"$@"$DATABASE`
`22`	`23`	`done`

Comments

(0)