pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUpgrading 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