Tips studying Postgres by a 11years DBA
Hello all. Im planning to start some Postgres study since my company is shifting to it. We are a giant tech, we have oracle sql Postgres informox across many teams , but it seems SQL became expensive ( yeah ) so they are moving to Postgres.
Im not excited losing my job so im trying to learn bit as always ,the beginning is super confusing .
Im going to study aurora, and since its more a RDS , what is close to SQL and what is different ?
Is th3 management the same as in SQL? Devs mebtion that Postgres is awesome ,but i jist could create an instance after 1 week (lots of permissions issues ).
Like backups , indexes,checkdbs, query tunning...is it all the same? Postgres people say yes, i thought its a little more complicated