Mastodawn

Setup #fail2ban to stop some random IP from hitting my #postgres server again and again. It would never have been able to authenticate, but not going to let that keep happening.

#selfhosting #dbadmin

Doug Ortiz Apr 14, 2025

Forgot how to change a PostgreSQL role password? 🤔

Just published a new chapter in my "Master Meta-Commands in PostgreSQL" LinkedIn Learning course showing how to change a role's password.

Perfect for those "wait, how do I do this again?" moments that happen to the best of us.

Watch it here: https://link.illustris.org/changepasswordforrole
#PostgreSQL #LinkedInLearning #DBAdmin #TechTips

Custom WordPress Plugins: Design, Develop, and Distribute | LinkedIn Learning, formerly Lynda.com

This course is designed to take you from a casual WordPress user to a capable plugin developer, guiding you through the creation of three distinct types of plugins: a custom post type plugin, a simple contact form plugin, and a basic social media sharing plugin. Through hands-on, step-by-step instruction, learn vital skills like registering custom post types, handling form submissions securely, and integrating popular social media sites. Take this course to not only create and customize your own plugins but also understand how to prepare them for submission to the WordPress Plugin Directory, empowering you to enhance WordPress sites with unique, functional tools–and possibly start your own plugin business.

Doug Ortiz Apr 8, 2025

Do You Know These Secret PostgreSQL Meta Commands? 🔍

Meta commands (starting with ) are PostgreSQL's hidden power tools for DBAs and developers!

These backslash commands let you explore database objects, get help, format output, and manage connections - all without writing complex SQL queries.

Learn how to access these productivity boosters: https://link.illustris.org/how2accessmetacommands
#PostgreSQL #DatabaseTips #MetaCommands #DBAdmin

Custom WordPress Plugins: Design, Develop, and Distribute | LinkedIn Learning, formerly Lynda.com

This course is designed to take you from a casual WordPress user to a capable plugin developer, guiding you through the creation of three distinct types of plugins: a custom post type plugin, a simple contact form plugin, and a basic social media sharing plugin. Through hands-on, step-by-step instruction, learn vital skills like registering custom post types, handling form submissions securely, and integrating popular social media sites. Take this course to not only create and customize your own plugins but also understand how to prepare them for submission to the WordPress Plugin Directory, empowering you to enhance WordPress sites with unique, functional tools–and possibly start your own plugin business.

Show thread

Özkan Pakdil Mar 31, 2025

@Aschenbrenner any #dba #dbadmin #mssql should be aware 🤓

Gytis Repečka Nov 12, 2024

Do not run databases in containers, if possible - do not run them in virtual machines either. Databases love bare metal

In fact, one evil red company even instructs bare metal deployment of their database for performance reasons

If you ever see container image of an application packed together with database - use it for development purposes only!

You'll thank me later

#sysadmin #dbadmin #virtualization #protip

Joaquim Homrighausen Mar 12, 2024

If phpMyAdmin gives you “Error text: OK (rejected)” … ✅🕵️😊

https://www.joho.se/2024/03/12/if-phpmyadmin-gives-you-error-text-ok-rejected

#phpmyadmin #errormessage #mysql #mariadb #percona #dbadmin #php #devops #phpdev #developers #programming

If phpMyAdmin gives you "Error text: OK (rejected)" ...

If you see this in phpMyAdmin: "Error text: OK (rejected) It seems that the connection to server has been lost. Please check your network connectivity and server status.", this may fix it.

joho.se

Mike Johnston Dec 23, 2022

When the documentation you write has a step about large database deletes:
"4. If the select query looks correct, change the query to a delete. A moment for prayer or non-secular routine (maybe grab a coffee and turn up your music to find a happy place) is appropriate at this point." #DBAdmin

BekahThe.Dev (She/Her)

Nov 22, 2022

It may be common knowledge but my mind was blown.

We're using CentOS and my DBAD (Database Admin) instructor hinted at the option to make user input variables in some of the new dictionary views we learned this module and using WHERE name = UPPER('&NAME') in the select statement.

I had no idea you could prompt for user input... I was in the middle of making 3 profiles, 9 roles,
16 users, granting them roles and/or privileges as I went, editing a text file in gedit with the new user data and pasting it into the terminal.

It may not actually be faster but it feels faster (I may be biased because I love database). The &UNLIMITED_QUOTA_TABLESPACE variable name is not the best and very long, use &QUOTA_TABLESPACE or something shorter, and the size can be changed to &SIZE_APPEND_M so you can enter 20M but we were using unlimited for the lab.

#CentOS #Oracle #SQL #DBA #OracleSQL #Database #DBAdmin #DBAD #CentOS5 #Oracle12c