From: operationsengineer1@yahoo.com
To: pgsql-novice@postgresql.org
Subject: Re: PGDATA - SOLVED
Date: Tue, 14 Jun 2005 12:34:43 -0700 (PDT)
Message-ID: <20050614193443.72767.qmail@web33311.mail.mud.yahoo.com> (raw)
In-Reply-To: <20050614191810.8965.qmail@web33303.mail.mud.yahoo.com>
--- 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: operationsengineer1@yahoo.com, pgsql-novice@postgresql.org
Subject: Re: PGDATA - SOLVED
In-Reply-To: <20050614193443.72767.qmail@web33311.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox