installing PostgreSQL

[NewsArchive]

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]

Chuck,

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

Friedrich

[NewsArchive]

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]

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]

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]

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]

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]

At least that's what I was told.

Mike Hanson
www.boxsoft.net

[NewsArchive]

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]

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