[databases-discuss] postgresql:version_82

john kroll jek0004 at sbcglobal.net
Wed May 28 21:37:08 PDT 2008


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.


More information about the databases-discuss mailing list