I'm not familiar with the greatbridge installer, but It shouldn't matter what source is used for postgresql, be it an rpm, the greatbridge installer or a tarball. Just make sure that you're installing a 7.0.x series version of postgresql. The newer 7.1 version of postgresql that is in beta now is known to break a few things in the current version of openacs, but some people are working to cleanup those queries so that the current version of openacs will also work for pg 7.1.