PDA

View Full Version : installing PostgreSQL



NewsArchive
10-05-2013, 08:07 AM
Does anyone have any guidelines to do a completely automated PostgreSQl
install as part of my normal installation package? I am switching my C8 app
from .TPS and the IP driver to PostgreSQL and want to see what I will need
to do with my SetupBuilder installer. I want to make the Postgres part of
the install totally automated and transparent to the user (if possible).

regards,

Chuck

NewsArchive
10-06-2013, 01:29 PM
Chuck,

PostgreSQL 8.x (MSI based) or PostgreSQL 9.x (non-MSI based), x86 or x64?

Friedrich

NewsArchive
10-06-2013, 01:29 PM
I will be using PostgreSQL 9.x (non-MSI based), most likely x86 as I cannot
be sure all my users are using 64-bit windows.

regards,

Chuck

NewsArchive
10-06-2013, 01:30 PM
Chuck,

Clarion 32-bit requires 32-bit psqlodbc which only works with PostgreSQL
32-bit (x86) servers.

....jack

--
********************************************
Who: L Jack Wilson
Where: ljwilson@dNiOgSiPtAaMlav.com
How: Remove Capital Letters from above for a valid email address
Why: Standard Disclaimer fits nicely here.

NewsArchive
10-06-2013, 01:31 PM
Jack,

Thanks - my lack of a comprehensive overview of this is obvious. I have not
used ODBC in the past so this is all a new learning curve.

regards,

Chuck

NewsArchive
10-06-2013, 01:31 PM
Chuck,

In addition to what Jack said, the PostgreSQL 9.x (non-MSI based)
redistributable supports the following switches:

--unattendedmodeui <unattendedmodeui> Unattended Mode UI
Default: minimal
Allowed: none minimal minimalWithDialogs

--optionfile <optionfile> Installation option file
Default:

--debuglevel <debuglevel> Debug information level of verbosity
Default: 2
Allowed: 0 1 2 3 4

--mode <mode> Installation mode
Default: qt
Allowed: qt win32 unattended

--debugtrace <debugtrace> Debug filename
Default:

--installer-language <installer-language> Language selection
Default: en
Allowed: en es fr

--extract-only <extract-only>
Default: 0

--superaccount <superaccount> Sets the user name of the database
superuser. Defaults to 'postgres'.
Default: postgres

--servicename <servicename> Sets the name of the database service.
Default:

--serviceaccount <serviceaccount> Sets the operating system user account
that owns the server process. Defaults to
'postgres'.
Default:

--servicepassword <servicepassword> Sets the password for the operating
system user account that owns server
process.
Defaults to superuser password.
Default:

--install_runtimes <install_runtimes> Specifies whether or not install the
Microsoft Visual C++ runtimes before the
installation proceeds.
Default: 1

--create_shortcuts <create_shortcuts> Specifies whether or not menu
shortcuts should be created.
Default: 1

--prefix <prefix> Installation Directory
Default: C:\Program Files\PostgreSQL\9.3

--datadir <datadir> Data Directory
Default: C:\Program
Files\PostgreSQL\9.3\data

--superpassword <superpassword> Password
Default:

--serverport <serverport> Port
Default: 5432

--locale <locale> Locale
Default:

Friedrich

--
Friedrich Linder
Lindersoft
www.lindersoft.com
+1.954.252.3910

--Helping You Build Better Installations
--SetupBuilder "point. click. ship"
--Create Windows 8 ready installations in minutes
--Official COMODO Code Signing and SSL Certificate Partner

NewsArchive
10-06-2013, 01:32 PM
I believe the 32-bit ODBC driver (which _is_ required for Clarion) can
talk to either 32-bit or 64-bit PostgreSQL databases.

Mike Hanson
www.boxsoft.net

NewsArchive
10-06-2013, 01:32 PM
At least that's what I was told. ;)

Mike Hanson
www.boxsoft.net

NewsArchive
10-06-2013, 01:33 PM
Chuck,

I bundle the EnterpriseDB (edb) one-click installer
(postgresql-9.2.4-1-windows.exe for example) in my SB install file and
call it from there.

For psqlodbc I use the msi install (psqlodbc.msi) since I've found the
one that edb creates which you can download with their Application Stack
Builder isn't always the latest psqlodbc version.

The nice thing about using the standard one-click installer is I can
download an upgrade and install it directly, independent of my SB
install, which can come in handy sometimes.

Figuring out the silent command options can be a little tricky. This is
what I use (I install the PostgreSQL server in a subdirectory of my main
program).

Run Program %TMPDIR%\[MY_POSTGRES_INSTALLER] --mode unattended
--prefix "%_SB_INSTALLDIR%\psql" --datadir "%_SB_INSTALLDIR%\psql\data"
--superpassword "mysuperpassword" (Always Install) [ShellExecuteEx]
[Wait] [Hide] [Elevated]

Where [MY_POSTGRES_INSTALLER] is set to postgresql-9.2.4-1-windows.exe

and for odbc something like:

Run Windows Installer %TMPDIR%\psqlodbc.msi /i /q ALLUSERS=1

....jack

--
********************************************
Who: L Jack Wilson
Where: ljwilson@dNiOgSiPtAaMlav.com
How: Remove Capital Letters from above for a valid email address
Why: Standard Disclaimer fits nicely here.

NewsArchive
10-06-2013, 01:34 PM
Jack,

What would be the difference in postgresql-9.2.4-1-windows.exe which is
~50mb

and ppasmeta-9.2.1.3-windows.exe which is 176mb (other than the version) ?

regards,

Chuck

NewsArchive
10-06-2013, 01:35 PM
ppas is Postgres Plus Advanced Server. It is edb's commercial offering,
which emulates Oracle Server using PostgreSQL.

http://www.enterprisedb.com/products-services-training/products/postgres-plus-advanced-server

....jack

--
********************************************
Who: L Jack Wilson
Where: ljwilson@dNiOgSiPtAaMlav.com
How: Remove Capital Letters from above for a valid email address
Why: Standard Disclaimer fits nicely here.

NewsArchive
10-06-2013, 01:36 PM
Cool. Thanks, Jack!

Mike Hanson
www.boxsoft.net

NewsArchive
10-07-2013, 07:51 AM
Friedrich,

Thanks for the comprehensive list - I will be able to put it to good use.

regards,

Chuck

NewsArchive
10-14-2013, 12:58 AM
Mike,

Apparently you were told correctly :-)

I just had some time to test this--installed the latest PostgreSQL
Server 9.3.1 64-bit for Windows on a Windows 8.0 64-bit workstation, and
was able to connect to the PostgreSQL 64-bit server from another client
workstation running my 32-bit Clarion 9.0 app using the psqlodbc
09.02.01.00 32-bit odbc driver installed on the client.

Thanks for making me rethink this--I've been under the wrong impression
for a few years now.

So in summary:

Clarion 32-bit compiled apps using odbc require the 32-bit psqlodbc odbc
driver to communicate with PostgreSQL Server, BUT the 32-bit psqlodbc
driver can talk to both 32-bit and 64-bit PostgreSQL Servers.

Thanks...jack

--
********************************************
Who: L Jack Wilson
Where: ljwilson@dNiOgSiPtAaMlav.com
How: Remove Capital Letters from above for a valid email address
Why: Standard Disclaimer fits nicely here.

NewsArchive
10-14-2013, 05:42 AM
You're welcome. <g>

Mike Hanson
www.boxsoft.net