Postgres notes

Users List users postgres=# \du List of roles Role name | Attributes | Member of ———————+————————————————————+———– database | | {} database_ajuda | | {} postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {} postgres_exporter | | {} It can also be done through a query. postgres=# SELECT u.usename AS “Role name”, postgres-# […]

How to know if vomume is ASM or not

The simplest way to find out if a disk is ASM from the console or not is running the following command. blkid | grep asm If we have an ASM disk, the output would look like this: [root@Oracle-DB05~]# blkid | grep asm /dev/mapper/ASM_data3p1: LABEL=”DATA003″ TYPE=”oracleasm” /dev/mapper/ASM_data4p1: LABEL=”DATA004″ TYPE=”oracleasm” /dev/mapper/ASM_data2p1: LABEL=”DATA002″ TYPE=”oracleasm” /dev/mapper/ASM_fra3p1: LABEL=”FRA003″ TYPE=”oracleasm” /dev/mapper/ASM_data5p1: […]

Isilon Notes

List job status summarized isilon-i000-1% isi sync reports list –reports-per-policy 1 Policy Name Job ID Start Time End Time Action State ———————————————————————————- REP_vci0-esc001 3726 2019-07-11T11:30:01 2019-07-11T11:30:11 run finished REP_vci1-lleg001 3726 2019-07-11T11:35:01 2019-07-11T11:35:16 run finished REP_vci1-esc001 3725 2019-07-11T11:40:01 2019-07-11T11:40:13 run finished REP_vci2-lleg001 3726 2019-07-11T11:45:01 2019-07-11T11:45:16 run finished REP_vci2-esc001 3726 2019-07-11T11:20:01 2019-07-11T11:20:14 run finished REP_vci3-lleg001 3688 2019-07-11T11:25:01 […]