PostgreSQL User and Role Management on Arch Linux

Create roles

CREATE ROLE alice WITH LOGIN PASSWORD 'AlicePass!';
CREATE ROLE dbadmin WITH SUPERUSER LOGIN PASSWORD 'AdminPass!';
CREATE ROLE readonly;

Grant privileges

GRANT CONNECT ON DATABASE appdb TO alice;
GRANT USAGE ON SCHEMA public TO...

PostgreSQL User and Role Management on Debian 12

Create roles

CREATE ROLE alice WITH LOGIN PASSWORD 'AlicePass!';
CREATE ROLE dbadmin WITH SUPERUSER LOGIN PASSWORD 'AdminPass!';
CREATE ROLE readonly;

Grant privileges

GRANT CONNECT ON DATABASE appdb TO alice;
GRANT USAGE ON SCHEMA public TO a...

PostgreSQL User and Role Management on Gentoo Linux

Create roles

CREATE ROLE alice WITH LOGIN PASSWORD 'AlicePass!';
CREATE ROLE dbadmin WITH SUPERUSER LOGIN PASSWORD 'AdminPass!';
CREATE ROLE readonly;

Grant privileges

GRANT CONNECT ON DATABASE appdb TO alice;
GRANT USAGE ON SCHEMA public T...

PostgreSQL User and Role Management on NetBSD 10

Create roles

CREATE ROLE alice WITH LOGIN PASSWORD 'AlicePass!';
CREATE ROLE dbadmin WITH SUPERUSER LOGIN PASSWORD 'AdminPass!';
CREATE ROLE readonly;

Grant privileges

GRANT CONNECT ON DATABASE appdb TO alice;
GRANT USAGE ON SCHEMA public TO a...

PostgreSQL User and Role Management on OpenBSD 7.5

Create roles

CREATE ROLE alice WITH LOGIN PASSWORD 'AlicePass!';
CREATE ROLE dbadmin WITH SUPERUSER LOGIN PASSWORD 'AdminPass!';
CREATE ROLE readonly;

Grant privileges

GRANT CONNECT ON DATABASE appdb TO alice;
GRANT USAGE ON SCHEMA public TO...

PostgreSQL User and Role Management on RHEL 9

Create roles

CREATE ROLE alice WITH LOGIN PASSWORD 'AlicePass!';
CREATE ROLE dbadmin WITH SUPERUSER LOGIN PASSWORD 'AdminPass!';
CREATE ROLE readonly;

Grant privileges

GRANT CONNECT ON DATABASE appdb TO alice;
GRANT USAGE ON SCHEMA public TO alic...

PostgreSQL User and Role Management on Ubuntu 24.04

Create roles

CREATE ROLE alice WITH LOGIN PASSWORD 'AlicePass!';
CREATE ROLE dbadmin WITH SUPERUSER LOGIN PASSWORD 'AdminPass!';
CREATE ROLE readonly;

Grant privileges

GRANT CONNECT ON DATABASE appdb TO alice;
GRANT USAGE ON SCHEMA public T...

Install Redis, configure persistence (RDB/AOF), build a cluster and set up Sentinel for high availability.

Redis Cluster on AlmaLinux 9

Minimum 3 primaries + 3 replicas (6 nodes). This example uses ports 7000-7005 on localhost.

Step 1 – Create node configs

for port in 7000 7001 7002 7003 7004 7005; do
    mkdir -p /etc/redis/cluster/$port /var/lib/redis/$port
    cat > /etc/redis/cluster/$port/redi...

Redis Cluster on Arch Linux

Minimum 3 primaries + 3 replicas (6 nodes). This example uses ports 7000-7005 on localhost.

Step 1 – Create node configs

for port in 7000 7001 7002 7003 7004 7005; do
    mkdir -p /etc/redis/cluster/$port /var/lib/redis/$port
    cat > /etc/redis/cluster/$port/redis...

Redis Cluster on Debian 12

Minimum 3 primaries + 3 replicas (6 nodes). This example uses ports 7000-7005 on localhost.

Step 1 – Create node configs

for port in 7000 7001 7002 7003 7004 7005; do
    mkdir -p /etc/redis/cluster/$port /var/lib/redis/$port
    cat > /etc/redis/cluster/$port/redis....

Redis Cluster on Gentoo Linux

Minimum 3 primaries + 3 replicas (6 nodes). This example uses ports 7000-7005 on localhost.

Step 1 – Create node configs

