View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000235 | My infrastructure | General | public | 2024-06-30 21:57 | 2024-07-01 18:06 |
| Reporter | dvl | Assigned To | dvl | ||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | resolved | Resolution | fixed | ||
| Summary | 0000235: check FreshPorts tables for non-postgres owned tables | ||||
| Description | I've not been postgres when adding those tables. | ||||
| Tags | No tags attached. | ||||
|
|
Changed this on aws-1:
freshports.org=> \dp packages_raw
Access privileges
Schema | Name | Type | Access privileges | Column privileges | Policies
--------+--------------+-------+-----------------------------+-------------------+----------
public | packages_raw | table | packaging=arwdDxt/packaging+| |
| | | rsyncer=r/packaging | |
(1 row)
freshports.org=> alter table packages_raw owner to postgres;
ALTER TABLE
freshports.org=> \dp packages_raw
Access privileges
Schema | Name | Type | Access privileges | Column privileges | Policies
--------+--------------+-------+---------------------------+-------------------+----------
public | packages_raw | table | postgres=arwdDxt/postgres+| |
| | | rsyncer=r/postgres | |
(1 row)
freshports.org=> alter table wlc owner to postgres;
ALTER TABLE
freshports.org=>
|
|
|
And this on test:freshports.test=# alter table wlc owner to postgres; ALTER TABLE freshports.test=# |
|
|
On r720-02-pg01: wlc and packages_raw updated |
|
|
And on x8dtu-pg01 as well. wlc and packages_raw |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-06-30 21:57 | dvl | New Issue | |
| 2024-06-30 21:57 | dvl | Status | new => assigned |
| 2024-06-30 21:57 | dvl | Assigned To | => dvl |
| 2024-07-01 18:01 | dvl | Note Added: 0000280 | |
| 2024-07-01 18:02 | dvl | Note Edited: 0000280 | |
| 2024-07-01 18:03 | dvl | Note Added: 0000281 | |
| 2024-07-01 18:04 | dvl | Note Added: 0000282 | |
| 2024-07-01 18:05 | dvl | Note Added: 0000283 | |
| 2024-07-01 18:06 | dvl | Status | assigned => resolved |
| 2024-07-01 18:06 | dvl | Resolution | open => fixed |
