Re: pg_dump and grants to PUBLIC

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.