Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
sql:postgresql:backup [2008/07/14 16:04] a removed |
— (current) | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== PostgreSQL ====== | ||
- | |||
- | ===== PostgreSQL backup ===== | ||
- | |||
- | **example** | ||
- | # | ||
- | | ||
- | echo " | ||
- | echo " | ||
- | cd / | ||
- | rm -f *.sql.gz | ||
- | cd / | ||
- | |||
- | for baza in `/bin/su -c "psql -l" postgres | tr -d ' ' | egrep -v " | ||
- | do | ||
- | echo " | ||
- | /bin/su -c " | ||
- | gzip -f --best $baza.sql | ||
- | mv $baza.sql.gz / | ||
- | done | ||
- | |||
- | | ||
- | echo " | ||
- | echo " | ||
- | echo | ||
- | echo >> / | ||
- | |||
- | ===== PostgreSQL Check Constraint Supports Regular Expressions ===== | ||
- | | ||
- | first_name VARCHAR(100) | ||
- | CONSTRAINT check_first_name | ||
- | ( first_name ~* ' | ||
- | ); | ||
- | |||
- | see: [[http:// |