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.
10 More Discussions You Might Find Interesting
1. Solaris
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
2. Shell Programming and Scripting
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
3. UNIX for Advanced & Expert Users
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
4. Solaris
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
5. Shell Programming and Scripting
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
6. Solaris
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
7. Solaris
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
8. Solaris
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
9. Shell Programming and Scripting
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
10. Shell Programming and Scripting
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
LEARN ABOUT CENTOS
pmdapostgresql
PMDAPOSTGRESQL(1) Performance Co-Pilot PMDAPOSTGRESQL(1)
NAME
pmdapostgresql - PostgreSQL database PMDA
DESCRIPTION
pmdapostgresql is a Performance Co-Pilot PMDA which extracts live performance data from a running PostgreSQL database.
INSTALLATION
pmdapostgresql uses a configuration file from (in this order):
o /etc/pcpdbi.conf
o $PCP_PMDAS_DIR/postgresql/postgresql.conf
This file can contain overridden values (Perl code) for the settings listed at the start of pmdapostgresql.pl, namely:
o database name (see DBI(3) for details)
o database username
Once this is setup, you can access the names and values for the postgresql performance metrics by doing the following as root:
# cd $PCP_PMDAS_DIR/postgresql
# ./Install
If you want to undo the installation, do the following as root:
# cd $PCP_PMDAS_DIR/postgresql
# ./Remove
pmdapostgresql is launched by pmcd(1) and should never be executed directly. The Install and Remove scripts notify pmcd(1) when the agent
is installed or removed.
FILES
/etc/pcpdbi.conf
configuration file for all PCP database monitors
$PCP_PMDAS_DIR/postgresql/postgresql.conf
configuration file for pmdapostgresql
$PCP_PMDAS_DIR/postgresql/Install
installation script for the pmdapostgresql agent
$PCP_PMDAS_DIR/postgresql/Remove
undo installation script for the pmdapostgresql agent
$PCP_LOG_DIR/pmcd/postgresql.log
default log file for error messages from pmdapostgresql
SEE ALSO
pmcd(1), pmdadbping.pl(1) and DBI(3).
3.8.10 Performance Co-Pilot PMDAPOSTGRESQL(1)