pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
A quick question on CONTRIB package
8+ messages / 5 participants
[nested] [flat]

* A quick question on CONTRIB package
@ 2006-05-31 11:47  Ramakrishna Reddy <ramakrishna.reddy@indussoft.com>
  0 siblings, 2 replies; 8+ messages in thread

From: Ramakrishna Reddy @ 2006-05-31 11:47 UTC (permalink / raw)
  To: pgsql-general@postgresql.org

Hi,
 
I need to connect to remote databases using Dblink. Our existing version is 7.2.1 on Windows and please point me the location of this package where I can download from and the installation procedure.
 
 
Thanks,
RamaKrishna.



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

* A quick question on CONTRIB package
@ 2006-05-31 12:56  Ramakrishna Reddy <ramakrishna.reddy@indussoft.com>
  parent: Ramakrishna Reddy <ramakrishna.reddy@indussoft.com>
  1 sibling, 1 reply; 8+ messages in thread

From: Ramakrishna Reddy @ 2006-05-31 12:56 UTC (permalink / raw)
  To: pgsql-admin

Hi,
 
I need to connect to remote databases using Dblink. Our existing version is 7.2.1 on Windows and please point me the location of this package where I can download from and the installation procedure. I don't find any such package existing currently in our installation.
 
 
Thanks,
RamaKrishna.



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

* Re: A quick question on CONTRIB package
@ 2006-05-31 17:35  Scott Marlowe <smarlowe@g2switchworks.com>
  parent: Ramakrishna Reddy <ramakrishna.reddy@indussoft.com>
  1 sibling, 1 reply; 8+ messages in thread

From: Scott Marlowe @ 2006-05-31 17:35 UTC (permalink / raw)
  To: Ramakrishna Reddy <ramakrishna.reddy@indussoft.com>; +Cc: pgsql general <pgsql-general@postgresql.org>

On Wed, 2006-05-31 at 06:47, Ramakrishna Reddy wrote:
> Hi,
>  
> I need to connect to remote databases using Dblink. Our existing version is 7.2.1 on Windows and please point me the location of this package where I can download from and the installation procedure.

You should REALLY REALLY REALLY consider upgrading to at least version
8.0.8, if not 8.1.4.

7.2 is, in general not supported.  The windows port, in particular, has
no support whatsoever.  It has known data eating bugs and the dreaded
transaction wraparound bug in particular.

Also, by updating to 8.0.8 or 8.1.4 you should get the dblink package as
a matter of course, I believe.  A windows user would have to confirm
that for me though.  But seriously, if you value your data, updated from
7.2.1 as soon as humanly possible



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

* Re: A quick question on CONTRIB package
@ 2006-05-31 17:57  Ramakrishna Reddy <ramakrishna.reddy@indussoft.com>
  parent: Scott Marlowe <smarlowe@g2switchworks.com>
  0 siblings, 2 replies; 8+ messages in thread

From: Ramakrishna Reddy @ 2006-05-31 17:57 UTC (permalink / raw)
  To: Scott Marlowe <smarlowe@g2switchworks.com>; +Cc: pgsql general <pgsql-general@postgresql.org>

Hi,
 
Thanks for your vauable suggestions.
 
We have very huge databases in many installations and infact have plans for upgrading to latest releases. But as we are not very sure about the stability of post 7.2.1 versions, refrained from doing that. Could you please suggest me which version is the best in terms of stability, performance and minimal bugs. We want to upgrade this on both our Windows as well as Linux environments.
 
 
Thanks again,
RamaKrishna.

________________________________

From: Scott Marlowe [mailto:smarlowe@g2switchworks.com]
Sent: Wed 5/31/2006 11:05 PM
To: Ramakrishna Reddy
Cc: pgsql general
Subject: Re: [GENERAL] A quick question on CONTRIB package



