So pg_dump does not work well in 7.3.4, and I have to pg_dump or the
global equivalent to upgrade to 7.4. A bit of a catch 22 in there.
No, because you will use the 7.4 dump to dump and restore to 7.4 from
the 7.3.
For full disclosure I run a consulting company for PostgreSQL but there
are many others on this list who I am sure would also be willing to help
you.
I also run a consulting company, I just have dumb questions before I
leap into chasms, that's all ;)
Been doing Database stuff for 16 years now and I still don't know it
all ;)
- is the underlying data structure the same, or are there some major
architectural changes that will toast existing applications?
I recall (I think) that a big difference between 7.3 and 7.4 is some
timestamp / timezone issues.
OK. Sounds like I am hosed until I build a new home for the clients so
that they can test the new environment (possibly postgreSQL v.8).
TTYL,
Blair.
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
