X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B0AA432A35D for ; Mon, 18 Oct 2004 14:56:08 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 83261-02 for ; Mon, 18 Oct 2004 13:55:59 +0000 (GMT) Received: from gizmo10ps.bigpond.com (gizmo10ps.bigpond.com [144.140.71.20]) by svr1.postgresql.org (Postfix) with SMTP id B64FD32A31A for ; Mon, 18 Oct 2004 14:56:00 +0100 (BST) Received: (qmail 11505 invoked from network); 18 Oct 2004 13:55:51 -0000 Received: from unknown (HELO PSMAM17.bigpond.com) (144.135.25.116) by gizmo10ps.bigpond.com with SMTP; 18 Oct 2004 13:55:51 -0000 Received: from 144.138.247.172 ([144.138.247.172]) by PSMAM17.bigpond.com(MAM REL_3_4_2a 291/88699594) with SMTP id 88699594; Mon, 18 Oct 2004 23:55:51 +1000 From: "Richard Sydney-Smith" To: Subject: Installation woes Date: Mon, 18 Oct 2004 21:56:59 +0800 Message-ID: <000b01c4b51a$5cf51800$acf78a90@athlon2000> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000C_01C4B55D.6B185800" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.8 tagged_above=0.0 required=5.0 tests=HTML_30_40, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200410/107 X-Sequence-Number: 19210 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 Message
Fundamentally if the user wants to run my software then I wan= t to=20 get it running on their hardware. If after they have tried it ( and hopeful= ly=20 liked it) they want to use it as a business tool then I am in a position to= =20 HIGHLY recommend the necessary upgrades to hardware/OS etc that they may=20 need.  
 
Firstly t= here are no=20 complaints about postgres or the installer both work very=20 well.
 
q1: I wou= ld like an=20 almost silent install and to that effect have located the following on the= =20 installer project site:
 
msiexec /i postgresql-8.0-beta2-dev3.= msi=20 datadir=3D"C:\ghum\data" LISTENPORT=3D5432 INITDBOK=3D1 DOSERVICE=3D1 DOINI= TDB=3D1=20 SERVICEID=3D"pgsql-80-beta-2" SERVICENAME=3D"PostgreSQL Database Server 8.0= beta 2"=20 SERVICEACCOUNT=3D"postgres" SERVICEPASSWORD=3D"PasswordUserPostgres"=20 SERVICEPASSWORDV=3D"PasswordUserPostgres" LOCALE=3D"german" ENCODING=3D"LAT= IN1"=20 SUPERUSER=3D"postgres" SUPERPASSWORD=3D"leberwurst" SUPERPASSWORDV=3D"leber= wurst"=20
 
I would l= ike the=20 installer to show a "You are installing PostgreSQL V 8 " banner with a poin= ter=20 to the postgresql.org website but still bypass the normal installation=20 questions..
=
q2:= =20 Is the  above command in a for= mat=20 that is going to be supported in later=20 versions?
 
q3: Fat32 limitation. I have no= =20 evidence of the  number of machines using FAT32 with W2000 / XP but I= =20 expect it will be significant. What I think I will have to do is put up a w= eb=20 page explaining the issues unless such a page already exists with the postg= res=20 documentation?
 
q4: anoth= er option=20 may be the cywin + postgres project. Does this let users access older opera= ting=20 systems W98 / Millenium edition? If so then is there a package my installer= =20 program can run? ie check OS/environment if ok run pg v8 else give warning = /=20 option and install cygwin+postgres. I don't mind if the install for W98=20 /fat32  is an older version of postgres. Indeed an older version would= be=20 helpful in emhasising the need to upgrade.
 
I suppose= posgresql=20 is not "normally" a enduser software product. It has been designed as an=20 industrial strength RDBMS for installation by professionals. In that enviro= nment=20 it excells. I will lookforward to hearing how others are tackling the "embe= dded=20 install".
 
best=20 regards
 
Richard= =20 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--