On Wed, 2006-05-31 at 06:47, Ramakrishna Reddy wrote:
> Hi,
> 
> I need to connect to remote databases using Dblink. Our existing version is 7.2.1 on Windows and please point me the location of this package where I can download from and the installation procedure.

You should REALLY REALLY REALLY consider upgrading to at least version
8.0.8, if not 8.1.4.

7.2 is, in general not supported.  The windows port, in particular, has
no support whatsoever.  It has known data eating bugs and the dreaded
transaction wraparound bug in particular.

Also, by updating to 8.0.8 or 8.1.4 you should get the dblink package as
a matter of course, I believe.  A windows user would have to confirm
that for me though.  But seriously, if you value your data, updated from
7.2.1 as soon as humanly possible





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

* Re: A quick question on CONTRIB package
@ 2006-05-31 18:07  Scott Marlowe <smarlowe@g2switchworks.com>
  parent: Ramakrishna Reddy <ramakrishna.reddy@indussoft.com>
  1 sibling, 0 replies; 8+ messages in thread

From: Scott Marlowe @ 2006-05-31 18:07 UTC (permalink / raw)
  To: Ramakrishna Reddy <ramakrishna.reddy@indussoft.com>; +Cc: pgsql general <pgsql-general@postgresql.org>

On Wed, 2006-05-31 at 12:57, Ramakrishna Reddy wrote:
> Hi,
>  
> Thanks for your vauable suggestions.
>  
> We have very huge databases in many installations and infact have plans for upgrading to latest releases. But as we are not very sure about the stability of post 7.2.1 versions, refrained from doing that. Could you please suggest me which version is the best in terms of stability, performance and minimal bugs. We want to upgrade this on both our Windows as well as Linux environments.

Both 8.0.8 and 8.1.4 are light years ahead of 7.2.1 in terms of both
stability and performance.

Both 8.0.8 and 8.1.4 are quite stable.  My recommendation would be for
an upgrade would be to go to 8.1.4 on Linux.

You might need to use iconv (a linux tool) to fix any encoding issues
that have snuck into your data while using 7.2.1



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

* Re: A quick question on CONTRIB package
@ 2006-05-31 21:45  Chris Browne <cbbrowne@acm.org>
  parent: Ramakrishna Reddy <ramakrishna.reddy@indussoft.com>
  1 sibling, 1 reply; 8+ messages in thread

From: Chris Browne @ 2006-05-31 21:45 UTC (permalink / raw)
  To: pgsql-general@postgresql.org

ramakrishna.reddy@indussoft.com ("Ramakrishna Reddy") writes:
> Thanks for your vauable suggestions.
>  
> We have very huge databases in many installations and infact have
> plans for upgrading to latest releases. But as we are not very sure
> about the stability of post 7.2.1 versions, refrained from doing
> that. Could you please suggest me which version is the best in terms
> of stability, performance and minimal bugs. We want to upgrade this
> on both our Windows as well as Linux environments.

Well, there are only three versions worth considering:

1.  7.4.13; 7.4 is still being supported, somewhat.  It's now an old
    version, where numerous improvements and some fixes have been
    applied to later versions that will never be applied to it.

    As compared to 8.0 and 8.1 releases, there are quite a lot of
    things *missing* in 7.4 that help the subsequent major versions to
    provide both better performance and more predictable/stable
    performance.

    I would *NOT* recommend that you jump to 7.4; that would merely
    bring you to having a 2-and-a-half year-old version, lacking the
    benefits of 8.0 and 8.1.

2.  8.0.8.  This is also being supported.  It is an old version, as
    8.1 was released about six months ago.  Again, fixes and
    *numerous* improvements have been applied to 8.1 that will never
    be applied to the 8.0 series.

3.  8.1.4.  This is the latest release of the latest major version.

    As "latest major version," it can be expected to have better
    performance than any earlier major version.

    There haven't been many reports of bugs that were introduced newly
    to this major version, so this version seems reasonably stable
    overally.

    As the latest release of that major version, it can be expected to
    be more stable than any previous release of 8.1.  Certainly it may
    be expected to have the fewest bugs of any 8.1.x release.

