Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C0C659FB7B1 for ; Wed, 28 Feb 2007 00:21:09 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 87788-02 for ; Wed, 28 Feb 2007 00:21:08 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from vms048pub.verizon.net (vms048pub.verizon.net [206.46.252.48]) by postgresql.org (Postfix) with ESMTP id E9EAE9FB62B for ; Wed, 28 Feb 2007 00:21:06 -0400 (AST) Received: from new-host.home ([71.166.59.121]) by vms048.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0JE50000TO2JABK1@vms048.mailsrvcs.net> for pgsql-ports@postgresql.org; Tue, 27 Feb 2007 22:20:43 -0600 (CST) Date: Tue, 27 Feb 2007 23:20:27 -0500 From: Robert Treat Subject: Re: bundling postgres with an application In-reply-to: <45E3CD96.3050904@gmail.com> To: pgsql-ports@postgresql.org Cc: zluspai Message-id: <200702272320.27816.xzilla@users.sourceforge.net> MIME-version: 1.0 Content-type: text/plain; charset=iso-8859-2 Content-transfer-encoding: 7bit Content-disposition: inline References: <45E3CD96.3050904@gmail.com> User-Agent: KMail/1.9.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/13 X-Sequence-Number: 2536 On Tuesday 27 February 2007 01:20, zluspai wrote: > Dear Community, > > We would like to bundle and ship PostgreSQL latest with our java (Tomcat > web~) application, that way so PostgreSQL server would be automatically > started and stopped by our app. It should run on Windows, and recent > versions of Suse, Fedora and RedHat linux distributions. There are few > questions arise: > - Do we need to compile PostgreSQL to a different binary for each of the > mentioned linuxes, or is there an 'universally' compatible binary we > could use? I did see that there are different RPMS for different Fedora > and RedHat versions, that suggests we need to build it, is it correct? I would imagine you will need to compile postgres for each distribution; especially when you take into account different versions and hardware. > - Also we would like to reduce the distribution size, so what would be > the minimum set of files we need to ship? The requirement is to have > UTF8 and jdbc/socket connection support to our database. > Note you can ship just the binaries and then do initdb with your install program (wich will create many more files). The easiest way to get a list is to compile the package and then look through the listed files for what you need. There may well be things like contrib scripts or binary programs you do not need to ship. I think the list we also be different between win32 and linux (though not entirely certain). -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL