[rt-devel] Postgres, bytea and my ruined evening.

[Vivek Khera]

>>>>> "JV" == Jesse Vincent <jesse at bestpractical.com> writes:

JV> Also, for the upgrade instructions, what's the recommended
JV> postgres procedure for "dump all data, _but not the schema_ from
JV> this database to a file on disk and then reload it"?

Well, to survive reordering of columns, the only real way to do it is
with "pg_dump --attribute-inserts --data-only" then loading the result
via psql after the new schema has been created.

This will dump full SQL insert clauses, and include necessary trigger
disabling so that foreign keys won't be tested per insert.