[OpenIndiana-discuss] PostgreSQL

[Albert Lee]

On Sat, Dec 25, 2010 at 8:53 AM, Glenn Holmer <shadowm at lyonlabs.org> wrote:
> On Sat, 2010-12-25 at 00:53 +0100, Guido Berhoerster wrote:
>> > When I start the GUI package manager and search on "postgres", I see
>> > only SUNWpostgr-82-server-data-root and SUNWpostgr-server, whose
>> > description says it's 8.1.11. When I go to
>> > http://pkg.openindiana.org/dev/ and click on the install link for e.g.
>> > database/postgres-84, I get "All packages already installed", although
>> > "pkg list | grep -i post" does not show it.
>
>> Have you tried just doing a "pkg install postgres-84"?
>> What is the output of
>> pkg list -fa postgres-84
>> and
>> pkg publisher
>> ?
>
> root at shoggoth:~# pkg publisher
> PUBLISHER                             TYPE     STATUS   URI
> openindiana.org          (preferred)  origin   online   http://pkg.openindiana.org/dev/
> opensolaris.org                       origin   online   http://pkg.openindiana.org/legacy/
> root at shoggoth:~#
>

This should not be the case if you followed the upgrade instructions. Please do:
pkg set-publisher --non-sticky opensolaris.org


> pkg list -fa does show 8.2, 8.3, and 8.4.
>
> root at shoggoth:~# pkg install postgres-84
> Creating Planpkg: 'postgres-84' matches multiple packages
>        service/database/postgres-84
>        database/postgres-84
>
> root at shoggoth:~# pkg install database/postgres-84
> Creating Planpkg: 'database/postgres-84' matches multiple packages
>        service/database/postgres-84
>        database/postgres-84
>
> root at shoggoth:~# pkg install service/database/postgres-84
> No updates necessary for this image.

pkg install pkg:/database/postgres-84

-Albert