sunfmin (owner)

Forks

Revisions

gist: 11536 Download_button fork
public
Description:
Upgrade to PostgreSQL 8.3 on Joyent
Public Clone URL: git://gist.github.com/11536.git
Embed All Files: show embed
joyent_upgrade_to_postgresql83_history #
raw 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28

svcadm disable postgresql

svcadm disable mongrel/facts

curl -O http://ftp7.us.postgresql.org/pub/postgresql//source/v8.3.3/postgresql-8.3.3.tar.gz

gunzip postgresql-8.3.3.tar.gz

tar -xvf postgresql-8.3.3.tar

cd postgresql-8.3.3/

export LDFLAGS="-R/opt/csw/lib/:/usr/lib/"

./configure --with-libraries=/opt/csw/lib/:/usr/lib/ --with-includes=/opt/csw/include/:/usr/include/

sudo make install

/usr/local/pgsql/bin/psql --version

sudo mkdir /usr/local/pgsql/data

sudo chown postgres:postgres /usr/local/pgsql/data/

sudo su postgres -c "/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data"

svccfg export postgresql>postgresql833.smf

less postgresql833.smf 

cp /opt/csw/lib/svc/method/postgresql /opt/csw/lib/svc/method/postgresql83

vim /opt/csw/lib/svc/method/postgresql83 

chown root:bin /opt/csw/lib/svc/method/postgresql83*

svccfg import postgresql833.smf 

svcs

svcadm enable postgresql83

du -h /home/postgres/data/

df -hla

sudo vim /usr/local/pgsql/data/postgresql.conf

svcadm enable postgresql83

sudo su postgres -c "/usr/local/pgsql/bin/pg_dumpall -h localhost -U postgres -p 5432 | /usr/local/pgsql/bin/psql -U postgres -h localhost -p 9999"

svcadm enable postgresql83

svcadm enable mongrel/facts
postgresql.conf #
raw 
1
2
3
4
5
6
7
8

shared_buffers = 1024MB # default/32MB                  # min 128kB or max_connections*16kB

maintenance_work_mem = 128MB # default 16MB             # min 1MB

wal_buffers = 1MB #default 64kB                 # min 32kB

checkpoint_segments = 128 #default 3            # in logfile segments, min 1, 16MB each

checkpoint_completion_target = 0.9 #default 0.5 # checkpoint target duration, 0.0 - 1.0

effective_cache_size = 2048MB # default 128MB

 
 
postgresql83 #
raw 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80

#!/sbin/sh 
# 
# CDDL HEADER START 
# 
# The contents of this file are subject to the terms of the 
# Common Development and Distribution License (the "License"). 
# You may not use this file except in compliance with the License. 
 
# 
# You can obtain a copy of the license at usr/src/OPENSOLARIS.LICENSE 
# or http://www.opensolaris.org/os/licensing. 
# See the License for the specific language governing permissions 
# and limitations under the License. 
# 
# When distributing Covered Code, include this CDDL HEADER in each 
# file and include the License file at usr/src/OPENSOLARIS.LICENSE. 
# If applicable, add the following below this CDDL HEADER, with the 
# fields enclosed by brackets "[]" replaced with your own identifying 
# information: Portions Copyright [yyyy] [name of copyright owner] 
 
# 
# CDDL HEADER END
#PGPORT=9999
#export PGPORT
 
# Copyright 2006 Sun Microsystems, Inc. All rights reserved. 
# Use is subject to license terms. 
# 
# ident "%Z%%M% %I% %E SMI"
. /lib/svc/share/smf_include.sh 
 
# SMF_FMRI is the name of the target service. This allows multiple instances 
# to use the same script. 
 
getproparg() 
{     val=`svcprop -p $1 $SMF_FMRI` 
      [ -n "$val" ] && echo $val 
} 
 
PGBIN=/usr/local/pgsql/bin
PGDATA=`getproparg postgresql/data` 
PGLOG=`getproparg postgresql/log` 
 
if [ -z $SMF_FMRI ]; then 
     echo "SMF framework variables are not initialized." 
     exit $SMF_EXIT_ERR 
fi 
 
if [ -z $PGDATA ]; then 
 
     echo "postgresql/data property not set" 
     exit $SMF_EXIT_ERR_CONFIG 
fi
 
if [ -z $PGLOG ]; then 
 
     echo "postgresql/log property not set" 
     exit $SMF_EXIT_ERR_CONFIG 
fi 
 
case "$1" in 
'start') 
     $PGBIN/pg_ctl -D $PGDATA -l $PGDATA/$PGLOG start 
     ;; 
 
'stop') 
     $PGBIN/pg_ctl -D $PGDATA stop 
     ;; 
 
'refresh') 
     $PGBIN/pg_ctl -D $PGDATA reload 
     ;; 
*) 
 
     echo $"Usage: $0 {start|refresh}" 
     exit 1 
     ;; 
 
esac
exit $SMF_EXIT_OK
postgresql83.smf #
raw 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40

<?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/postgresql83' 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='/opt/csw/lib/svc/method/postgresql83 start' timeout_seconds='300'>

      <method_context/>

    </exec_method>

    <exec_method name='stop' type='method' exec='/opt/csw/lib/svc/method/postgresql83 stop' timeout_seconds='300'>

      <method_context/>

    </exec_method>

    <exec_method name='refresh' type='method' exec='/opt/csw/lib/svc/method/postgresql83 refresh' timeout_seconds='60'>

      <method_context/>

    </exec_method>

    <instance name='facts' 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='data' type='astring' value='/usr/local/pgsql/data'/>

        <propval name='log' type='astring' value='postgres83.log'/>

      </property_group>

    </instance>

    <stability value='Evolving'/>

    <template>

      <common_name>

        <loctext xml:lang='C'>PostgreSQL RDBMS</loctext>

      </common_name>

      <documentation>

        <manpage title='postgres' section='1M'/>

        <doc_link name='postgresql.org' uri='http://postgresql.org'/>

      </documentation>

    </template>

  </service>

</service_bundle>