ashchan (owner)

Fork Of

gist: 11536 by sunfmin Upgrade to PostgreSQL 8.3 o...

Revisions

gist: 134397 Download_button fork
public
Public Clone URL: git://gist.github.com/134397.git
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