for port in 7000 7001 7002 7003 7004 7005; do
    mkdir -p /etc/redis/cluster/$port /var/lib/redis/$port
    cat > /etc/redis/cluster/$port/red...

Redis Cluster on NetBSD 10

Minimum 3 primaries + 3 replicas (6 nodes). This example uses ports 7000-7005 on localhost.

Step 1 – Create node configs

for port in 7000 7001 7002 7003 7004 7005; do
    mkdir -p /etc/redis/cluster/$port /var/lib/redis/$port
    cat > /etc/redis/cluster/$port/redis....

Redis Cluster on OpenBSD 7.5

Minimum 3 primaries + 3 replicas (6 nodes). This example uses ports 7000-7005 on localhost.

Step 1 – Create node configs

for port in 7000 7001 7002 7003 7004 7005; do
    mkdir -p /etc/redis/cluster/$port /var/lib/redis/$port
    cat > /etc/redis/cluster/$port/redi...

Redis Cluster on RHEL 9

Minimum 3 primaries + 3 replicas (6 nodes). This example uses ports 7000-7005 on localhost.

Step 1 – Create node configs

for port in 7000 7001 7002 7003 7004 7005; do
    mkdir -p /etc/redis/cluster/$port /var/lib/redis/$port
    cat > /etc/redis/cluster/$port/redis.con...

Redis Cluster on Ubuntu 24.04

Minimum 3 primaries + 3 replicas (6 nodes). This example uses ports 7000-7005 on localhost.

Step 1 – Create node configs

for port in 7000 7001 7002 7003 7004 7005; do
    mkdir -p /etc/redis/cluster/$port /var/lib/redis/$port
    cat > /etc/redis/cluster/$port/red...

Redis Persistence on AlmaLinux 9

RDB snapshots (redis.conf)

save 900 1
save 300 10
save 60 10000
dbfilename  dump.rdb
dir         /var/lib/redis
rdbcompression yes
rdbchecksum    yes

AOF (Append-Only File)

appendonly           yes
appendfilename       "appendonly.aof"
appendfsync...

Redis Persistence on Arch Linux

RDB snapshots (redis.conf)

save 900 1
save 300 10
save 60 10000
dbfilename  dump.rdb
dir         /var/lib/redis
rdbcompression yes
rdbchecksum    yes

AOF (Append-Only File)

appendonly           yes
appendfilename       "appendonly.aof"
appendfsync          e...

Redis Persistence on Debian 12

RDB snapshots (redis.conf)

save 900 1
save 300 10
save 60 10000
dbfilename  dump.rdb
dir         /var/lib/redis
rdbcompression yes
rdbchecksum    yes

AOF (Append-Only File)

appendonly           yes
appendfilename       "appendonly.aof"
appendfsync          ev...

Redis Persistence on Gentoo Linux

RDB snapshots (redis.conf)

save 900 1
save 300 10
save 60 10000
dbfilename  dump.rdb
dir         /var/lib/redis
rdbcompression yes
rdbchecksum    yes

AOF (Append-Only File)

appendonly           yes
appendfilename       "appendonly.aof"
appendfsync...

Redis Persistence on NetBSD 10

RDB snapshots (redis.conf)

save 900 1
save 300 10
save 60 10000
dbfilename  dump.rdb
dir         /var/lib/redis
rdbcompression yes
rdbchecksum    yes

AOF (Append-Only File)

appendonly           yes
appendfilename       "appendonly.aof"
appendfsync          ev...

Redis Persistence on OpenBSD 7.5

RDB snapshots (redis.conf)

save 900 1
save 300 10
save 60 10000
dbfilename  dump.rdb
dir         /var/lib/redis
rdbcompression yes
rdbchecksum    yes

AOF (Append-Only File)

appendonly           yes
appendfilename       "appendonly.aof"
appendfsync...

Redis Persistence on RHEL 9

RDB snapshots (redis.conf)

save 900 1
save 300 10
save 60 10000
dbfilename  dump.rdb
dir         /var/lib/redis
rdbcompression yes
rdbchecksum    yes

AOF (Append-Only File)

appendonly           yes
appendfilename       "appendonly.aof"
appendfsync          every...

Redis Persistence on Ubuntu 24.04

RDB snapshots (redis.conf)

save 900 1
save 300 10
save 60 10000
dbfilename  dump.rdb
dir         /var/lib/redis
rdbcompression yes
rdbchecksum    yes

AOF (Append-Only File)

appendonly           yes
appendfilename       "appendonly.aof"
appendfsync...