Installation woes

This is a multi-part message in MIME format.

------=_NextPart_000_000C_01C4B55D.6B185800
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: 7bit

Fundamentally if the user wants to run my software then I want to get it
running on their hardware. If after they have tried it ( and hopefully
liked it) they want to use it as a business tool then I am in a position
to HIGHLY recommend the necessary upgrades to hardware/OS etc that they
may need.

Firstly there are no complaints about postgres or the installer both
work very well.

q1: I would like an almost silent install and to that effect have
located the following on the installer project site:

msiexec /i postgresql-8.0-beta2-dev3.msi datadir="C:\ghum\data"
LISTENPORT=5432 INITDBOK=1 DOSERVICE=1 DOINITDB=1
SERVICEID="pgsql-80-beta-2" SERVICENAME="PostgreSQL Database Server 8.0
beta 2" SERVICEACCOUNT="postgres" SERVICEPASSWORD="PasswordUserPostgres"
SERVICEPASSWORDV="PasswordUserPostgres" LOCALE="german"
ENCODING="LATIN1" SUPERUSER="postgres" SUPERPASSWORD="leberwurst"
SUPERPASSWORDV="leberwurst"

I would like the installer to show a "You are installing PostgreSQL V 8
" banner with a pointer to the postgresql.org website but still bypass
the normal installation questions..


q2: Is the above command in a format that is going to be supported in
later versions?

q3: Fat32 limitation. I have no evidence of the number of machines
using FAT32 with W2000 / XP but I expect it will be significant. What I
think I will have to do is put up a web page explaining the issues
unless such a page already exists with the postgres documentation?

q4: another option may be the cywin + postgres project. Does this let
users access older operating systems W98 / Millenium edition? If so then
is there a package my installer program can run? ie check OS/environment
if ok run pg v8 else give warning / option and install cygwin+postgres.
I don't mind if the install for W98 /fat32 is an older version of
postgres. Indeed an older version would be helpful in emhasising the
need to upgrade.

I suppose posgresql is not "normally" a enduser software product. It has
been designed as an industrial strength RDBMS for installation by
professionals. In that environment it excells. I will lookforward to
hearing how others are tackling the "embedded install".

best regards

Richard Sydney-Smith


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.772 / Virus Database: 519 - Release Date: 1/10/2004


------=_NextPart_000_000C_01C4B55D.6B185800
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3DWindows-1=
252">
<TITLE>Message</TITLE>

<META content=3D"MSHTML 6.00.2800.1476" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D171382813-18102004><FONT face=3DArial size=3D2>
<DIV><SPAN class=3D171382813-18102004><FONT face=3DArial
size=3D2>Fundamentally if the user wants to run my software then I wan=
t to
get it running on their hardware. If after they have tried it ( and hopeful=
ly
liked it) they want to use it as a business tool then I am in a position to=

HIGHLY recommend the necessary upgrades to hardware/OS etc that they may
need. </FONT> </SPAN></DIV>
<DIV><SPAN class=3D171382813-18102004> </DIV></SPAN></FONT></SPAN></DI=
V>
<DIV><SPAN class=3D171382813-18102004><FONT face=3DArial size=3D2>Firstly t=
here are no
complaints about postgres or the installer both work very
well.</FONT></SPAN></DIV>
<DIV><SPAN class=3D171382813-18102004><FONT face=3DArial
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D171382813-18102004><FONT face=3DArial size=3D2>q1: I wou=
ld like an
almost silent install and to that effect have located the following on the=

installer project site:</FONT></SPAN></DIV>
<DIV><SPAN class=3D171382813-18102004><FONT face=3DArial
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D171382813-18102004>msiexec /i postgresql-8.0-beta2-dev3.=
msi
datadir=3D"C:\ghum\data" LISTENPORT=3D5432 INITDBOK=3D1 DOSERVICE=3D1 DOINI=
TDB=3D1
SERVICEID=3D"pgsql-80-beta-2" SERVICENAME=3D"PostgreSQL Database Server 8.0=
beta 2"
SERVICEACCOUNT=3D"postgres" SERVICEPASSWORD=3D"PasswordUserPostgres"
SERVICEPASSWORDV=3D"PasswordUserPostgres" LOCALE=3D"german" ENCODING=3D"LAT=
IN1"
SUPERUSER=3D"postgres" SUPERPASSWORD=3D"leberwurst" SUPERPASSWORDV=3D"leber=
wurst"
</SPAN></DIV>
<DIV><SPAN class=3D171382813-18102004><FONT face=3DArial
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D171382813-18102004><FONT face=3DArial size=3D2>I would l=
ike the
installer to show a "You are installing PostgreSQL V 8 " banner with a poin=
ter
to the postgresql.org website but still bypass the normal installation
questions..</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT><FONT face=3DArial size=3D2></FONT>=
<FONT
face=3DArial size=3D2></FONT><FONT face=3DArial size=3D2></FONT><FONT face=
=3DArial
size=3D2></FONT><FONT face=3DArial size=3D2></FONT><FONT face=3DArial
size=3D2></FONT><BR></DIV>
<DIV><FONT face=3DArial><FONT size=3D2><SPAN class=3D171382813-18102004>q2:=

</SPAN>I<SPAN class=3D171382813-18102004>s the  above command in a for=
mat
that is going to be supported in later
versions?</SPAN></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=3D171382813-18102004><FONT face=3DArial
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D171382813-18102004>q3: Fat32 limitation. I have no=

