1 |
db=inncomm |
2 |
|
3 |
all: |
4 |
@echo dump,create,drop,insert,fill |
5 |
|
6 |
dump: |
7 |
pg_dump $(db) > $(db).sql |
8 |
|
9 |
create: |
10 |
createdb $(db) |
11 |
drop: |
12 |
psql -c "drop database $(db)" template1 |
13 |
|
14 |
insert: |
15 |
# psql $(db) < $(db).sql |
16 |
cat $(db).sql | sed 's/::text//' | sed 's/::bool//' | psql $(db) |
17 |
|
18 |
fill: drop create insert |
19 |
|
20 |
fill2: |
21 |
destroydb $(db)2 |
22 |
createdb $(db)2 |
23 |
psql $(db)2 < $(db).sql |
24 |
|
25 |
fix: |
26 |
pg_dump $(db) > $(db).sql |
27 |
destroydb $(db) |
28 |
# cat $(db).sql | sed 's/"unesen" timestamp/"unesen" timestamp default now()/' > $(db).sql.new |
29 |
cat $(db).sql | sed 's/character varying(30),/character varying(250),/' > $(db).sql.new |
30 |
createdb $(db) |
31 |
psql $(db) < polar.sql |
32 |
|