OpenSolaris

Discussions Communities Projects Download Source Browser

Home » OpenSolaris Forums » databases » discuss

Thread: PostgreSQL 8.3 released by the community

Welcome, Guest Help
Login Login
Guest Settings Guest Settings
Reply to this Thread Reply to this Thread Search Forum Search Forum Back to Thread List Back to Thread List

Permlink Replies: 5 - Last Post: Feb 7, 2008 9:36 AM by: jkshah Threads: [ Previous | Next ]
bjornmu

Posts: 73
From: NO

Registered: 1/10/07
PostgreSQL 8.3 released by the community
Posted: Feb 4, 2008 4:40 AM

  Click to reply to this thread Reply

PostgreSQL 8.3 has just been announced by the community:

http://www.postgresql.org/about/news.918

The ARC case to integrate 8.3 into Nevada has been approved and I'm
currently working on getting this done. 8.2 has recently been
extended with 64 bit binaries, and 8.3 will of course also come in 32
bit and 64 bit versions.

There are also plans (and an approved ARC case) to eventually remove
8.1 from OpenSolaris, to avoid having too many versions. There will
be a solution available to allow people to upgrade their databases.

Independently of this, I have also written a short description of how
to build PostgreSQL on Solaris:

http://wikis.sun.com/display/DBonSolaris/BuildingPostgreSQL

This is currently only for the 32 bit version, I will update with 64
bit version later.

--
Bjorn Munch
Database Technology Group
Sun Microsystems, Trondheim, Norway
_______________________________________________
databases-discuss mailing list
databases-discuss at opensolaris dot org
http://mail.opensolaris.org/mailman/listinfo/databases-discuss


srinatar

Posts: 544
From: US

Registered: 11/22/05
Re: PostgreSQL 8.3 released by the community
Posted: Feb 4, 2008 11:32 AM   in response to: bjornmu

  Click to reply to this thread Reply

Hi
When you are remove 8.1 database, what will happen to the client
libraries ? Currently, PHP component (part of SFW consolidation) is
depending on PostgreSQL 8.1 client library ? Should I have to upgrade
this component to now link against 8.2 ?

thanks
sriram

Bjorn Munch wrote:
> PostgreSQL 8.3 has just been announced by the community:
>
> http://www.postgresql.org/about/news.918
>
> The ARC case to integrate 8.3 into Nevada has been approved and I'm
> currently working on getting this done. 8.2 has recently been
> extended with 64 bit binaries, and 8.3 will of course also come in 32
> bit and 64 bit versions.
>
> There are also plans (and an approved ARC case) to eventually remove
> 8.1 from OpenSolaris, to avoid having too many versions. There will
> be a solution available to allow people to upgrade their databases.
>
> Independently of this, I have also written a short description of how
> to build PostgreSQL on Solaris:
>
> http://wikis.sun.com/display/DBonSolaris/BuildingPostgreSQL
>
> This is currently only for the 32 bit version, I will update with 64
> bit version later.
>
>
_______________________________________________
databases-discuss mailing list
databases-discuss at opensolaris dot org
http://mail.opensolaris.org/mailman/listinfo/databases-discuss


bjornmu

Posts: 73
From: NO

Registered: 1/10/07
Re: PostgreSQL 8.3 released by the community
Posted: Feb 4, 2008 11:52 AM   in response to: srinatar

  Click to reply to this thread Reply

On 04/02 11.32, Sriram Natarajan wrote:
> Hi
> When you are remove 8.1 database, what will happen to the client
> libraries ? Currently, PHP component (part of SFW consolidation) is
> depending on PostgreSQL 8.1 client library ? Should I have to upgrade
> this component to now link against 8.2 ?

Oh, is it? When I wrote the ARC case, I checked to see if any other
packages were marked as depending on any of the PG 8.1 packages, and
didn't find any. So if PHP really does depend on PostgreSQL 8.1, yes
it will have to be upgraded before 8.1 can be removed.

- Bjorn
_______________________________________________
databases-discuss mailing list
databases-discuss at opensolaris dot org
http://mail.opensolaris.org/mailman/listinfo/databases-discuss


bjornmu

Posts: 73
From: NO

Registered: 1/10/07
Re: PostgreSQL 8.3 released by the community
Posted: Feb 5, 2008 5:52 AM   in response to: srinatar

  Click to reply to this thread Reply

