Differential D4117

Create ZFS dataset for PostgreSQL data
ClosedPublic
Actions

Authored by dereckson on Sun, Jul 5, 13:11.

Details

Reviewers

dereckson

Commits

rOPS15886c60c887: Create ZFS dataset for PostgreSQL data

Summary

The recordsize option aligns ZFS blocks with PostgreSQL page size.

Test Plan

Applied on WindRiver.

Diff Detail

Repository

rOPS Nasqueron Operations

Lint

Lint Not Applicable

Unit

Tests Not Applicable

Event Timeline

dereckson requested review of this revision.Sun, Jul 5, 13:11

dereckson created this revision.

Harbormaster completed remote builds in B6734: Diff 10804.Sun, Jul 5, 13:11

dereckson edited the test plan for this revision. (Show Details)Sun, Jul 5, 13:11

dereckson edited the summary of this revision. (Show Details)

dereckson edited the test plan for this revision. (Show Details)

symlink

Harbormaster completed remote builds in B6735: Diff 10805.Sun, Jul 5, 13:18

Test on WindRiver

After upgrade per Operations grimoire procedure:

WindRiver / tmp.sls matches line 1-43 of roles/dbserver-pgsql/server/content.sls

$ head -n42 roles/dbserver-pgsql/server/content.sls > tmp.sls
$ salt-call --local state.apply tmp test=True                    
local:
----------
          ID: postgresql_data_zfs_dataset
    Function: zfs.filesystem_present
        Name: arcology/postgresql/data18
      Result: True
     Comment: filesystem arcology/postgresql/data18 is uptodate
     Started: 13:18:40.130885
    Duration: 89.456 ms
     Changes:   
----------
          ID: postgresql_data_permissions
    Function: file.directory
        Name: /var/db/postgres/data18
      Result: True
     Comment: The directory /var/db/postgres/data18 is in the correct state
     Started: 13:18:40.228514
    Duration: 19.2 ms
     Changes:   
----------
          ID: /var/db/postgres/data
    Function: file.symlink
      Result: True
     Comment: The symlink /var/db/postgres/data is present
     Started: 13:18:40.247953
    Duration: 1.81 ms
     Changes:   

Summary for local
------------
Succeeded: 3
Failed:    0
------------
Total states run:     3
Total run time: 110.466 ms