SOLVE ALL THE ERRORS!

How to solve “Npgsql: 42883: function create_hypertable(…) does not exist”?

Have you run into this puzzling error? It comes in a couple of flavors, but it boils down to you failing miserably when you run the create_hypertable() function on your PostgreSQL TimescaleDB database server! Annoyingly, it might mean that the whole function is missing (extension is not installed or loaded) or that your parameters are not properly parsed (an issue with your command). I know, that it sucks. I have been there. That’s why I wrote this article! Problem You’re trying to transform your PostgreSQL…Continue reading How to solve “Npgsql: 42883: function create_hypertable(…) does not exist”?

PostgreSQL everywhere

How to configure Azure PostgreSQL to allow Cloud Shell connections?

I was setting up a PostgreSQL database in Azure, to be used by a cutesy little Azure Function storing telemetry from a bunch of Azure IoT Edge Devices. But when everything was (supposed to be) configured successfully, my Azure Function failed to store anything anywhere because of a missing database… Oh, right. Entity Framework can’t create PostgreSQL databases, as the connection is made to an existing database – so it can’t be instantiated if the database doesn’t exist on the server already. So, what do…Continue reading How to configure Azure PostgreSQL to allow Cloud Shell connections?

PostgreSQL everywhere

How to run SQL commands in a Postgre SQL Docker container?

This article will explain how to run your arbitrary SQL commands against a Postgre SQL database running in a Docker container in Windows. That should be super simple, but since I never remember anything like this by heart, I had to google it – and turns out, either I didn’t know how to google this properly or people haven’t bothered to document this. So, let’s fix that. But first, why did I need to do this, again? Problem So – I meant to run some…Continue reading How to run SQL commands in a Postgre SQL Docker container?