5.9.2 Security & access
Every entry filed under Security & access and its subtopics.
What kind of help
- Guided project 0
- Explains an idea 1
- Step by step 6
- Cheat sheet 0
- Fixes an error 6
What do these mean?
- Beginner
- You are new to this topic.
- Intermediate
- You use it, and want to get better.
- Advanced
- You know it well and need the details.
- Guided project
- Build something small from start to finish, step by step.
- Explains an idea
- Plain words on how something works and why.
- Step by step
- Numbered steps to get one task done.
- Cheat sheet
- Commands and options in a table, to look up fast.
- Fixes an error
- An error message, what it means, and how to solve it.
8 entries match these filters
- 0324 Fix: psql: FATAL: Peer authentication failed On local socket connections PostgreSQL checks that your OS user name equals the database role. When they differ you get this error.… Intermediate · Fixes an error · Linux Article Install & connect · Security & access 15 Oct 2026
- 0233 Turn on MongoDB authentication and create least-privilege users A fresh MongoDB install accepts connections without a password. Create a user administrator, enable authorization, then give each application and backup job… Intermediate · Step by step · Linux Article Administration · Security & access 15 Oct 2026
- 0243 Database backup strategy: the 3-2-1 rule and testing restores Keep three copies of your data on two kinds of storage with one copy offsite, choose dump or snapshot methods per database,… Intermediate · Step by step · Linux Article Database operations · Security & access 15 Oct 2026
- 0201 pg_hba.conf and PostgreSQL authentication methods pg_hba.conf decides who may connect from where and how they must prove who they are. Rules are checked top to bottom and… Intermediate · Explains an idea · Linux Article Install & connect · Security & access 15 Oct 2026
- 0209 Fix: FATAL: password authentication failed for user PostgreSQL reached the server and found a matching pg_hba.conf rule, but the password check failed. Usually a wrong password, a role without… Intermediate · Fixes an error · Any system Article Roles & administration · Security & access 15 Oct 2026
- 0210 Fix: FATAL: no pg_hba.conf entry for host The server received the connection but no pg_hba.conf rule matches this client address, user, database and SSL mode. Add or correct a… Intermediate · Fixes an error · Linux Article Install & connect · Security & access 15 Oct 2026
- 0227 Fix: ORA-01017: invalid username/password; logon denied Oracle rejected the login. Check the password (case-sensitive), that you connect to the right PDB service, and whether the account is locked… Intermediate · Fixes an error · Any system Article Administration · Security & access 15 Oct 2026
- 0200 PostgreSQL roles, privileges and default privileges Create login and group roles, grant access to databases, schemas and tables, and use ALTER DEFAULT PRIVILEGES so tables created later get… Intermediate · Step by step · Linux Article Roles & administration · Security & access 15 Oct 2026