A comprehensive guide to PostgreSQL replication methods including streaming and logical replication for high availability and scalability