We have Primary-secondary PostgreSQL Streaming replication.
I have done some testing.
2.Run some DML on secondary which is in Write mode(another new primary)
3.Down new primary
4.Re-attach with primary using pg_rewind utility.
So, Can we use these steps to create snapshot standby database like we have in Oracle database.