Hi, I suspect that Sun's "official" documentation for PostgreSQL's SMF integration (http://www.sun.com/software/solaris/howtoguides/postgresqlhowto.jsp#2) is not what the PostgreSQL folks would readily call "carefully written": http://archives.postgresql.org/pgsql-admin/2007-02/msg00169.php.
The crux is that the "parent" postmaster process should be started by a process which itself is not owned by the "postgres" user - if my understanding of the PostgreSQL recommendation is correct. I do not know how to achieve this behaviour with SMF, but I suspect that above mentionned Sun documentation does not do it. Any comment appreciated. Peter This message posted from opensolaris.org