Re: PostgreSQL installation

Hi,

How can I create the user and database schema? While creating user it's
taking automatically windows log in account name. I am using ant for the
same purpose.

Thanks,

Shahbaz A. Tyagi
Sphere Networks

-----Original Message-----
From: Grzegorz Jaśkiewicz [mailto:gryzman(at)gmail(dot)com]
Sent: Monday, December 15, 2008 4:59 PM
To: Shahbaz A. Tyagi
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] PostgreSQL installation

On Mon, Dec 15, 2008 at 12:36 PM, Shahbaz A. Tyagi
<shahbaz(dot)tyagi(at)sphere(dot)ae> wrote:
>
>
> Hi,
>
>
>
> How can we make PostgreSQL db up and running with out using installer i.e.
> we want to build the db internally and ship the db along with our
> application and let our application run the DB. We don't want to include
the
> PostgreSQL installer along with our installer and create the db while
> installing.

install binaries,
create user that's going to run postgresql
create data directory
set PGDATA and PGPORT for that user
run initdb
adjust config file's acordingly
start postgres
create users, and dbs
and you're pretty much done.

--
GJ