PostgreSQL - Adding to SVCS list.


 
Thread Tools Search this Thread
Operating Systems Solaris PostgreSQL - Adding to SVCS list.
# 1  
Old 11-19-2012
PostgreSQL - Adding to SVCS list.

I'm having some troubles setting an instance of postgreSQL to automatically start upon system boot. I have two servers running this app, one is automatically starting the service, the other is not. I'm attempting to use the "svcadmin" command, however, apparently when I run a "svcs -a" search, the appropriate instance doesn't display in the list of services.

Here's what a get with svcs -a | grep postgresql

disabled Nov_17 svc:/application/database/postgresql:version_81
disabled Nov_17 svc:/application/database/postgresql:version_82_64bit
online Nov_17 svc:/application/database/postgresql:version_82

However, none of these are the instance I'm looking to run.

version 8.2 is located in:

postgres 385 381 0 Nov 17 ? 0:02 /usr/postgres/8.2/bin/postgres -D /var/postgres/8.2/data

I'm looking to run this:

postgres 426 1 0 Nov 17 ? 0:01 /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data

How come the application located in /usr/local/pgsql, doesn't display in the service list? What can I do to make it appear as a service, or, just get this application to automatically start upon server boot? I appreciate any and all assistance.
# 2  
Old 11-19-2012
It appears you need to create a new service, try this set of instructions:

solaris 10: add new svc
# 3  
Old 11-19-2012
Quote:
Originally Posted by jim mcnamara
It appears you need to create a new service, try this set of instructions:
I found that info, however, there is no .xml for the server successfully running this service. It actually shows up when executing "svcs -a." I'd prefer avoiding this option as I assume, it should automatically show in the list of services.
# 4  
Old 11-19-2012
Can you post output of:
Code:
svccfg export svc:/application/database/postgresql

# 5  
Old 11-19-2012
Code:
<?xml version='1.0'?>
<!DOCTYPE service_bundle SYSTEM '/usr/share/lib/xml/dtd/service_bundle.dtd.1'>
<service_bundle type='manifest' name='export'>
  <service name='application/database/postgresql' type='service' version='0'>
    <dependency name='network' grouping='require_all' restart_on='none' type='service'>
      <service_fmri value='svc:/milestone/network:default'/>
    </dependency>
    <dependency name='filesystem-local' grouping='require_all' restart_on='none' type='service'>
      <service_fmri value='svc:/system/filesystem/local:default'/>
    </dependency>
    <exec_method name='start' type='method' exec='/lib/svc/method/postgresql start' timeout_seconds='60'>
      <method_context/>
    </exec_method>
    <exec_method name='stop' type='method' exec='/lib/svc/method/postgresql stop' timeout_seconds='60'>
      <method_context/>
    </exec_method>
    <exec_method name='refresh' type='method' exec='/lib/svc/method/postgresql refresh' timeout_seconds='60'>
      <method_context/>
    </exec_method>
    <property_group name='general' type='framework'>
      <propval name='action_authorization' type='astring' value='solaris.smf.manage.postgres'/>
      <propval name='value_authorization' type='astring' value='solaris.smf.value.postgres'/>
    </property_group>
    <instance name='version_81' enabled='false'>
      <method_context project=':default' resource_pool=':default' working_directory=':default'>
        <method_credential group='postgres' limit_privileges=':default' privileges=':default' supp_groups=':default' user='postgres'/>
      </method_context>
      <property_group name='postgresql' type='application'>
        <propval name='value_authorization' type='astring' value='solaris.smf.value.postgres'/>
        <propval name='bin' type='astring' value='/usr/bin'/>
        <propval name='data' type='astring' value='/var/lib/pgsql/data'/>
        <propval name='log' type='astring' value='server.log'/>
      </property_group>
    </instance>
    <instance name='version_82' enabled='true'>
      <method_context project=':default' resource_pool=':default' working_directory=':default'>
        <method_credential group='postgres' limit_privileges=':default' privileges=':default' supp_groups=':default' user='postgres'/>
      </method_context>
      <property_group name='postgresql' type='application'>
        <propval name='value_authorization' type='astring' value='solaris.smf.value.postgres'/>
        <propval name='bin' type='astring' value='/usr/postgres/8.2/bin'/>
        <propval name='data' type='astring' value='/var/postgres/8.2/data'/>
        <propval name='log' type='astring' value='server.log'/>
      </property_group>
    </instance>
    <instance name='version_82_64bit' enabled='false'>
      <method_context project=':default' resource_pool=':default' working_directory=':default'>
        <method_credential group='postgres' limit_privileges=':default' privileges=':default' supp_groups=':default' user='postgres'/>
      </method_context>
      <property_group name='postgresql' type='application'>
        <propval name='bin' type='astring' value='/usr/postgres/8.2/bin/64'/>
        <propval name='data' type='astring' value='/var/postgres/8.2/data_64'/>
        <propval name='log' type='astring' value='server.log'/>
        <propval name='value_authorization' type='astring' value='solaris.smf.value.postgres'/>
      </property_group>
    </instance>
    <stability value='Evolving'/>
    <template>
      <common_name>
        <loctext xml:lang='C'>PostgreSQL RDBMS</loctext>
      </common_name>
      <documentation>
        <manpage title='postgres_82' section='5'/>
        <doc_link name='postgresql.org' uri='http://postgresql.org'/>
      </documentation>
    </template>
  </service>
