pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Upgrading from 7.4 to 8.2
9+ messages / 6 participants
[nested] [flat]

* Upgrading from 7.4 to 8.2
@ 2006-12-19 09:03 Rickard Sjöström <rickard.sjostrom@bluebottle.com>
  0 siblings, 0 replies; 9+ messages in thread

From: Rickard Sjöström @ 2006-12-19 09:03 UTC (permalink / raw)
  To: pgsql-admin

Hi!
I have PostgreSQL 7.4 DBM and want to upgrade to 8.2 (latest in version 8 I quess).

Can use the DATADIR from 7.4 and just upgrade the DBM/postgresql server to 8.2?

Is the upgrade from 7 to 8 procedure written down somewhere? (could not find anyting at http://www.postgresql.org/docs/techdocs.2, except from 6 to 7)

I guess I could dump all my data and restore it later but it would be much nicer if it was possible to just start a new PostgreSQL server with the old DATADIR repository!

Thanks!

/Rick

----------------------------------------------------------------------
Diamond Ring Auctions at Bidz!
Engagement rings auctioned daily. Every 5 seconds, starting at $1!
http://tags.bluebottle.com/fc/BgLEQfJCfpRhST38x1THooDD28i6CkYTg1zn/




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Upgrading from 7.4 to 8.2
@ 2006-12-19 09:29 Matthias.Pitzl@izb.de
  2006-12-19 15:17 ` Re: Upgrading from 7.4 to 8.2 Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
  0 siblings, 1 reply; 9+ messages in thread

From: Matthias.Pitzl@izb.de @ 2006-12-19 09:29 UTC (permalink / raw)
  To: rickard.sjostrom@bluebottle.com; pgsql-admin

Hi Rickard!

As far as i know you will have to dump and restore the databases for the
upgrade since a lot of internals have been changed from 7.4 to 8.2.
A description on how to upgrade can be found here:
http://www.postgresql.org/docs/8.2/interactive/install-upgrading.html
And here: http://www.postgresql.org/docs/8.2/interactive/migration.html

Good luck!

Greetings,
Matthias

> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org 
> [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of 
> Rickard Sjöström
> Sent: Tuesday, December 19, 2006 10:04 AM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] Upgrading from 7.4 to 8.2
> 
> 
> Hi!
> I have PostgreSQL 7.4 DBM and want to upgrade to 8.2 (latest 
> in version 8 I quess).
> 
> Can use the DATADIR from 7.4 and just upgrade the 
> DBM/postgresql server to 8.2?
> 
> Is the upgrade from 7 to 8 procedure written down somewhere? 
> (could not find anyting at 
> http://www.postgresql.org/docs/techdocs.2, > except from 6 to 
> 7)
> 
> I guess I could dump all my data and restore it later but it 
> would be much nicer if it was possible to just start a new 
> PostgreSQL server with the old DATADIR repository!
> 
> Thanks!
> 
> /Rick
> 
> ----------------------------------------------------------------------
> Diamond Ring Auctions at Bidz!
> Engagement rings auctioned daily. Every 5 seconds, starting at $1!
> http://tags.bluebottle.com/fc/BgLEQfJCfpRhST38x1THooDD28i6CkYTg1zn/
> 
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
> 



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Upgrading from 7.4 to 8.2
  2006-12-19 09:29 Re: Upgrading from 7.4 to 8.2 Matthias.Pitzl@izb.de
@ 2006-12-19 15:17 ` Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
  2006-12-19 16:59   ` Re: Upgrading from 7.4 to 8.2 Rickard Sjöström <rickard.sjostrom@bluebottle.com>
  2006-12-19 17:32   ` Re: Upgrading from 7.4 to 8.2 Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
  0 siblings, 2 replies; 9+ messages in thread

From: Rajesh Kumar Mallah @ 2006-12-19 15:17 UTC (permalink / raw)
  To: Matthias.Pitzl@izb.de <Matthias.Pitzl@izb.de>; +Cc: rickard.sjostrom@bluebottle.com; pgsql-admin

Dear Rickard,

The jump from 7.4 to 8.2 is rather big.
I would suggest doing just a dry run by  dumping
the database schema without data and restoring it
into 8.2 database . this can be time saving in detecting
possible problems in migration.

in case there is some non trivial problem
you may take intermediate path of upgrading
7.4-->8.0.x-->8.1.x -->8.2.0
where x denotes the last minor release of a major
release.

regds
mallah.


On 12/19/06, Matthias.Pitzl@izb.de <Matthias.Pitzl@izb.de> wrote:
> Hi Rickard!
>
> As far as i know you will have to dump and restore the databases for the
> upgrade since a lot of internals have been changed from 7.4 to 8.2.
> A description on how to upgrade can be found here:
> http://www.postgresql.org/docs/8.2/interactive/install-upgrading.html
> And here: http://www.postgresql.org/docs/8.2/interactive/migration.html
>
> Good luck!
>
> Greetings,
> Matthias
>
> > -----Original Message-----
> > From: pgsql-admin-owner@postgresql.org
> > [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of
> > Rickard Sjöström
> > Sent: Tuesday, December 19, 2006 10:04 AM
> > To: pgsql-admin@postgresql.org
> > Subject: [ADMIN] Upgrading from 7.4 to 8.2
> >
> >
> > Hi!
> > I have PostgreSQL 7.4 DBM and want to upgrade to 8.2 (latest
> > in version 8 I quess).
> >
> > Can use the DATADIR from 7.4 and just upgrade the
> > DBM/postgresql server to 8.2?
> >
> > Is the upgrade from 7 to 8 procedure written down somewhere?
> > (could not find anyting at
> > http://www.postgresql.org/docs/techdocs.2, > except from 6 to
> > 7)
> >
> > I guess I could dump all my data and restore it later but it
> > would be much nicer if it was possible to just start a new
> > PostgreSQL server with the old DATADIR repository!
> >
> > Thanks!
> >
> > /Rick
> >
> > ----------------------------------------------------------------------
> > Diamond Ring Auctions at Bidz!
> > Engagement rings auctioned daily. Every 5 seconds, starting at $1!
> > http://tags.bluebottle.com/fc/BgLEQfJCfpRhST38x1THooDD28i6CkYTg1zn/
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 5: don't forget to increase your free space map settings
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Upgrading from 7.4 to 8.2
  2006-12-19 09:29 Re: Upgrading from 7.4 to 8.2 Matthias.Pitzl@izb.de
  2006-12-19 15:17 ` Re: Upgrading from 7.4 to 8.2 Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
@ 2006-12-19 16:59   ` Rickard Sjöström <rickard.sjostrom@bluebottle.com>
  2006-12-19 21:40     ` Re: Upgrading from 7.4 to 8.2 Chris Hoover <revoohc@gmail.com>
  2006-12-20 21:10     ` Re: Upgrading from 7.4 to 8.2 Bruno Wolff III <bruno@wolff.to>
  1 sibling, 2 replies; 9+ messages in thread

From: Rickard Sjöström @ 2006-12-19 16:59 UTC (permalink / raw)
  To: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>; +Cc: Matthias.Pitzl@izb.de <Matthias.Pitzl@izb.de>; rickard.sjostrom@bluebottle.com; pgsql-admin

Hi!
Thanks for your replies!

My problem is that I want to move the DBM to a different machine so now when it doesn't seem to be any easy/trivial way to migrate from 7.4 to 8.2 I might consider to continue with 7.4.

If I decide to continue with 7.4 I guess the procedure to move the DATADIR to the new machine and then start the postgresql server there with the old DATADIR should work without problems?

Thanks, again!

/Rickard

Citerar Rajesh Kumar Mallah <mallah.rajesh@gmail.com>:

> Dear Rickard,
> 
> The jump from 7.4 to 8.2 is rather big.
> I would suggest doing just a dry run by  dumping
> the database schema without data and restoring it
> into 8.2 database . this can be time saving in detecting
> possible problems in migration.
> 
> in case there is some non trivial problem
> you may take intermediate path of upgrading
> 7.4-->8.0.x-->8.1.x -->8.2.0
> where x denotes the last minor release of a major
> release.
> 
> regds
> mallah.
> 
> 
> On 12/19/06, Matthias.Pitzl@izb.de <Matthias.Pitzl@izb.de> wrote:
> > Hi Rickard!
> >
> > As far as i know you will have to dump and restore the databases
> for the
> > upgrade since a lot of internals have been changed from 7.4 to
> 8.2.
> > A description on how to upgrade can be found here:
> >
> http://www.postgresql.org/docs/8.2/interactive/install-upgrading.html
> > And here:
> http://www.postgresql.org/docs/8.2/interactive/migration.html
> >
> > Good luck!
> >
> > Greetings,
> > Matthias
> >
> > > -----Original Message-----
> > > From: pgsql-admin-owner@postgresql.org
> > > [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of
> > > Rickard Sjöström
> > > Sent: Tuesday, December 19, 2006 10:04 AM
> > > To: pgsql-admin@postgresql.org
> > > Subject: [ADMIN] Upgrading from 7.4 to 8.2
> > >
> > >
> > > Hi!
> > > I have PostgreSQL 7.4 DBM and want to upgrade to 8.2 (latest
> > > in version 8 I quess).
> > >
> > > Can use the DATADIR from 7.4 and just upgrade the
> > > DBM/postgresql server to 8.2?
> > >
> > > Is the upgrade from 7 to 8 procedure written down somewhere?
> > > (could not find anyting at
> > > http://www.postgresql.org/docs/techdocs.2, > except from 6 to
> > > 7)
> > >
> > > I guess I could dump all my data and restore it later but it
> > > would be much nicer if it was possible to just start a new
> > > PostgreSQL server with the old DATADIR repository!
> > >
> > > Thanks!
> > >
> > > /Rick
> > >
> > >
> ----------------------------------------------------------------------
> > > Diamond Ring Auctions at Bidz!
> > > Engagement rings auctioned daily. Every 5 seconds, starting at
> $1!
> > >
> http://tags.bluebottle.com/fc/BgLEQfJCfpRhST38x1THooDD28i6CkYTg1zn/
> > >
> > >
> > > ---------------------------(end of
> > > broadcast)---------------------------
> > > TIP 5: don't forget to increase your free space map settings
> > >
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 1: if posting/reading through Usenet, please send an
> appropriate
> >       subscribe-nomail command to majordomo@postgresql.org so
> that your
> >       message can get through to the mailing list cleanly
> >
>

----------------------------------------------------------------------
Free Debt Consolidation Quote
FCCC offers free counseling & debt consolidation quote. No setup fee!
http://tags.bluebottle.com/fc/BgLEQfI7q8COE6YTwzNhNIsdKPTGDJaJS3gO/




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Upgrading from 7.4 to 8.2
  2006-12-19 09:29 Re: Upgrading from 7.4 to 8.2 Matthias.Pitzl@izb.de
  2006-12-19 15:17 ` Re: Upgrading from 7.4 to 8.2 Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
  2006-12-19 16:59   ` Re: Upgrading from 7.4 to 8.2 Rickard Sjöström <rickard.sjostrom@bluebottle.com>
@ 2006-12-19 21:40     ` Chris Hoover <revoohc@gmail.com>
  2006-12-19 21:45       ` Re: Upgrading from 7.4 to 8.2 Joshua D. Drake <jd@commandprompt.com>
  1 sibling, 1 reply; 9+ messages in thread

From: Chris Hoover @ 2006-12-19 21:40 UTC (permalink / raw)
  To: Rickard Sjöström <rickard.sjostrom@bluebottle.com>; +Cc: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>; Matthias.Pitzl@izb.de <Matthias.Pitzl@izb.de>; pgsql-admin

Very easy,

Install the new version of PostgreSQL on your new machine.  Then use the new
machine's install to pg_dump the old machine's database and load it into the
new machine (obviously, the machines must be table to talk to each other
over the network).  Very easy.  That is how I upgraded all of my servers
from 7.3.4 to 8.1.3. (An upgrade that went very smoothly with no hiccups.)

HTH,

Chris

On 12/19/06, Rickard Sjöström <rickard.sjostrom@bluebottle.com> wrote:
>
> Hi!
> Thanks for your replies!
>
> My problem is that I want to move the DBM to a different machine so now
> when it doesn't seem to be any easy/trivial way to migrate from 7.4 to 8.2I might consider to continue with
> 7.4.
>
> If I decide to continue with 7.4 I guess the procedure to move the DATADIR
> to the new machine and then start the postgresql server there with the old
> DATADIR should work without problems?
>
> Thanks, again!
>
> /Rickard
>
> Citerar Rajesh Kumar Mallah <mallah.rajesh@gmail.com>:
>
> > Dear Rickard,
> >
> > The jump from 7.4 to 8.2 is rather big.
> > I would suggest doing just a dry run by  dumping
> > the database schema without data and restoring it
> > into 8.2 database . this can be time saving in detecting
> > possible problems in migration.
> >
> > in case there is some non trivial problem
> > you may take intermediate path of upgrading
> > 7.4-->8.0.x-->8.1.x -->8.2.0
> > where x denotes the last minor release of a major
> > release.
> >
> > regds
> > mallah.
> >
> >
> > On 12/19/06, Matthias.Pitzl@izb.de <Matthias.Pitzl@izb.de> wrote:
> > > Hi Rickard!
> > >
> > > As far as i know you will have to dump and restore the databases
> > for the
> > > upgrade since a lot of internals have been changed from 7.4 to
> > 8.2.
> > > A description on how to upgrade can be found here:
> > >
> > http://www.postgresql.org/docs/8.2/interactive/install-upgrading.html
> > > And here:
> > http://www.postgresql.org/docs/8.2/interactive/migration.html
> > >
> > > Good luck!
> > >
> > > Greetings,
> > > Matthias
> > >
> > > > -----Original Message-----
> > > > From: pgsql-admin-owner@postgresql.org
> > > > [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of
> > > > Rickard Sjöström
> > > > Sent: Tuesday, December 19, 2006 10:04 AM
> > > > To: pgsql-admin@postgresql.org
> > > > Subject: [ADMIN] Upgrading from 7.4 to 8.2
> > > >
> > > >
> > > > Hi!
> > > > I have PostgreSQL 7.4 DBM and want to upgrade to 8.2 (latest
> > > > in version 8 I quess).
> > > >
> > > > Can use the DATADIR from 7.4 and just upgrade the
> > > > DBM/postgresql server to 8.2?
> > > >
> > > > Is the upgrade from 7 to 8 procedure written down somewhere?
> > > > (could not find anyting at
> > > > http://www.postgresql.org/docs/techdocs.2, > except from 6 to
> > > > 7)
> > > >
> > > > I guess I could dump all my data and restore it later but it
> > > > would be much nicer if it was possible to just start a new
> > > > PostgreSQL server with the old DATADIR repository!
> > > >
> > > > Thanks!
> > > >
> > > > /Rick
> > > >
> > > >
> > ----------------------------------------------------------------------
> > > > Diamond Ring Auctions at Bidz!
> > > > Engagement rings auctioned daily. Every 5 seconds, starting at
> > $1!
> > > >
> > http://tags.bluebottle.com/fc/BgLEQfJCfpRhST38x1THooDD28i6CkYTg1zn/
> > > >
> > > >
> > > > ---------------------------(end of
> > > > broadcast)---------------------------
> > > > TIP 5: don't forget to increase your free space map settings
> > > >
> > >
> > > ---------------------------(end of
> > broadcast)---------------------------
> > > TIP 1: if posting/reading through Usenet, please send an
> > appropriate
> > >       subscribe-nomail command to majordomo@postgresql.org so
> > that your
> > >       message can get through to the mailing list cleanly
> > >
> >
>
> ----------------------------------------------------------------------
> Free Debt Consolidation Quote
> FCCC offers free counseling & debt consolidation quote. No setup fee!
> http://tags.bluebottle.com/fc/BgLEQfI7q8COE6YTwzNhNIsdKPTGDJaJS3gO/
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>

^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Upgrading from 7.4 to 8.2
  2006-12-19 09:29 Re: Upgrading from 7.4 to 8.2 Matthias.Pitzl@izb.de
  2006-12-19 15:17 ` Re: Upgrading from 7.4 to 8.2 Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
  2006-12-19 16:59   ` Re: Upgrading from 7.4 to 8.2 Rickard Sjöström <rickard.sjostrom@bluebottle.com>
  2006-12-19 21:40     ` Re: Upgrading from 7.4 to 8.2 Chris Hoover <revoohc@gmail.com>
@ 2006-12-19 21:45       ` Joshua D. Drake <jd@commandprompt.com>
  2006-12-20 08:25         ` Re: Upgrading from 7.4 to 8.2 Rickard Sjöström <rickard.sjostrom@bluebottle.com>
  0 siblings, 1 reply; 9+ messages in thread

From: Joshua D. Drake @ 2006-12-19 21:45 UTC (permalink / raw)
  To: Chris Hoover <revoohc@gmail.com>; +Cc: Rickard Sjöström <rickard.sjostrom@bluebottle.com>; Rajesh Kumar Mallah <mallah.rajesh@gmail.com>; Matthias.Pitzl@izb.de <Matthias.Pitzl@izb.de>; pgsql-admin

On Tue, 2006-12-19 at 16:40 -0500, Chris Hoover wrote:
> Very easy,
> 
> Install the new version of PostgreSQL on your new machine.  Then use
> the new machine's install to pg_dump the old machine's database and
> load it into the new machine (obviously, the machines must be table to
> talk to each other over the network).  Very easy.  That is how I
> upgraded all of my servers from 7.3.4 to 8.1.3. (An upgrade that went
> very smoothly with no hiccups.)

Except that there are behavioral differences between 8.1.3 and 7.4
including how floats respond to '' input. I believe there are also
library version bumps which will likely effect him if he does not
recompile his apps because he might remove 7.4 after getting a
successful upgrade of his data just to find that PHP or Perl doesn't
work anymore.

Joshua D. Drake


> 
> HTH,
> 
> Chris
> 
> On 12/19/06, Rickard Sjöström <rickard.sjostrom@bluebottle.com> wrote:
>         Hi!
>         Thanks for your replies!
>         
>         My problem is that I want to move the DBM to a different
>         machine so now when it doesn't seem to be any easy/trivial way
>         to migrate from 7.4 to 8.2 I might consider to continue with
>         7.4.
>         
>         If I decide to continue with 7.4 I guess the procedure to move
>         the DATADIR to the new machine and then start the postgresql
>         server there with the old DATADIR should work without
>         problems?
>         
>         Thanks, again!
>         
>         /Rickard
>         
>         Citerar Rajesh Kumar Mallah < mallah.rajesh@gmail.com>:
>         
>         > Dear Rickard,
>         >
>         > The jump from 7.4 to 8.2 is rather big.
>         > I would suggest doing just a dry run by  dumping
>         > the database schema without data and restoring it 
>         > into 8.2 database . this can be time saving in detecting
>         > possible problems in migration.
>         >
>         > in case there is some non trivial problem
>         > you may take intermediate path of upgrading
>         > 7.4-->8.0.x-->8.1.x -->8.2.0
>         > where x denotes the last minor release of a major
>         > release.
>         >
>         > regds
>         > mallah.
>         >
>         >
>         > On 12/19/06, Matthias.Pitzl@izb.de <Matthias.Pitzl@izb.de>
>         wrote:
>         > > Hi Rickard!
>         > >
>         > > As far as i know you will have to dump and restore the
>         databases 
>         > for the
>         > > upgrade since a lot of internals have been changed from
>         7.4 to
>         > 8.2.
>         > > A description on how to upgrade can be found here:
>         > >
>         >
>         http://www.postgresql.org/docs/8.2/interactive/install-upgrading.html
>         > > And here:
>         >
>         http://www.postgresql.org/docs/8.2/interactive/migration.html
>         > >
>         > > Good luck!
>         > >
>         > > Greetings,
>         > > Matthias
>         > >
>         > > > -----Original Message-----
>         > > > From: pgsql-admin-owner@postgresql.org
>         > > > [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of
>         > > > Rickard Sjöström
>         > > > Sent: Tuesday, December 19, 2006 10:04 AM 
>         > > > To: pgsql-admin@postgresql.org
>         > > > Subject: [ADMIN] Upgrading from 7.4 to 8.2
>         > > >
>         > > >
>         > > > Hi!
>         > > > I have PostgreSQL 7.4 DBM and want to upgrade to 8.2
>         (latest
>         > > > in version 8 I quess).
>         > > >
>         > > > Can use the DATADIR from 7.4 and just upgrade the
>         > > > DBM/postgresql server to 8.2?
>         > > >
>         > > > Is the upgrade from 7 to 8 procedure written down
>         somewhere?
>         > > > (could not find anyting at
>         > > > http://www.postgresql.org/docs/techdocs.2, > except from
>         6 to
>         > > > 7)
>         > > >
>         > > > I guess I could dump all my data and restore it later
>         but it
>         > > > would be much nicer if it was possible to just start a
>         new 
>         > > > PostgreSQL server with the old DATADIR repository!
>         > > >
>         > > > Thanks!
>         > > >
>         > > > /Rick
>         > > >
>         > > >
>         >
>         ---------------------------------------------------------------------- 
>         > > > Diamond Ring Auctions at Bidz!
>         > > > Engagement rings auctioned daily. Every 5 seconds,
>         starting at
>         > $1!
>         > > >
>         >
>         http://tags.bluebottle.com/fc/BgLEQfJCfpRhST38x1THooDD28i6CkYTg1zn/
>         > > >
>         > > >
>         > > > ---------------------------(end of
>         > > > broadcast)---------------------------
>         > > > TIP 5: don't forget to increase your free space map
>         settings 
>         > > >
>         > >
>         > > ---------------------------(end of
>         > broadcast)---------------------------
>         > > TIP 1: if posting/reading through Usenet, please send an
>         > appropriate
>         > >       subscribe-nomail command to majordomo@postgresql.org
>         so
>         > that your
>         > >       message can get through to the mailing list cleanly
>         > >
>         >
>         
>         ---------------------------------------------------------------------- 
>         Free Debt Consolidation Quote
>         FCCC offers free counseling & debt consolidation quote. No
>         setup fee!
>         http://tags.bluebottle.com/fc/BgLEQfI7q8COE6YTwzNhNIsdKPTGDJaJS3gO/
>         
>         
>         ---------------------------(end of
>         broadcast)---------------------------
>         TIP 1: if posting/reading through Usenet, please send an
>         appropriate
>                subscribe-nomail command to majordomo@postgresql.org so
>         that your
>                message can get through to the mailing list cleanly
> 
-- 

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

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate






^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Upgrading from 7.4 to 8.2
  2006-12-19 09:29 Re: Upgrading from 7.4 to 8.2 Matthias.Pitzl@izb.de
  2006-12-19 15:17 ` Re: Upgrading from 7.4 to 8.2 Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
  2006-12-19 16:59   ` Re: Upgrading from 7.4 to 8.2 Rickard Sjöström <rickard.sjostrom@bluebottle.com>
  2006-12-19 21:40     ` Re: Upgrading from 7.4 to 8.2 Chris Hoover <revoohc@gmail.com>
  2006-12-19 21:45       ` Re: Upgrading from 7.4 to 8.2 Joshua D. Drake <jd@commandprompt.com>
@ 2006-12-20 08:25         ` Rickard Sjöström <rickard.sjostrom@bluebottle.com>
  0 siblings, 0 replies; 9+ messages in thread

From: Rickard Sjöström @ 2006-12-20 08:25 UTC (permalink / raw)
  To: pgsql-admin

Hi!
I'm tying to compile postgresql 8.2.0 under:
SunOS 5.8 Generic_117350-36 sun4u sparc SUNW,Sun-Blade-100

and got problems while compiling, the problem seems to be that gcc (or configure) adds my username (sjostric) to the gcc command line. Like this:

gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing sjostric -I../../src/port -DFRONTEND -I../../src/include   -c -o isinf.o isinf.c

which results in that I get:
gcc: sjostric: No such file or directory

My configure command line is:
/configure --prefix=/home/sjostric/postgresql/8.2.0 --exec-prefix=/home/sjostric/postgresql/8.2.0 --without-readline

Any ideas? 

Thanks!

/Rickard

Output:
---- 8< ----
make[3]: Entering directory `/home/sjostric/postgresql/src/postgresql-8.2.0/src/port'
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing sjostric -I../../src/port -DFRONTEND -I../../src/include   -c -o isinf.o isinf.c
gcc: sjostric: No such file or directory
make[3]: *** [isinf.o] Error 1
make[3]: *** Deleting file `isinf.o'
make[3]: Leaving directory `/home/sjostric/postgresql/src/postgresql-8.2.0/src/port'
make[2]: *** [all] Error 2
make[2]: Leaving directory `/home/sjostric/postgresql/src/postgresql-8.2.0/src'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/home/sjostric/postgresql/src/postgresql-8.2.0'
*** Error code 2
make: Fatal error: Command failed for target `all'
(56)# postgresql-8.2.0/:
---- >8 ----

/Rickard

----------------------------------------------------------------------
Debt Consolidation Quote Instantly
Free Debt Consolidation or Debt settlement Quote Online. No...
http://tags.bluebottle.com/fc/BgLEQfI7na2GDfoEzdoobqhZ7mmMke1brTUo/




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Upgrading from 7.4 to 8.2
  2006-12-19 09:29 Re: Upgrading from 7.4 to 8.2 Matthias.Pitzl@izb.de
  2006-12-19 15:17 ` Re: Upgrading from 7.4 to 8.2 Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
  2006-12-19 16:59   ` Re: Upgrading from 7.4 to 8.2 Rickard Sjöström <rickard.sjostrom@bluebottle.com>
@ 2006-12-20 21:10     ` Bruno Wolff III <bruno@wolff.to>
  1 sibling, 0 replies; 9+ messages in thread

From: Bruno Wolff III @ 2006-12-20 21:10 UTC (permalink / raw)
  To: Rickard Sjöström <rickard.sjostrom@bluebottle.com>; +Cc: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>; Matthias.Pitzl@izb.de <Matthias.Pitzl@izb.de>; pgsql-admin

On Tue, Dec 19, 2006 at 08:59:26 -0800,
  Rickard Sjöström <rickard.sjostrom@bluebottle.com> wrote:
> 
> If I decide to continue with 7.4 I guess the procedure to move the DATADIR to the new machine and then start the postgresql server there with the old DATADIR should work without problems?

The new machine will need to have the same architecture and Postgres will
need to have been built with the same way for each machine. Some of the
configure options affect the format of how data is stored. Different
compilers or compiler options could also change how data is stored.



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Upgrading from 7.4 to 8.2
  2006-12-19 09:29 Re: Upgrading from 7.4 to 8.2 Matthias.Pitzl@izb.de
  2006-12-19 15:17 ` Re: Upgrading from 7.4 to 8.2 Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
@ 2006-12-19 17:32   ` Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
  1 sibling, 0 replies; 9+ messages in thread

From: Rajesh Kumar Mallah @ 2006-12-19 17:32 UTC (permalink / raw)
  To: Rickard Sjöström <rickard.sjostrom@bluebottle.com>; +Cc: Matthias.Pitzl@izb.de <Matthias.Pitzl@izb.de>; pgsql-admin

On 12/19/06, Rickard Sjöström <rickard.sjostrom@bluebottle.com> wrote:
> Hi!
> Thanks for your replies!
>
> My problem is that I want to move the DBM to a different machine so now when it >doesn't seem to be any easy/trivial way to migrate from 7.4 to 8.2 I might >consider to continue with 7.4.

It was not my intention to scare you. Please do not misread.
It is always recommended to run the latest version of pgsql
unless you really have to stick to an older version.
Release notes shall tell you about the new features that
you get in various versions. Newer versions almost always have better
planner and numerous performance improvements.


>
> If I decide to continue with 7.4 I guess the procedure to move the DATADIR to the new machine and then start the postgresql server there with the old DATADIR should work without problems?

Yes that is rite.

>
> Thanks, again!
>
> /Rickard
>
> Citerar Rajesh Kumar Mallah <mallah.rajesh@gmail.com>:



^ permalink  raw  reply  [nested|flat] 9+ messages in thread


end of thread, other threads:[~2006-12-20 21:10 UTC | newest]

Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-12-19 09:03 Upgrading from 7.4 to 8.2 Rickard Sjöström <rickard.sjostrom@bluebottle.com>
2006-12-19 09:29 Re: Upgrading from 7.4 to 8.2 Matthias.Pitzl@izb.de
2006-12-19 15:17 ` Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
2006-12-19 16:59   ` Rickard Sjöström <rickard.sjostrom@bluebottle.com>
2006-12-19 21:40     ` Chris Hoover <revoohc@gmail.com>
2006-12-19 21:45       ` Joshua D. Drake <jd@commandprompt.com>
2006-12-20 08:25         ` Rickard Sjöström <rickard.sjostrom@bluebottle.com>
2006-12-20 21:10     ` Bruno Wolff III <bruno@wolff.to>
2006-12-19 17:32   ` Rajesh Kumar Mallah <mallah.rajesh@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox