Re: PGDATA - SOLVED

Mr. Operations, I've had a similar frustrating experience with PGDATA;
basically, i can't make it "stick." Once I shut down the postgresql
server the PGDATA configuration is cleared and has to be stated again
before starting postgres, or I'll get an error message.

So I had to insert the command into the system start-up process.
In Gentoo, it's /etc/conf.d/local.start
and the command that works is ---

export PGDATA=/var/lib/postgresql/data

Mike

On 6/14/05, operationsengineer1(at)yahoo(dot)com <operationsengineer1(at)yahoo(dot)com> wrote:
> --- 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>