Service goes to maintenance state when stopping postgres

["Mahabaleshwarkar, Niraj (Niraj)" <mniraj@xxxxxxxxx>]

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