I self host Postgres all the time. I just install it on my server. Sometimes i use RDS if a feel fancy.