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]

Friedrich,

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

regards,

Chuck

[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]

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.