postgresql: Fix regression introduced in previous commit

Methods snapshot_get and snapshot_get_branches should return
None if the snapshot does not exist in the archive.

Add missing tests to cover that case.