--- 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
