I recently tried to migrate my database backup strategy to portabase. It has a (c)lean interface and can handle the most common database types (postgres, mysql/mariadb but also mongodb or redis). While setting up things looked promising (once you configured the agent it regularly checks connections using the provided credentials and shows the results). This […]
Category: Database
Categories
JSON data in postgres
While playing around with open-webui I managed to mess up the configuration more than once. In some situations this even led to an unresponsive system with even the configuration pages (to revert the latest changes) was no longer accessible. So I went for the database (postgres in my case) to revert those settings only to […]
It is possible to run scripts in netbox, both from the web GUI and also on the command line. However the usage is not very intuitive. so here’s a (very short) introduction. Basic knowledge First of all we need to know where to locate the scripts. That one is relatively easy: Place them into a […]
Categories
Convert postgres database dumps
Postgres can dump databases in 2 different formats: Both have their advantages and disadvantages. The later makes dumps better readable, so what can you do if your backup is using the first format? First let’s check the source format of our dump: Most online searches will result in: Restore the data to a new database […]