Have noticed most of the posts deal with postgres 8.3. I am working with snv-87
which has /usr/postgres/8.3 available but
svc:/application/database/postgresql:version_83 is not a FMRI. So I've been
working with postgresql:version_82. Initially I wanted it to be in
/export/home/postgres/data and had no trouble populating that directory but
svc: would always go straight to maintenance also noticed it would also
populate /var/postgres/8.2/data even though not directed to do so.
Anyway gave up on that and have no trouble populating /var/postgres/8.2/data
only and getting svc:/application/database/postgresql:version_82 enabled but
when I attempt to createusers it always gives : FATAL: role "root" does not
exist. What does exist default? How can I add users? Would postgres 8.3 work
better? How can I get svc:version listing for it? Can not createdb either
without error.
Sorry for the novice questions any advice would be appreciated.
