Greetings Kam! I think I did some Screen Shots of when I did my Windows PostgreSQL installation the other year. I had to do some config file changes so it could be seen on the network by other PCs, and some other things. I did not do a Silent Install, but there are some other things you ought to be aware of in the setups that I found of value. Perhaps my ScreenShots would be of help in that regard.
Also, I scored an EXCELLENT book named "PostgreSQL For Windows", written by Richard Blum. I purchased an advance copy and had to wait 6 months to get it. It was very much worth the wait. Anyway, all of the other PostgreSQL books I picked up were written with a UNIX/Linux user in mind, with perhaps a slight mention of how to do a Windows installation, kind of... This book nails the Windows aspect of it very nicely. The VFP connectivity is something you will have to dig through. Be sure to get pcAdminIII (free) to help manage the PostgreSQL database. Now that I have a few Linux Servers cooking (Suse Enterprise Server v-10 and Ubuntu 7.10), both with PostgreSQL Server running on them, I am planning to migrate to that OS soon. That said, performance on my Windows Server 2003 machine has been excellent (Dell sc430 Server, P4 dual core 2.8 Ghz, 1Gb RAM, 7200 173Gb UltraWide SCSI). I am likely going to start using the Compaq Linux Server (Ubuntu v-7.10, P4 Dual Core 2.8Ghz, 1.5Gb RAM, 7,200 SATA HDD), just to get a feel for what that is all about. Anyway, I see your personal eMail is [EMAIL PROTECTED] I will send the ScreenShots as an attachment to that target address. If you prefer I send it elsewhere just let me know ([EMAIL PROTECTED]). Gil > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of kam > Sent: Monday, March 24, 2008 2:26 PM > To: [EMAIL PROTECTED] > Subject: Re: VFP and PostgreSQL used to process FTC DoNotCall updates > > > I just tried to install the 8.3.1 version on Windows. The > setup.bat has some examples which do not work. I am new to Postgresql and > would like to be able to do a silent install. Has anyone done > that? If so what is your command line? > > I used this and it does not work: > msiexec /i postgresql-8.3-int.msi /qr INTERNALLAUNCH=1 > ADDLOCAL=server,psql SERVICEDOMAIN="%COMPUTERNAME%" > SERVICEPASSWORD="SecretWindowsPassword123" > SUPERPASSWORD="VerySecret" BASEDIR="C:\PostgreSQL" /log install.log > > > > ----- Original Message ----- > From: "MB Software Solutions General Account" > <[EMAIL PROTECTED]> > To: "ProFox Email List" <[email protected]> > Sent: Monday, March 24, 2008 9:09 AM > Subject: Re: VFP and PostgreSQL used to process FTC DoNotCall updates > > > Gil Hale wrote: > > <snipped> One of my little tricks I use for > > SQL-SELECT processing with fairly large VFP tables (3 million > records, 78Mg > > table) about came in handy when pulling records with my VFP > parameterized > > view when the PostgreSQL records came over real slow. I issued a > RECCOUNT() > > (after performing a REQUERY() with the new Parameter value) against the > > Parameterized View, and POW! The records flew over pronto! Works great > for > > the 78Mg table following a SQL-SELECT, works just a well for the much > larger > > PostgreSQL table result set! > > > > I've heard this tip before. Wonder why it is the way it is? Why does > something so innocent/simple like that really add the POW! to the > equation I wonder? > > > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
