Hi
I have solaris 10 update 5 installed. PostgreSQL with SMF is shipped with Solaris 10 update 5.
I could see two services installed on the OS.
svcs postgresql
disabled 14:58:36 svc:/application/database/postgresql:version_81
disabled 15:40:42 svc:/application/database/postgresql:version_82
I followed the steps to start postgres service given on Sun website...
PostgreSQL 8.2:
1. As root, su to postgres:
# su - postgres
2. Create PostgreSQL DB cluster:
$ /usr/postgres/8.2/bin/initdb -D /var/postgres/8.2/data
3. As root, use the SMF's svcadm command to start PostgreSQL:
# /usr/sbin/svcadm enable postgresql:version_82
now I could see one serive enabled.
svcs postgresql
disabled 14:58:36 svc:/application/database/postgresql:version_81
online 15:40:42 svc:/application/database/postgresql:version_82
Now, if I have a psql session connected and I try to disable the service using...
svcadm disable svc:/application/database/postgresql:version_82
the serivce goes to maintenance mode.
Now, if I try to clear and enable it again it still goes to maintenance mode.
It comes online only if I close the psql session and enable it again.
Can anyone help me know the way to check that postgres is in use?
Thanx in advance
Niraj