7 |
dump: |
dump: |
8 |
pg_dump $(db) > $(db).sql |
pg_dump $(db) > $(db).sql |
9 |
|
|
10 |
|
dump-shema: |
11 |
|
pg_dump -s $(db) > $(db)-shema.sql |
12 |
|
|
13 |
create: |
create: |
14 |
createdb $(db) |
createdb $(db) |
15 |
drop: |
drop: |
26 |
createdb $(db)2 |
createdb $(db)2 |
27 |
cat $(db).sql | sed 's/::text//' | sed 's/::bool//' | psql $(db)2 |
cat $(db).sql | sed 's/::text//' | sed 's/::bool//' | psql $(db)2 |
28 |
|
|
29 |
dist: |
dist2portal: |
30 |
psql -h $(portal) -c "drop database $(db)" template1 |
# psql -h $(portal) -c "drop database $(db)" template1 |
31 |
psql -h $(portal) -c "create database $(db)" template1 |
# psql -h $(portal) -c "create database $(db)" template1 |
32 |
pg_dump $(db) | sed 's/::text//' | sed 's/::bool//' | sed 's/ \([01][0-9]\)-\([0123][0-9]\)-\([12][0-9][0-9][0-9]\) / \2-\1-\3 /g' | sed 's,/usr/lib/pgsql/,/usr/lib/postgresql/lib/,g' | psql -h $(portal) $(db) |
# pg_dump $(db) | sed 's/::text//' | sed 's/::bool//' | sed 's/ \([01][0-9]\)-\([0123][0-9]\)-\([12][0-9][0-9][0-9]\) / \2-\1-\3 /g' | sed 's,/usr/lib/pgsql/,/usr/lib/postgresql/lib/,g' | psql -h $(portal) $(db) |
33 |
|
|
34 |
dist2: |
dist2test: |
35 |
pg_dump $(db) | sed 's/::text//' | sed 's/::bool//' > $(db)-dist.sql |
psql -c "drop database $(db)" template1 |
36 |
scp $(db)-dist.sql $(portal):/tmp |
psql -c "create database $(db)" template1 |
37 |
ssh $(portal) 'psql -c "drop database $(db)" template1 ; createdb $(db); cd /tmp ; psql $(db) < $(db)-dist.sql' |
|
38 |
|
# pg_dump -h $(portal) $(db) | \ |
39 |
|
|
40 |
|
ssh portal "pg_dump $(db)" | \ |
41 |
|
sed -e 's/::"*text"*//gi' -e 's/::"*bool"*//gi' -e 's/::"*varchar"*//gi' -e 's/::"*bpchar"*//gi' |\ |
42 |
|
sed 's/ \([01][0-9]\)-\([0123][0-9]\)-\([12][0-9][0-9][0-9]\) / \2-\1-\3 /g' | sed 's,/usr/lib/pgsql/,/usr/lib/postgresql/lib/,g' | psql $(db) |
43 |
|
|
44 |
|
|