Search Postgresql Archives

Re: pg_dump and grants to PUBLIC

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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/




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux