Opened 8 months ago

Closed 6 months ago

#5549 closed task (duplicate)

Have a bot test under pgextwlist conditions

Reported by: strk Owned by: robe
Priority: medium Milestone: Website Management, Bots
Component: QA/buildbots Version:
Keywords: pgextwlist Cc:

Description (last modified by strk)

Given the many issues related to use of pgextwlist, it would be good to have a bot run tests in that context.

See #5212 #5525 #5545 #5550

Change History (4)

comment:1 by strk, 8 months ago

According to documentation in ​https://github.com/dimitri/pgextwlist not all tests could be run because re-packaging extensions is forbidden under pgextwlist so upgrades from 2.x cannot be tested.

comment:2 by strk, 8 months ago

What we need to test under sandbox:

  1. Create an postgis-regress specific unprivileged role (or user?)
  2. Have run_test.pl switch to the unprivileged role (or connect as the unprivileged user)
  3. Make sure postgresql backends will load pgextwlist and have its configuration properly set

The current run_test.pl uses different connections for different steps so it's easier if the pgextlist configuration is done once, externally, and that direct connection as unprivileged user is used afterwards (using PGUSER/PGPASSWORD).

comment:3 by strk, 6 months ago

Component: postgis → QA/buildbots
Owner: changed from pramsey to robe
Type: defect → task

comment:4 by strk, 6 months ago

Description: modified (diff)
Resolution: → duplicate
Status: new → closed

Duplicate of #5566

Note: See TracTickets for help on using tickets.