Re: PostgreSQL Deployment

On Fri, Jan 07, 2005 at 06:31:35AM -0800, Hong Ji wrote:
> Hi
> I am new to PostgreSQL and interested in using PostgreSQL in our
> application.
> But I have questions regarding what our users have to do to install the
> software.
>
> I can not find documentation on how to deploy application which uses
> PostgreSQL.
>
> Or does the user have to run separate setup (beside our application's setup
> program) to just install PostgreSQL as server?

We bundle an installation of PostgreSQL in the same tarball as our
application (installed within our applications directory structure and
built to run on a different port by default, so that it doesn't clash
with a native postgresql, if any). As part of our install script we
run initdb, createuser etc., exactly as explained in the standard
postgresql install docs.

That works for us, as the application is usually running on a machine
that's mostly dedicated to it. More usually as a user I'd usually
prefer the option of using an already installed postgresql instance if
one were available.

Cheers,
Steve