Re: installing PostgreSQL
Chuck,
PostgreSQL 8.x (MSI based) or PostgreSQL 9.x (non-MSI based), x86 or x64?
Friedrich
Re: installing PostgreSQL
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
Re: installing PostgreSQL
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.
Re: installing PostgreSQL
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
Re: installing PostgreSQL
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
Re: installing PostgreSQL
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
Re: installing PostgreSQL
At least that's what I was told. ;)
Mike Hanson
www.boxsoft.net
Re: installing PostgreSQL
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.
Re: installing PostgreSQL
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