Differences from version 12 to 14



@@ -1,4 +1,4 @@

-{attachment id=1059 float=right} This is a permutation of the original pg_backup script as written by speedboy_420. I have made changes to allow for environment variables to make backups of a remote host, change backup direct via ENV variable, as well as use bzip2 for all compression.
+{attachment id=1059 float=right} This is a permutation of the original pg_backup script as written by speedboy_420. I have made changes to allow for environment variables to make backups of a remote host, change backup directory via ENV variable, as well as use bzip2 for all compression.
 
 There is also a [https://gist.github.com/546865/117f1831b695bf5f0c8a60d093aa8f00dceca04c|github gist repo] for this file.
 

@@ -285,9 +285,9 @@

 db_connectivity() {
  tmp=`echo "($exclusions)" | sed 's/\ /\|/g'`
  if [ "$exclusions" = "" ]; then
- databases=`$PGBINDIR/psql $PARAM_PGHOST -U $PGUSER -q -c "\l" template1 | sed -n 4,/\eof/p | grep -v rows\) | grep -v : | awk {'print $1'} || echo "Database connection could not be established at $timeinfo" >> $PGLOGDIR`
+ databases=`$PGBINDIR/psql $PARAM_PGHOST -U $PGUSER -q -c "SELECT datname FROM pg_database WHERE datistemplate = false" template1 | sed -n 4,/\eof/p | grep -v rows\) | grep -v : | awk {'print $1'} || echo "Database connection could not be established at $timeinfo" >> $PGLOGDIR`
  else
- databases=`$PGBINDIR/psql $PARAM_PGHOST -U $PGUSER -q -c "\l" template1 | sed -n 4,/\eof/p | grep -v rows\) | grep -v : | grep -Ev $tmp | awk {'print $1'} || echo "Database connection could not be established at $timeinfo" >> $PGLOGDIR`
+ databases=`$PGBINDIR/psql $PARAM_PGHOST -U $PGUSER -q -c "SELECT datname FROM pg_database WHERE datistemplate = false" template1 | sed -n 4,/\eof/p | grep -v rows\) | grep -v : | grep -Ev $tmp | awk {'print $1'} || echo "Database connection could not be established at $timeinfo" >> $PGLOGDIR`
  fi
 }
 
Page History
Date/CommentUserIPVersion
03 Sep 2013 (12:55 UTC)
spiderr24.106.202.12314
Current • Source
spiderr24.106.202.12313
View • Compare • Difference • Source
spiderr24.106.202.12312
View • Compare • Difference • Source
spiderr174.97.129.25511
View • Compare • Difference • Source
spiderr174.97.129.2559
View • Compare • Difference • Source
spiderr174.97.129.2558
View • Compare • Difference • Source
spiderr65.190.141.137
View • Compare • Difference • Source
spiderr65.190.141.136
View • Compare • Difference • Source
spiderr65.190.141.134
View • Compare • Difference • Source
spiderr66.194.217.2212
View • Compare • Difference • Source