#4 SSL support needed

[Gregory Youngblood]

It appears SSL support is not included in this install.

It would really be nice to have the SSL support added, or at least an
option. I run SSL with PostgreSQL on Linux. One of the things I
need to be able to do is connect to that database. Unfortunately, the
psql client from this does not have SSL.

I am looking to see if I can add it to the build, but I'm pretty new at
Mac deveopment, so I may not have the tools on here to add it if it
requires more than just basic stuff to build.

On the other hand, I really do appreciate the Mac native build here.
Good job folks.

Greg

[Andy Satori]

Logged In: YES
user_id=14839

Which version are you running? SSL should be enabled, and appeared
to be on in testing, though the default commandline used in the
startupscript doesn't turn it on. You can of course modify the
Postgresql.conf file to turn it on as well, but the defaults generated by
the initdb don't turn it on.

[Gregory Youngblood]

Logged In: YES
user_id=212849

PostgreSQL 8.0.1b, the dmg file.

I was looking to use psql to connect to remote postgres
server that requires SSL connections. The psql tool in
/Library/PostgreSQL8/bin (?? think that's the path) fails to
connect due to lack of SSL support. The psql I built from
the postgres 8.0.1 source (from postgres.org), with SSL,
connects perfectly to the remote server.

Thanks

[Gregory Youngblood]

Logged In: YES
user_id=212849

I verified that 8.0.1b (Disk Image link on
http://www.druware.com/products/postgresql.html) does not
have SSL compiled in.

I will download the 8.0.1c files later today and try with them.

8.0.1b:
otool -L postmaster
postmaster:
/usr/lib/libz.1.dylib (compatibility version 1.0.0,
current version 1.0.0)
/usr/lib/libresolv.9.dylib (compatibility version
1.0.0, current version 324.9.0)
/usr/lib/libSystem.B.dylib (compatibility version
1.0.0, current version 71.1.1)

8.0.1 compiled from source:
otool -L postmaster
postmaster:
/usr/lib/libssl.0.9.7.dylib (compatibility version
0.9.7, current version 0.9.7)
/usr/lib/libcrypto.0.9.7.dylib (compatibility
version 0.9.7, current version 0.9.7)
/usr/lib/libz.1.dylib (compatibility version 1.0.0,
current version 1.0.0)
/usr/local/lib/libreadline.5.0.dylib (compatibility
version 5.0.0, current version 5.0.0)
/usr/lib/libresolv.9.dylib (compatibility version
1.0.0, current version 324.9.0)
/usr/lib/libSystem.B.dylib (compatibility version
1.0.0, current version 71.1.1)

[Gregory Youngblood]

Logged In: YES
user_id=212849

Confirmed. Downloaded 8.0.1c dmg file and installed. SSL libs are there.
Please close this feature request. And thank you for adding SSL. :)