This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
postgresql [2022/05/02 16:08] – Jan Forman | postgresql [2022/05/03 12:10] (current) – Jan Forman | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Postgresql ====== | ||
+ | ===== Duplicate Layer ===== | ||
+ | < | ||
+ | |||
+ | < | ||
+ | Can be raised for SSDs | ||
+ | |||
+ | |||
+ | < | ||
+ | for I in `/ | ||
+ | / | ||
+ | done | ||
+ | </ | ||
+ | |||
+ | < | ||
+ | max_connections = 300 | ||
+ | shared_buffers = 80MB | ||
+ | </ | ||
+ | |||
+ | ===== Create read-only ===== | ||
+ | |||
+ | < | ||
+ | GRANT CONNECT ON DATABASE data TO plz; | ||
+ | GRANT USAGE ON SCHEMA public TO plz; | ||
+ | </ | ||
+ | |||
+ | ===== Remove user ===== | ||
+ | < | ||
+ | REVOKE ALL ON SCHEMA public FROM myuser; | ||
+ | REVOKE ALL ON DATABASE mydb FROM myuser; | ||
+ | DROP OWNED BY myuser; | ||
+ | DROP USER myuser; | ||
+ | </ | ||
+ | |||
+ | **List all sequences** | ||
+ | < | ||
+ | SELECT relname sequence_name FROM pg_class WHERE relkind = ' | ||
+ | </ | ||
+ | |||
+ | ===== Change user pass ===== | ||
+ | < | ||
+ | ALTER USER username WITH ENCRYPTED PASSWORD ' | ||
+ | </ |