From: | <operationsengineer1(at)yahoo(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: PGDATA - SOLVED |
Date: | 2005-06-14 19:34:43 |
Message-ID: | 20050614193443.72767.qmail@web33311.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice pgsql-performance |
--- operationsengineer1(at)yahoo(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Mike | 2005-06-14 20:41:45 | Re: PGDATA - SOLVED |
Previous Message | Igor Katrayev | 2005-06-14 19:27:30 | Re: Set Membership operator -- test group membership |
From | Date | Subject | |
---|---|---|---|
Next Message | Mike | 2005-06-14 20:41:45 | Re: PGDATA - SOLVED |
Previous Message | operationsengineer1 | 2005-06-14 19:18:10 | PGDATA |