Project

General

Profile

Bug #1272

Postgres package broken in /dev-il

Added by Alasdair Lumsden over 8 years ago. Updated almost 8 years ago.

Status:
Resolved
Priority:
Urgent
Category:
OI-Userland
Target version:
Start date:
2011-07-25
Due date:
2011-09-14
% Done:

0%

Estimated time:
1.00 h
Difficulty:
Bite-size
Tags:
postgres

Description

When attempting to install everything, Postgres breaks the install phase due to the missing postgres user:

$ cat /tmp/a | grep v pkg | sed 's/^/pkg:\//g' | grep '\--' | grep -v driver | grep -v consolidation | grep -v locale | grep -v coverage | grep -v system/trusted/trusted-nonglobal | grep -v library/python-2 | grep -v auto_install | grep -v babel_install | grep -v package | grep -v server_install | grep -v system/desktop/ldtp| awk '{print $1}' | grep -v entire | grep -v redistributable | grep -v library/java/javadb | grep -v system/management/visual-panels/doc | grep -v system/accounting/legacy | xargs pkg install
Packages to install: 965
Create boot environment: No
Services to restart: 9
DOWNLOAD PKGS FILES XFER (MB)
Completed 965/965 205890/205890 1859.3/1859.3

PHASE ACTIONS
Install Phase 41586/264065
pkg: The requested operation cannot be completed due to invalid package metadata. Details follow:

The action 'dir group=postgres mode=0755 owner=postgres path=var/postgres' in package 'pkg:,5.11-0.151:20110523T151020Z' has invalid attribute(s):
'//var/postgres' cannot be installed; 'postgres' is an unknown or invalid user.


Files

postgres-user.patch (1.68 KB) postgres-user.patch Alasdair Lumsden, 2011-09-06 10:06 AM

History

#1

Updated by Chris Jordan over 8 years ago

  • Assignee set to OI SFW
  • Difficulty changed from Medium to Bite-size
  • Tags changed from needs-triage to postgres

Assigning to "OI SFW"

#2

Updated by Alex Viskovatoff about 8 years ago

Workaround: use Postgres from oi-sfe

#3

Updated by Ken Mays about 8 years ago

  • Due date set to 2011-09-14
  • Category changed from Release Engineering to 10
  • Status changed from New to Resolved
  • Target version set to oi_151_stable
  • % Done changed from 0 to 100
  • Estimated time set to 40.00 h

PostgreSQL 9.0.4 packages supercede previous releases as workaround.
,5.11-0.151:20110803T201807Z

#4

Updated by Alasdair Lumsden about 8 years ago

  • File postgres-user.patch postgres-user.patch added
  • Status changed from Resolved to New
  • Assignee changed from OI SFW to Alasdair Lumsden
  • Priority changed from High to Urgent
  • % Done changed from 100 to 0
  • Estimated time changed from 40.00 h to 1.00 h

Hi Ken,

I'm re-opening this as its not fixed (also postgres-90 isn't in oi itself, its in SFE).

Illumos removed the postgres user as a deliverable after oi_148 shipped, so we need to add it in the distro-import phase for the SVR4 Postgresql package.

Since richlowe and I are working on the release engineering at the moment, adding the postgres user during the next respin should be trivial enough to do.

Although there is a "database\:postgres-common" distro-import file, the database/postgres-common package is only depended upon by postgres-84, not by -83 or -82. So I had a rummage at who owns what to work out where best to put it:

alasdair ~ (al-sunbox.office): pkg contents -mr database/postgres-82/* | grep owner | sed 's/.*owner=//g' | sed 's/ .*//g' | sort | uniq
root
alasdair ~ (al-sunbox.office): pkg contents -mr database/postgres-82 | grep owner | sed 's/.*owner=//g' | sed 's/ .*//g' | sort | uniq
postgres
root

Looks like "database/postgres-8234" should be fine.

I've attached a patch for this, which we can apply if richlowe approves!

Cheers,

Alasdair

#5

Updated by Ken Mays about 8 years ago

Sidelined request: Can we remove PostgreSQL 8.2/8.3 from OI_IPS during this work task?

#6

Updated by Jon Tibble almost 8 years ago

  • Status changed from New to Resolved

Fixed in oi_151a, doesn't need to target stable.

Ken, if you want to remove 82 and 83 could you file another bug please - one item per issue.

Also available in: Atom PDF