Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 483729FB9CE for ; Wed, 17 Oct 2007 09:27:02 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 70658-06 for ; Wed, 17 Oct 2007 09:26:43 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.227]) by postgresql.org (Postfix) with ESMTP id DF1A99FB6E5 for ; Wed, 17 Oct 2007 09:26:58 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 68so1418766wri for ; Wed, 17 Oct 2007 05:26:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=dEGhgXf2OXfxPcUZeShZlppmwOQOLHDtCvUmT4NJPz4=; b=mzTR0JgYzz7ExLJCjc2Srb18ieOKeAL68x4kh4BuYnKZKcKmOg/2lnERvLSu+Rbkfno/e7Jy/eAMqdvfFUp18Qmj4FgNRRljnOMZNq0FDgWOl8zPDrOtMsjM5DJkjJtSiSNbwhbpTVpIUvjpVBcnfwj5ciLba+mqU9+1IK4q8ik= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=hROWgMOy3szNNA4UTVW6S/PD+OvVxIOt/ChoedXgL85T5etokKDBsIjIaFO1U0xkaUu3UXOEgknGgGX7ZKaFIqlQsJ8Sc8yJHqAw5aHfotbfLSIs+DBfPnqBjdQyEMQp8k13CYg2hEs3HWrzrhhFSY5pnsWFV3EKWl+dRvGY2Ng= Received: by 10.142.89.9 with SMTP id m9mr2427759wfb.1192624016741; Wed, 17 Oct 2007 05:26:56 -0700 (PDT) Received: by 10.142.157.10 with HTTP; Wed, 17 Oct 2007 05:26:56 -0700 (PDT) Message-ID: Date: Wed, 17 Oct 2007 08:26:56 -0400 From: "Greg Caulton" To: pgsql-admin@postgresql.org Subject: Re: installation automation In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/150 X-Sequence-Number: 27064 So I tested the theory - PGAdmin III ran and I could start and connect to the database and run the app successfully until saving data - the sequences seemed out of wack so overall that would be failure. Linux is sooo easy. Windows is sooo hard to eliminate user interaction in creating the services. I guess I can go back to using a zero admin database though I hit limitations with HSQL, perhaps JavaDB will take me further but I doubt it... I did run the database connection over the internet, works of course though slow, caching can offset that so I guess we shall see. Does Enterprise DB have a zero interaction solution I could perhaps buy with a small amount of money... Certainly the silent installer on the PostgreSQL was not silent for me unless I am missing something (quite possibly). Greg On 10/16/07, Greg Caulton wrote: > Hi, > > I am developing an open source healthcare information system and in > order to appeal to physician practises I need to have a 5 click > installation process - 4 nexts and one finish... > > The only item I am not able to do this with on Windows is PostgreSql > (which having worked with Oracle for years, this software is superb). > Linux is fine. > > The biggest problem is the creation of the user login, service, password etc. > > What I am going to test soon is can I simply unzip the contents of > Program Files\PostgreSQL\8.2\... and start the database server via a > shell script? > > Or are their registry or other configuration that the installer does? > > Since my software uses JBoss, starting the database server when the > application server starts is not too big a deal - for the demo at > least. > > thanks > > Greg > > PS I think I can get around it but one of the other issues is the > automatic disabling of standard username/password for security i.e. > psql -U username database -f mydbcontents.sql fails by default. I > believe I had to edit conf files though it was a while ago on Windows. >