Sunday, December 23, 2012

postgresql backup per table

 for a in `psql nextg_dei3 -t -c "select  table_name from information_schema.tables where table_type='BASE TABLE' and table_catalog='nextg_dei3' and table_schema='public'"`; do echo $a; pg_dump -t $a nextg_dei3 -f $a.sql 2> error/$a.txt;  done

Tuesday, December 18, 2012

BASH: SPLIT STRING INTO ARRAY


$ IFS=';' read -a array <<< "abc;def;ghi"
$ echo "${array[2]}"
ghi



Monday, December 17, 2012

17 Dec 2012

setelah,
bertahun,
3tahun?

dan setelah sedikit proses, per hari ini mulai lagi

dan

missing chunk number 0 for toast value