Re: pg_dump and grants to PUBLIC

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Blair Lowe <postgresql(at)zedemail(dot)ca>
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:57:48
Message-ID: 4464CC9C.7070108@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

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.

> - 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.

Sincerely,

Joshua D. Drake

--

=== 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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2006-05-12 18:02:27 Re: GUI Interface
Previous Message Blair Lowe 2006-05-12 17:55:42 Re: pg_dump and grants to PUBLIC