DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type;
	b=qQSgoTH6DPCNIohxFdTKU5OeXNHLVeapfUuk7RdjhnqKHKLDdLIOL7VyjIc2qizu97
	2ENL3QWqvT6GpUwxuKaIittxryRWPJdWlhX+BQYa85k83u0bh//su7V+K+Pbon9SU+JO
	r5tlLvpny6FI4xiijTcLR55vaSqa8E/8K0/Jo=
MIME-Version: 1.0
Date: Fri, 19 Mar 2010 13:33:49 +0700
Message-ID: <99024f5f1003182333ra872d4bg56e60fdbcd6e474a@mail.gmail.com>
Subject: Re: Postgesql and SSL
From: Kiswono Prayogo <kiswono@gmail.com>
To: pgsql-admin@postgresql.org
Content-Type: text/plain; charset=UTF-8

Hi, i had the same problem building using latest cvs, it works fine on
64-bit ubuntu, but on 32-bit ubuntu (virtualbox) when i started the
postgres it shows:
# idir=/home/`whoami`/Software/PostgreSQL-9
# sudo su -p postgres -c "$idir/bin/postgres -D $idir/data" ;
LOG: SSL is not supported by this build
FATAL: invalid value for parameter "ssl": 1

* normally on my 64-bit, it shows:
LOG:  database system was shut down at 2010-03-19 12:02:00 WIT
LOG:  autovacuum launcher started
LOG:  database system is ready to accept connections
... query errors goes here ...^C
LOG:  received fast shutdown request
LOG:  aborting any active transactions
LOG:  autovacuum launcher shutting down
LOG:  shutting down
LOG:  database system is shut down

* my configuration (32-bit and 64-bit differ only on shared_buffers value)
# idir=/home/`whoami`/Software/PostgreSQL-9
# sudo cat $idir/data/postgresql.conf | egrep -v "^\s*(#|$)"
listen_addresses = 'localhost'          # what IP address(es) to listen on;
port = 5432                             # (change requires restart)
max_connections = 100                   # (change requires restart)
unix_socket_directory = '/tmp'          # (change requires restart)
ssl = true                              # (change requires restart)
password_encryption = on
shared_buffers = 28MB                   # min 128kB
datestyle = 'iso, mdy'
lc_messages = 'en_US.UTF-8'                     # locale for system
error message
lc_monetary = 'en_US.UTF-8'                     # locale for monetary formatting
lc_numeric = 'en_US.UTF-8'                      # locale for number formatting
lc_time = 'en_US.UTF-8'                         # locale for time formatting
default_text_search_config = 'pg_catalog.english'

* my build configuration:
# idir=/home/`whoami`/Software/PostgreSQL-9
# ./configure --with-pam --with-openssl --with-libxml --with-libxslt
--prefix=$idir && make && make install

* installed libraries (dpkg -l | grep ssl):
libssl-dev     0.9.8g-16ubuntu3.1
openssl       0.9.8g-16ubuntu3.1
libssl0.9.8    0.9.8g-16ubuntu3.1

* full script for download, compile and configuring
http://pastebin.com/vmzryH82

-- 
Regards,
Kiswono P
GB