Re: Embedding postgresql in an application

Josh, I am trying to figure out all the reasons and navigate through this myself. I can give two reasons. It may or may not be strong reasons from your point of view.

1) customer expectations - they expect a turnkey solution tested against a specific version of the database. We control everything including access to the database and its upgrade. We do not want any admin to use apt-get and upgrade the database while the application is running.

2) A handful of cases where the database was installed on a machine behind a firewall which could not get outside and perform apt-get.

I have been able to manually install and bring up postgresql on Ubuntu 12.04 desktop version using the binary tar file from EnterpriseDB web site. It was very straightforward. I am not arguing that this is the most optimum way, but I still believe that the good old option of expanding a binary tar file on Unix should work and it may come handy in certain situations. Even Firefox folks have not abandoned this approach and you can still get the binary tar files from their ftp web site.

Regards,
Sam

--- On Tue, 4/2/13, Josh Berkus <josh(at)agliodbs(dot)com> wrote:

> From: Josh Berkus <josh(at)agliodbs(dot)com>
> Subject: Re: [sfpug] Embedding postgresql in an application
> To: sfpug(at)postgresql(dot)org
> Date: Tuesday, April 2, 2013, 1:07 PM
> On 03/29/2013 04:20 PM, Sam Talebbeik
> wrote:
> > Folks, I need to manually install postgresql on Ubuntu.
> I can not do
> > apt-get install.
>
> Why not?  The apt packages are excellent, up-to-date,
> and well-supported.
>
> > It appears that the only place that you can download
> binary
> > distributions is through the enterprise db web site.
> > http://www.enterprisedb.com/products-services-training/pgbindownload
> >
> > Is the enterprise db the only officially sanctioned
> place to get
> > binary distributions?
>
> For Ubuntu users, apt.postgresql.org is the recommended
> source.
>
> --
> Josh Berkus
> PostgreSQL Experts Inc.
> http://pgexperts.com
>
>