So, to be clear, you are trying to use a PostgreSQL administration tool to access a MariaDB server, and you’re asking why it’s not working?
Here, the last DB GUI you'll ever need: DBeaver
I just tried this but there doesn't seem to be a web interface to it. I was hoping I could use it accross my network on different devices.
Any reason why it needs a web interface? There are multiple solutions to work with applications from anywhere, probably the best and easiest is VDI.
pgAdmin only works with Postgres, that's why it refuses to connect to MariaDB. The equivalent for Maria and MySQL is phpMyAdmin. But I also suggest using a tool that can handle multiple types of databases, like DBeaver, dbForge, dbSchema, Navicat, HeidiSQL etc.
The „pg“ in pgAdmin has a meaning?
Thank you so much! I asked ChatGPT if pgAdmin was meant to work with MariaDB and it kept saying "yes. It should work" and giving me useless instructions. I thought I was the one doing something wrong.
Cloudbeaver:
version: "3.3"
services:
cloudbeaver:
container_name: cloudbeaver
image: dbeaver/cloudbeaver:23.2.0
restart: unless-stopped
ports:
- 8978:8978
environment:
- TZ=Europe/Berlin
- CB_SERVER_URL=http://192.168.20.50:8978
- CB_SERVER_NAME=Cloudbeaver
volumes:
- ./data:/opt/cloudbeaver/workspace
healthcheck:
test: "wget --no-verbose --tries=1 --spider --no-check-certificate http://localhost:8978 || exit 1"
start_period: 60sA place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.
For Example
We welcome posts that include suggestions for good self-hosted alternatives to popular online services, how they are better, or how they give back control of your data. Also include hints and tips for less technical readers.
Useful Lists