Differences

This shows you the differences between two versions of the page.

--- postgresql:backup [2008/07/14 16:04]
a created
+++ postgresql:backup [2012/05/17 08:36] (current)
greebo old revision restored
@@ Line 1: / Line 1: @@
 ====== PostgreSQL backup ======
-**example**
+<code bash| >
-   #!/bin/bash
+#!/bin/bash
-   CAS=`date +"%d.%m.%y %T"`
+CAS=`date +"%d.%m.%y %T"`
-   echo "Zacetek dumpanja: $CAS"
+echo "Zacetek dumpanja: $CAS"
-   echo "Zacetek dumpanja: $CAS" >> /var/log/postdump.err
+echo "Zacetek dumpanja: $CAS" >> /var/log/postdump.err
-   cd /var/backup/postgres
+cd /var/backup/postgres
-   rm -f *.sql.gz
+rm -f *.sql.gz
-   cd /var/lib/postgresql
+cd /var/lib/postgresql
-   for baza in `/bin/su -c "psql -l" postgres | tr -d ' ' | egrep -v "Name|-|Listofdatabases|rows|template0" | cut -f1 -d '|' | sed -e   '/^$/d'`
+for baza in `/bin/su -c "psql -l" postgres | tr -d ' ' | egrep -v "Name|-|Listofdatabases|rows|template0" | cut -f1 -d '|' | sed -e   '/^$/d'`
    do
       echo "Obdelujem bazo $baza"
@@ Line 18: / Line 18: @@
    done
-   CAS=`date +"%d.%m.%y %T"`
+CAS=`date +"%d.%m.%y %T"`
-   echo "Konec: $CAS"
+echo "Konec: $CAS"
-   echo "Konec: $CAS" >> /var/log/postdump.err
+echo "Konec: $CAS" >> /var/log/postdump.err
-   echo
+echo
-   echo >> /var/log/postdump.err
+echo >> /var/log/postdump.err
+</code>