Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id E9E589FB4C8 for ; Tue, 16 Oct 2007 09:55:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 97766-01 for ; Tue, 16 Oct 2007 09:55:21 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.234]) by postgresql.org (Postfix) with ESMTP id 8BF9D9FB4C6 for ; Tue, 16 Oct 2007 09:55:32 -0300 (ADT) Received: by nz-out-0506.google.com with SMTP id l8so1155424nzf for ; Tue, 16 Oct 2007 05:55:31 -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:mime-version:content-type:content-transfer-encoding:content-disposition; bh=3tIspZuFV0pmJHDIAB+8x/LJS+hT78nXpdSNy6wK4y8=; b=fGtGa/Y8lO2fiYD23v+H92Dzs1Aw9ay8N+fjUwDrhizHZCNWdjbS65Vdy4IlP8yAKiFV7u+rzSkFN0Xi3QyzZjOK+sXFpyKI+/BnYcUqQzvD9/mxWG69EwwB94sPommrrmWo5HY3iyQDOhU6jrEBMIC32Ir2WYJOOhl9OQRmQEk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=bgLuCA1I2LQaY/jJkM8/0J/ZndISB417GL2NkIqwiJ7VGI0JNHndv8B1V3ERTLggGrews6zHFCEzWhbAaDNZRfVCtdpXZVx1pGS7RaHnpnVO9EZghxbVFRLrRE7vICDXTnj0cubak6HennadKmkFoCRlkpVq34bsW6E9srq+USU= Received: by 10.142.110.3 with SMTP id i3mr1963161wfc.1192539330697; Tue, 16 Oct 2007 05:55:30 -0700 (PDT) Received: by 10.142.157.10 with HTTP; Tue, 16 Oct 2007 05:55:30 -0700 (PDT) Message-ID: Date: Tue, 16 Oct 2007 08:55:30 -0400 From: "Greg Caulton" To: pgsql-admin@postgresql.org Subject: installation automation MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/142 X-Sequence-Number: 27056 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.