</service_bundle>


Last edited by Corona688; 11-19-2012 at 06:05 PM..
# 6  
Old 11-19-2012
Try doing this:
Code:
svccfg export svc:/application/database/postgresql > postgres.xml

Edit postgres.xml and add another <instance></instance> stanza after last </instance> tag, containing parameters related to your /usr/local installation. It might look like this (I named new instance "usr-local" here, you can choose any name you like):
Code:
<instance name='usr-local' enabled='false'>
      <method_context project=':default' resource_pool=':default' working_directory=':default'>
        <method_credential group='postgres'  limit_privileges=':default' privileges=':default' supp_groups=':default'  user='postgres'/>
      </method_context>
      <property_group name='postgresql' type='application'>
        <propval name='bin' type='astring' value='/usr/local/pgsql/bin'/>
        <propval name='data' type='astring' value='/usr/local/pgsql/data'/>
        <propval name='log' type='astring' value='server.log'/>
        <propval name='value_authorization' type='astring' value='solaris.smf.value.postgres'/>
      </property_group>
    </instance>

Import new service into SMF repository:
Code:
svccfg import postgres.xml

These 2 Users Gave Thanks to bartus11 For This Post:
# 7  
Old 11-20-2012
That did it! Thanks a bunch. Something I've been working on on/off, for the last week or so.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Adding a List of Times

Hey gang, I have a list of times I need to sum up. This list can vary from a few to a few thousand entries. Now I had found a closed reference to adding time titled "add up time with xx:yy format in bash how?" In it, the example works great for that formatted list of times... This is the reply code... (5 Replies)
Discussion started by: Brusimm
5 Replies

2. Shell Programming and Scripting

Check & use output of svcs command

Hello Dear Friends, I need to check output of svcs command and so the status of some instances. -bash-3.00$ svcs -a | grep rfe online Aug_04 svc:/application/rfe/rfe_master_3:default online Aug_04 svc:/application/rfe/rfe_master_4:default as you can see there are two... (1 Reply)
Discussion started by: EAGL€
1 Replies

3. Solaris

Solaris 10 svcs failures

I have a solaris 10 machine that was working fine until the system crashed after a power failure. Now, after the system boots up, several services go into maintenance mode. offline 8:54:59 svc:/milestone/multi-user-server:default offline 8:54:59... (15 Replies)
Discussion started by: krishani3831
15 Replies

4. Solaris

svcs command shows the state as disabled

Hi I need to export a directory named /sybase from my solaris machine via NFS. The svcs command shows the state as disabled. Please let me know how to export the directory. Once the directory is exported from the solaris machine it has to be mounted locally in an aix machine. Can some one... (2 Replies)
Discussion started by: newtoaixos
2 Replies

5. Solaris

svcs showing online* status

Hi Experts I am getting following status # svcs wbem STATE STIME FMRI online* 18:19:29 svc:/application/management/wbem:default /var/svc/log/application-management-wbem:default.log is being flooded with following message (5 Replies)
Discussion started by: mtomar
5 Replies

6. Shell Programming and Scripting

Adding Characters to a Word List

If I had a word list with a large amount of words in it, how would I (using a unix command) add, say, 123 to the end of each word? EDIT: The word list is stored in a large text file. I need a command that applies the ending to each word in the file and saves the result in a new text file. (7 Replies)
Discussion started by: evillion
7 Replies

7. Solaris

Solaris 10 svcs failures

upon rebooting the solaris 10 system, all the services went offilne or uninitialised. If I break the SVM mirror and reboot the system with the raw device, all services are up. Once I recreate a fresh mirror(metadevices) and reboot, it goes offline again. Needed to do svcadm clear <service> to bring... (16 Replies)
Discussion started by: incredible
16 Replies

8. UNIX for Advanced & Expert Users

Need svcs equivalent command

Hi, I am new to HP-UX. Can someboby help me with the svcs equivalent command in HP-UX ??? svcs is command that we use in Solaris for service status. I need to get the status of services in HP-UX. Thanks in advance. (2 Replies)
Discussion started by: EmbedUX
2 Replies

9. Shell Programming and Scripting

adding a list of numbers 3 by 3

i have a list of numbers like this; 124 235 764 782 765 451 983 909 ... and i want to make a sum with the first 3 of them then the next 3 and so on. 124+235+764=1123 782+765+451=1998 ... some ideas? (4 Replies)
Discussion started by: Tártaro
4 Replies

10. Solaris

svcs command on solaris 8 and 9

Hi, Can anybody tell me what is the command to start and stop services on solaris 8. I found command svcs on solaris 10 but not on 8 or 9. Please guilde me. Thanks, Rucha (7 Replies)
Discussion started by: rucha_mahajan
7 Replies
Login or Register to Ask a Question