It all seems to point to 8.1.4 being the best candidate.
-- 
output = ("cbbrowne" "@" "ntlug.org")
http://www3.sympatico.ca/cbbrowne/linux.html
"Lisp is an eternal thought in the mind of God."
--Crassus, mutatis mutandi



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

* Re: A quick question on CONTRIB package
@ 2006-05-31 22:49  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Chris Browne <cbbrowne@acm.org>
  0 siblings, 0 replies; 8+ messages in thread

From: Tom Lane @ 2006-05-31 22:49 UTC (permalink / raw)
  To: Chris Browne <cbbrowne@acm.org>; +Cc: pgsql-general@postgresql.org

Chris Browne <cbbrowne@acm.org> writes:
> ramakrishna.reddy@indussoft.com ("Ramakrishna Reddy") writes:
>> We have very huge databases in many installations and infact have
>> plans for upgrading to latest releases. But as we are not very sure
>> about the stability of post 7.2.1 versions, refrained from doing
>> that. Could you please suggest me which version is the best in terms
>> of stability, performance and minimal bugs. We want to upgrade this
>> on both our Windows as well as Linux environments.

> Well, there are only three versions worth considering:
> ...
> It all seems to point to 8.1.4 being the best candidate.

I'm having a hard time not rolling on the floor laughing at this
discussion.  If 7.2.1 is your standard of comparison, any of the later
branches are super stable ...

A more serious point is that 7.2.x to 8.x is a big jump in terms of 
behavior; there were a lot of not-so-compatible changes in between.
Porting their application code first to 7.4 and then to 8.1 might be a
good plan in terms of not dealing with too many things at once.
I don't suggest moving their production databases twice, just divvying
up the work of testing and updating their applications.

			regards, tom lane



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

* Re: A quick question on CONTRIB package
@ 2006-06-02 13:31  Jim Nasby <jnasby@pervasive.com>
  parent: Ramakrishna Reddy <ramakrishna.reddy@indussoft.com>
  0 siblings, 0 replies; 8+ messages in thread

From: Jim Nasby @ 2006-06-02 13:31 UTC (permalink / raw)
  To: Ramakrishna Reddy <ramakrishna.reddy@indussoft.com>; +Cc: pgsql-admin

On May 31, 2006, at 7:56 AM, Ramakrishna Reddy wrote:

> Hi,
>
> I need to connect to remote databases using Dblink. Our existing  
> version is 7.2.1 on Windows and please point me the location of  
> this package where I can download from and the installation  
> procedure. I don't find any such package existing currently in our  
> installation.

You're almost certainly out of luck, and more importantly, you're  
asking... no, BEGGING to lose data. There are scores of bugs that  
have been fixed since that version. You need to upgrade to something  
newer, and if you're going to be running on windows you'll be much  
happier with 8.1.4.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461





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


end of thread, other threads:[~2006-06-02 13:31 UTC | newest]

Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-05-31 11:47 A quick question on CONTRIB package Ramakrishna Reddy <ramakrishna.reddy@indussoft.com>
2006-05-31 12:56 ` Ramakrishna Reddy <ramakrishna.reddy@indussoft.com>
2006-06-02 13:31   ` Jim Nasby <jnasby@pervasive.com>
2006-05-31 17:35 ` Scott Marlowe <smarlowe@g2switchworks.com>
2006-05-31 17:57   ` Ramakrishna Reddy <ramakrishna.reddy@indussoft.com>
2006-05-31 18:07     ` Scott Marlowe <smarlowe@g2switchworks.com>
2006-05-31 21:45     ` Chris Browne <cbbrowne@acm.org>
2006-05-31 22:49       ` Tom Lane <tgl@sss.pgh.pa.us>

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