is there any guide I can follow on how to connect to a postgres db on an external server (not on aurora)?

You should be able to just use a normal postgres library in your language to connect to it

ok, thanks