EPP + Site Publisher on Postgres 9.1 fails with "ERROR: relation "hibernate_sequence" does not exist Position: 17"

Issue

I've just installed EPP 5.2 and tried to configure it to connect to a local postgresql database. The install has failed to locate picket link database sequence in postgresql.
The server startup fails - the stack trace is attached

2012-04-07 08:11:05,387 ERROR [org.hibernate.util.JDBCExceptionReporter] (main) ERROR: relation "hibernate_sequence" does not exist
  Position: 17
2012-04-07 08:11:05,388 ERROR [exo.kernel.container.ExoContainer] (main) Cannot create the portal container 'portal' . ServletContext: org.apache.catalina.core.ApplicationContextFacade@18879c56
org.picocontainer.PicoIntrospectionException: Failed when calling start on org.exoplatform.services.organization.idm.PicketLinkIDMServiceImpl@4cb48371
    at org.exoplatform.container.LifecycleVisitor.traverse(LifecycleVisitor.java:136)
    at org.exoplatform.container.LifecycleVisitor.start(LifecycleVisitor.java:170)
    at org.exoplatform.container.ConcurrentPicoContainer.start(ConcurrentPicoContainer.java:552)
    at org.exoplatform.container.ExoContainer.start(ExoContainer.java:266)
    at org.exoplatform.container.PortalContainer.start(PortalContainer.java:667)
    at org.exoplatform.container.ExoContainer.start(ExoContainer.java:254)
    at org.exoplatform.container.RootContainer.createPortalContainer(RootContainer.java:399)
    at org.exoplatform.container.RootContainer.createPortalContainers(RootContainer.java:287)
    at org.exoplatform.container.web.PortalContainerCreator$2.run(PortalContainerCreator.java:74)
    at org.exoplatform.container.web.PortalContainerCreator$2.run(PortalContainerCreator.java:71)
    at org.exoplatform.commons.utils.SecurityHelper.doPrivilegedAction(SecurityHelper.java:289)
    at org.exoplatform.container.web.PortalContainerCreator.contextInitialized(PortalContainerCreator.java:70)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3910)
        .. .. ..
Caused by: java.lang.RuntimeException: org.picketlink.idm.common.exception.IdentityConfigurationException: Failed to build IdentitySessionFactory
    at org.exoplatform.services.organization.idm.PicketLinkIDMServiceImpl.start(PicketLinkIDMServiceImpl.java:258)
    at sun.reflect.GeneratedMethodAccessor375.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.exoplatform.container.LifecycleVisitor.traverse(LifecycleVisitor.java:100)
    ... 80 more
Caused by: org.picketlink.idm.common.exception.IdentityConfigurationException: Failed to build IdentitySessionFactory
    at org.picketlink.idm.impl.configuration.IdentityConfigurationImpl.buildIdentitySessionFactory(IdentityConfigurationImpl.java:151)
    at org.exoplatform.services.organization.idm.PicketLinkIDMServiceImpl.start(PicketLinkIDMServiceImpl.java:254)
    ... 84 more
Caused by: org.picketlink.idm.common.exception.IdentityException: Failed to populate relationship types
    at org.picketlink.idm.impl.store.hibernate.HibernateIdentityStoreImpl.bootstrap(HibernateIdentityStoreImpl.java:239)
    at org.picketlink.idm.impl.configuration.IdentityConfigurationImpl.createRealmMap(IdentityConfigurationImpl.java:192)
    at org.picketlink.idm.impl.configuration.IdentityConfigurationImpl.buildIdentitySessionFactory(IdentityConfigurationImpl.java:147)
    ... 85 more
Caused by: org.hibernate.exception.SQLGrammarException: could not get next sequence value
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:119)
    at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:121)
    at org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:154)
    at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:110)
    at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:61)
    at org.hibernate.impl.SessionImpl.firePersist(SessionImpl.java:648)
    at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:622)
    at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:626)
    at org.picketlink.idm.impl.store.hibernate.HibernateIdentityStoreImpl.populateRelationshipTypes(HibernateIdentityStoreImpl.java:2947)
    at org.picketlink.idm.impl.store.hibernate.HibernateIdentityStoreImpl.bootstrap(HibernateIdentityStoreImpl.java:230)
    ... 87 more