Hi,
because of a local Linux distro update (RHL 6.2 to 7.2) and therefore
a DB change from PG 6.5 to 7.1 I had to migrate the data from old DB
to new.
Looks like pg_dump'ed data in 6.5 cannot be restored in 7.1 therefore
I wrote 2 small Perl programs.
"dump_universal_phpVideoPro.pl" dumps a phpVideoPro DB in a "xml"
like scheme, currently only supported PG 6.5
"restore_universal_phpVideoPro.pl" restores the phpVideoPro DB from
"xml" like dump, currently only supported/tested PG 7.1.
Known bugs: the sequence ids must be set using "psql", the update via
the Perl program doesn't work (don't know why).
To Izzy: perhaps you add something like such "export/import from/to
universal format" so people can run backups and DB type moving
(PG<->MySQL,...) , too.
Hope this helps,
Peter |