Re: Embedding postgresql in an application

There were good suggestions in this thread from sticking with apt-get to a VM based solution.

I was thinking about the article that I found which provided command line installations on Windows from a zip file. Although my original question was about the Ubuntu platform, I believe that the approach of running commands (verses GUI installer), using the same commands against the platform specific zip files also has some values. At the minimum it provides a portable solution across all operating system platforms.

Once again thanks to all who responded. I just need to sit down and try out these different options and perhaps I will make a U turn and go back to good old apt-get install solution.

Best Regards,
Sam

--- On Fri, 3/29/13, Sam Talebbeik <sam777t(at)yahoo(dot)com> wrote:

> From: Sam Talebbeik <sam777t(at)yahoo(dot)com>
> Subject: Re: [sfpug] Embedding postgresql in an application
> To: "SF Postgres" <sfpug(at)postgresql(dot)org>, "Steve Atkins" <steve(at)blighty(dot)com>
> Date: Friday, March 29, 2013, 5:51 PM
> Thanks to all who responded. My
> research so far has led me to this article where the author
> was able to do what I need on Windows. Perhaps the same
> steps work on Ubuntu.
>
> http://www.petrikainulainen.net/programming/tips-and-tricks/installing-postgresql-9-1-to-windows-7-from-the-binary-zip-distribution/
>
> I was also a bit surprised that he has used the binary
> distribution from enterprise db web site and apparently he
> has had success without using their installer. So, I thought
> I would ask the forum to get more feedback and
> confirmation.
>
>     Regards,
>     Sam
>
>
> --- On Fri, 3/29/13, Steve Atkins <steve(at)blighty(dot)com>
> wrote:
>
> > From: Steve Atkins <steve(at)blighty(dot)com>
> > Subject: Re: [sfpug] Embedding postgresql in an
> application
> > To: "SF Postgres" <sfpug(at)postgresql(dot)org>
> > Date: Friday, March 29, 2013, 4:31 PM
> >
> > On Mar 29, 2013, at 4:20 PM, Sam Talebbeik <sam777t(at)yahoo(dot)com>
> > wrote:
> >
> > > Folks, I need to manually install postgresql on
> Ubuntu.
> > I can not do apt-get install.
> >
> > You're probably going to rethink that, sooner or later.
> I'd
> > avoid doing anything
> > with your current method that'll make it difficult to
> > migrate to OS-supported
> > versions in the future.
> >
> > > 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?
> >
> > Other than all the .deb packaged or openscg versions
> it's
> > probably the next place to look. It's
> > not really "officially sanctioned" in any meaningful
> way,
> > it's just another option.
> >
> > If you can't use a packaged version, and you're
> distributing
> > other software anyway, you
> > might be better just building postgresql from source
> and
> > distributing it along with your
> > app that way. It's a pretty painless build, and it'll
> let
> > you modify paths and suchlike to
> > match your package file structure easily.
> >
> > If you're doing much with the database it'd be polite
> to
> > give users the option to point
> > your app at a different installation of postgresql (I
> have a
> > dedicated database server,
> > and PG backed apps all talk to that, so HA just has to
> live
> > in one place, for instance).
> >
> > If not, and it's really an embedded database, sqlite
> is
> > another option to look at.
> >
> > Cheers,
> >   Steve
> >
>
>