Two my PostgreSQL project in this year

In this years I faced with PostgreSQL in two my freelancer project, on first project I need terabyte size db, I want to connect Hetzner storage to DB, but failed. With local DB on Kamatera all working fine, but local storage of terabyte DB was so expensive for customer and project was closed.

On second project database provided with ancient version of PostgreSQL engine, current pgAdmin can not working with ancient Db engine and I must reinstalled my local pgAdmin for relevant version. It strange feature, In MySQL or MsSQL we always can use any control panel to any server version.

Than I have understand that I need local version. And I'm faced to very strange PostgreSQL future, it allow to make backup with clear SQL, but can not restore the same file what he backup. Even in last version!

However I overcome all difficulties, restore DB on my local computer.

And third strange and unusual future I'm faced on PostgreSQL is absent options to log SQL Query only, without various trash in log.

So, server and control panel looks strange and not finished, usually for MySQL and MsSQL functions not supported, but overcome that issues is possible.

Comments ( )