DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=twJ7oAbT6GtvAU4RhDtALtKJKUjLS5qUnlFD92mVCiuQM/3/h6lstJ/frAw2PDnwCiXVgUTbJoEymApAk2KtsravSJf/rG0220ojJuGXPZioEd7AndUYVe4fXGiba4dz0u4ce6k8oluDJb+XlGGPClYVHSS97oV+2cxZyNmU52s=
	;
Message-ID: <20050614193443.72767.qmail@web33311.mail.mud.yahoo.com>
Date: Tue, 14 Jun 2005 12:34:43 -0700 (PDT)
From: <operationsengineer1@yahoo.com>
Subject: Re: PGDATA - SOLVED
To: pgsql-novice@postgresql.org
In-Reply-To: <20050614191810.8965.qmail@web33303.mail.mud.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

--- operationsengineer1@yahoo.com wrote:

> i currently develop on a winxp laptop.  i use cygwin
> and my pgsql version is 7.4.x (x=3, maybe?).
> 
> i have to manually start up apache and pgsql. i'm
> spending some time learning linux.  i found that i
> could edit my .bash_profile so i don't have to type
> the path to cygserver every time i tried to start
> it.
> 
> i'd like to do something similar when using pg_ctl
> to
> start and stop the postmaster.
> 
> i read the the help files for pg_ctl and it said
> PGDATA was the default if there was no -D flag and
> then a directy path to the data directory.
> 
> i want to set PGDATA path to my DATA directory, but
> i
> can't find PGDATA on my system.
> 
> can anyone help here?
> 
> tia...

i was able to solve this one.  i added...

export PGDATA=/usr/share/postgresql/data
export
PATH=/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/share/postgresql/data

to my .bash_profile (i want a local configuration).

now all i have to do in cygwin to start up pgsql is to
type the following...

first...
cygserver & 

once cygserver is up and running, i hit [enter] to get
a prompt then...  

second...
pg_ctl start -o -i

kinda cool for a rookie - and we won't mention i've
been typing the directory path for almost a year...  -lol-


__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - Helps protect you from nasty viruses. 
http://promotions.yahoo.com/new_mail