On 04/02 11.32, Sriram Natarajan wrote:
> Hi
> When you are remove 8.1 database, what will happen to the client
> libraries ? Currently, PHP component (part of SFW consolidation) is
> depending on PostgreSQL 8.1 client library ? Should I have to upgrade
> this component to now link against 8.2 ?

I just checked the current SFWNV package definitions:

% grep postgr SUNWphp*/depend
SUNWphp524-pgsql/depend:P SUNWpostgr-libs The shared libraries required for any PostgreSQL 8.1.10 clients

The installed file /usr/php5/5.2.4/modules/pgsql.so does indeed depend
on the PG 8.1 client library, but this file comes from the above
package, not from the general PHP packages.

This package will then have to be upgraded.

- Bjorn
_______________________________________________
databases-discuss mailing list
databases-discuss at opensolaris dot org
http://mail.opensolaris.org/mailman/listinfo/databases-discuss


srinatar

Posts: 544
From: US

Registered: 11/22/05
Re: PostgreSQL 8.3 released by the community
Posted: Feb 5, 2008 11:23 AM   in response to: bjornmu

  Click to reply to this thread Reply

Hi
For build 79, we separated our PHP packages so that PHP Database
support is included in separate packages. This is done , mostly based on
customer's feedback, to reduce the number of dependencies to
successfully install PHP5 package . Currently, CR: 6658437 is created to
track this issue

thanks
sriram

Bjorn Munch wrote:
> On 04/02 11.32, Sriram Natarajan wrote:
>
>> Hi
>> When you are remove 8.1 database, what will happen to the client
>> libraries ? Currently, PHP component (part of SFW consolidation) is
>> depending on PostgreSQL 8.1 client library ? Should I have to upgrade
>> this component to now link against 8.2 ?
>>
>
> I just checked the current SFWNV package definitions:
>
> % grep postgr SUNWphp*/depend
> SUNWphp524-pgsql/depend:P SUNWpostgr-libs The shared libraries required for any PostgreSQL 8.1.10 clients
>
> The installed file /usr/php5/5.2.4/modules/pgsql.so does indeed depend
> on the PG 8.1 client library, but this file comes from the above
> package, not from the general PHP packages.
>
> This package will then have to be upgraded.
>
> - Bjorn
> _______________________________________________
> databases-discuss mailing list
> databases-discuss at opensolaris dot org
> http://mail.opensolaris.org/mailman/listinfo/databases-discuss
>
_______________________________________________
databases-discuss mailing list
databases-discuss at opensolaris dot org
http://mail.opensolaris.org/mailman/listinfo/databases-discuss


jkshah

Posts: 41
From: US

Registered: 4/27/05
Re: PostgreSQL 8.3 released by the community
Posted: Feb 7, 2008 9:36 AM   in response to: bjornmu

  Click to reply to this thread Reply

I think for 64-bit I had to add -m64 for CFLAGS and an additional
DTRACEFLAGS=-64
to tell dtrace to build 64-bit probes

I didnt had to change anything but I was not linking against many of the
features out there..

-Jignesh


Bjorn Munch wrote:
> PostgreSQL 8.3 has just been announced by the community:
>
> http://www.postgresql.org/about/news.918
>
> The ARC case to integrate 8.3 into Nevada has been approved and I'm
> currently working on getting this done. 8.2 has recently been
> extended with 64 bit binaries, and 8.3 will of course also come in 32
> bit and 64 bit versions.
>
> There are also plans (and an approved ARC case) to eventually remove
> 8.1 from OpenSolaris, to avoid having too many versions. There will
> be a solution available to allow people to upgrade their databases.
>
> Independently of this, I have also written a short description of how
> to build PostgreSQL on Solaris:
>
> http://wikis.sun.com/display/DBonSolaris/BuildingPostgreSQL
>
> This is currently only for the 32 bit version, I will update with 64
> bit version later.
>
>
_______________________________________________
databases-discuss mailing list
databases-discuss at opensolaris dot org
http://mail.opensolaris.org/mailman/listinfo/databases-discuss





Terms of Use | Privacy | Trademarks | Copyright Policy | Site Guidelines
Your use of this web site or any of its content or software indicates your agreement to be bound by these Terms of Use.
© 2010, Oracle Corporation and/or its affiliates

Oracle