pg.ddx.io  pgsql-ports@postgresql.org mailing list archive  
help / color / mirror / Atom feed
bundling postgres with an application
2+ messages / 2 participants
[nested] [flat]

* bundling postgres with an application
@ 2007-02-27 06:20  zluspai <zluspai@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: zluspai @ 2007-02-27 06:20 UTC (permalink / raw)
  To: pgsql-ports

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?
- 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.

Thank you for your comments in advance, I would happily read any similar 
experiences of yours.
Regards,
Zoltan



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: bundling postgres with an application
@ 2007-02-28 04:20  Robert Treat <xzilla@users.sourceforge.net>
  parent: zluspai <zluspai@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Robert Treat @ 2007-02-28 04:20 UTC (permalink / raw)
  To: pgsql-ports; +Cc: zluspai <zluspai@gmail.com>

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2007-02-28 04:20 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-02-27 06:20 bundling postgres with an application zluspai <zluspai@gmail.com>
2007-02-28 04:20 ` Robert Treat <xzilla@users.sourceforge.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox