Re: pg_dump and grants to PUBLIC

From: Blair Lowe <postgresql(at)zedemail(dot)ca>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: aklaver(at)comcast(dot)net, pgsql-general(at)postgresql(dot)org, Martijn van Oosterhout <kleptog(at)svana(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: pg_dump and grants to PUBLIC
Date: 2006-05-12 17:55:42
Message-ID: 1147456542.5517.4.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

ie:
- are there any .conf files that will be overwritten (this might be an
RPM issue)?

- is the underlying data structure the same, or are there some major
architectural changes that will toast existing applications?

Thanks,
Blair.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2006-05-12 17:57:48 Re: pg_dump and grants to PUBLIC
Previous Message Joshua D. Drake 2006-05-12 17:51:05 Re: pg_dump and grants to PUBLIC