Postgres Dump

[elexis_linux]

# backup: durch sh.backup erledigt

1. PGCLIENTENCODING='UNICODE' PGDATABASE=DBName pg_dump -Fp [-s] -O
-x -U hgkz > /home/leffe/sql/tmp_dump_1
2. grep -v "COMMENT ON SCHEMA"
< /home/leffe/sql/tmp_dump_1
> /home/leffe/sql/tmp_dump_2
3. iconv -f UTF-8 -t UTF-8 -c < /home/leffe/projects/hgkz/sql/tmp_dump_2
> /home/leffe/projects/hgkz/sql/vl_dump_utf8
4. auskommentieren: CREATE PROCEDURAL LANGUAGE plpgsql (-- !!!)
5. ctrl+r: ::regclass -> ''

# restore

6. su postgres
7. createdb 'DBName' -Eutf8 -OBenutzer
8. createlang plpgsql 'DBName'
9. PGDATABASE=hgkmedialib psql -q -U hgkz -v ON_ERROR_STOP=1
< /home/leffe/projects/hgkz/sql/vl_dump_utf8