[OpenIndiana-discuss] PostgreSQL

[Glenn Holmer]

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:~# 

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.   
root at shoggoth:~# svcs -a | grep post
disabled        9:29:55 svc:/network/ibd-post-upgrade:default
online          9:30:25 svc:/system/postrun:default
root at shoggoth:~# pkg list -fa | grep postgres-84
...
database/postgres-84                          8.4.4-0.148     known      -----
database/postgres-84                          8.4.4-0.146     known      u-o--
database/postgres-84 (opensolaris.org)        8.4.2-0.134     known      u----
database/postgres-84 (opensolaris.org)        8.4.2-0.133     known      u----
...
service/database/postgres-84                  8.4.4-0.148     known      -----
service/database/postgres-84                  8.4.4-0.146     known      u-o--
service/database/postgres-84 (opensolaris.org) 8.4.2-0.134     known      u----
service/database/postgres-84 (opensolaris.org) 8.4.2-0.133     known      u----

-- 
Glenn Holmer (Linux registered user #16682) http://www.lyonlabs.org
"The text is only a proposition." -Pierre Boulez