evidence of the  number of machines using FAT32 with W2000 / XP but I=

expect it will be significant. What I think I will have to do is put up a w=
eb
page explaining the issues unless such a page already exists with the postg=
res
documentation?</SPAN></DIV>
<DIV><SPAN class=3D171382813-18102004><FONT face=3DArial
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D171382813-18102004><FONT face=3DArial size=3D2>q4: anoth=
er option
may be the cywin + postgres project. Does this let users access older opera=
ting
systems W98 / Millenium edition? If so then is there a package my installer=

program can run? ie check OS/environment if ok run pg v8 else give warning =
/
option and install cygwin+postgres. I don't mind if the install for W98
/fat32  is an older version of postgres. Indeed an older version would=
be
helpful in emhasising the need to upgrade.</FONT></SPAN></DIV>
<DIV><SPAN class=3D171382813-18102004><FONT face=3DArial
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D171382813-18102004><FONT face=3DArial size=3D2>I suppose=
posgresql
is not "normally" a enduser software product. It has been designed as an
industrial strength RDBMS for installation by professionals. In that enviro=
nment
it excells. I will lookforward to hearing how others are tackling the "embe=
dded
install".</FONT></SPAN></DIV>
<DIV><SPAN class=3D171382813-18102004><FONT face=3DArial
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D171382813-18102004><FONT face=3DArial size=3D2>best
regards</FONT></SPAN></DIV>
<DIV><SPAN class=3D171382813-18102004><FONT face=3DArial
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D171382813-18102004><FONT face=3DArial size=3D2>Richard=

Sydney-Smith</FONT></SPAN></DIV>
<DIV><SPAN class=3D171382813-18102004><FONT face=3DArial
size=3D2></FONT> </DIV></SPAN></BODY></HTML>
<BR>

<P><FONT SIZE=3D2>---<BR>
Outgoing mail is certified Virus Free.<BR>
Checked by AVG anti-virus system (http://www.grisoft.com).<BR>
Version: 6.0.772 / Virus Database: 519 - Release Date: 1/10/2004<BR>
</FONT> </P>

------=_NextPart_000_000C_01C4B55D.6B185800--
Richard [ Mo, 18 Oktober 2004 15:56 ] [ ID #453822 ]

Re: Installation woes

a1: Not 100% sure waht you are looing for. Try adding "/qb" and see if
that is what you meant :-)

a2: That exact commandline may not be supported. But we intend to
support commandline-driven silent installs, yes.

a3: See the installer FAQ on http://pginstaller.projects.postgresql.org.

a4: Yes, cygwin works on 9x platforms. And there is (will be, perhaps, I
think there are currently a few issues with it) a version 8.0 for cygwin
as well.


//Magnus


________________________________


Fundamentally if the user wants to run my software then
I want to get it running on their hardware. If after they have tried it
( and hopefully liked it) they want to use it as a business tool then I
am in a position to HIGHLY recommend the necessary upgrades to
hardware/OS etc that they may need.
=09
Firstly there are no complaints about postgres or the
installer both work very well.
=09
q1: I would like an almost silent install and to that effect
have located the following on the installer project site:
=09
msiexec /i postgresql-8.0-beta2-dev3.msi datadir=3D"C:\ghum\data"
LISTENPORT=3D5432 INITDBOK=3D1 DOSERVICE=3D1 DOINITDB=3D1
SERVICEID=3D"pgsql-80-beta-2" SERVICENAME=3D"PostgreSQL Database Server 8.0
beta 2" SERVICEACCOUNT=3D"postgres" SERVICEPASSWORD=3D"PasswordUserPostgres"
SERVICEPASSWORDV=3D"PasswordUserPostgres" LOCALE=3D"german"
ENCODING=3D"LATIN1" SUPERUSER=3D"postgres" SUPERPASSWORD=3D"leberwurst"
SUPERPASSWORDV=3D"leberwurst"
=09
I would like the installer to show a "You are installing
PostgreSQL V 8 " banner with a pointer to the postgresql.org website but
still bypass the normal installation questions..
=09
=09
q2: Is the above command in a format that is going to be
supported in later versions?
=09
q3: Fat32 limitation. I have no evidence of the number of
machines using FAT32 with W2000 / XP but I expect it will be
significant. What I think I will have to do is put up a web page
explaining the issues unless such a page already exists with the
postgres documentation?
=09
q4: another option may be the cywin + postgres project. Does
this let users access older operating systems W98 / Millenium edition?
If so then is there a package my installer program can run? ie check
OS/environment if ok run pg v8 else give warning / option and install
cygwin+postgres. I don't mind if the install for W98 /fat32 is an older
version of postgres. Indeed an older version would be helpful in
emhasising the need to upgrade.
=09
I suppose posgresql is not "normally" a enduser software
product. It has been designed as an industrial strength RDBMS for
installation by professionals. In that environment it excells. I will
lookforward to hearing how others are tackling the "embedded install".
=09
best regards
=09
Richard Sydney-Smith


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo [at] postgresql.org so that your
message can get through to the mailing list cleanly
mha [ Mo, 18 Oktober 2004 17:12 ] [ ID #453823 ]
Datenbanken » comp.databases.postgresql.sql » Installation woes

Vorheriges Thema: Database backup
Nächstes Thema: Inserting into table only if the row does not already exist.