On Fri, 2006-12-05 at 10:57 -0700, Joshua D. Drake wrote: > Blair Lowe wrote: > > On Fri, 2006-12-05 at 10:51 -0700, Joshua D. Drake wrote: > >>>> user# pg_dump -n <schema_name> > tmp95.sql > >>>> pg_dump: invalid option -- n > >>>> Try 'pg_dump --help' for more information. > >>>> > >>>> phpbb only works with version 7.x. > >> > >> Oh... if you are running 7.3 your pretty much hosed... You need to > >> upgrade to 7.4 at a minimum. > >> > > > > Sounds doable. Will such an upgrade hose all my client's stuff, or will > > a simple rpm -Fvh, and a /etc/init.d/postgreSQL restart do it? > > Ehhh. no. You will need to do a full dump, install 7.4 and restore. I > strongly suggest that you use a consultant for this you don't want to > make a mistake. 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. > > 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.
