Opened 2 years ago

Last modified 22 months ago

#3068 accepted task

prepare pgsql.int.buildbot.net

Reported by: sa2ajj Owned by: sa2ajj
Priority: major Milestone: sys - other
Version: Keywords: ansible
Cc: sysadmins

Description (last modified by sa2ajj)

This will primarily be used for testing.

We'll need an IP addresses allocated for it.

We have PR#21 that adds a role to create jails, we can use pgsql.int as a specific example for that role.

Change History (7)

comment:1 Changed 2 years ago by sa2ajj

  • Cc verm sysadmins added
  • Description modified (diff)

comment:2 Changed 2 years ago by verm

192.168.80.216, do you need me to create the jail?

comment:3 Changed 2 years ago by sa2ajj

No, it will be created after the abovementioned PR is merged.

comment:4 Changed 2 years ago by sysadmins

  • Cc sysadmins removed

comment:5 Changed 2 years ago by sysadmins

  • Cc sysadmin@… added

comment:6 Changed 2 years ago by sa2ajj

  • Cc sysadmins added; verm sysadmin@… removed
  • Owner set to sa2ajj
  • Status changed from new to accepted

There's a number of things to take into account:

  • security.jail.sysvipc_allowed for the jail where PostgreSQL to be run (maybe qjail would be better to manage jails as it allows to configure that on per-jail basis (as plain jail mechanism))
  • some things related to shared memory sizes (depends on so many factors)
  • statistics collector unconditionally works on localhost (in my test installation I created lo0|127.0.0.239 and it was good)
  • what roles we'll need to easily use it (at least, database creation, user creation and role management needs to be taken care of)

comment:7 Changed 22 months ago by dustin

  • Milestone changed from sys - on-bb-infra to sys - other
Note: See TracTickets for help on using tickets.