DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=s7QDU7d5c9DfyQKFIirNJZ3N/tKQ666XCi9jQ8OnhVytVwmXdnSNPN0wr9AL6bVxbRmiZAksHGuuWySw4CCtYPSyRVJQUy2hzvBh1b/6cU5JHxMtdZx4C9T6DsBiV71ZzvNT3c1V7z2Yrqv8Gcz6fKT74UtsoWlQtiZWRX8tqDw=
Message-ID: <8ca4228205061413412de7e75e@mail.gmail.com>
Date: Tue, 14 Jun 2005 16:41:45 -0400
From: Mike <1100100@gmail.com>
Reply-To: Mike <1100100@gmail.com>
To: "operationsengineer1@yahoo.com" <operationsengineer1@yahoo.com>
Subject: Re: PGDATA - SOLVED
Cc: pgsql-novice@postgresql.org
In-Reply-To: <20050614193443.72767.qmail@web33311.mail.mud.yahoo.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <20050614191810.8965.qmail@web33303.mail.mud.yahoo.com>
	<20050614193443.72767.qmail@web33311.mail.mud.yahoo.com>

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=3D/var/lib/postgresql/data

Mike

On 6/14/05, operationsengineer1@yahoo.com <operationsengineer1@yahoo.com> w=
rote:
> --- operationsengineer1@yahoo.com wrote:
>=20
> > i currently develop on a winxp laptop.  i use cygwin
> > and my pgsql version is 7.4.x (x=3D3, 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...
>=20
> i was able to solve this one.  i added...
>=20
> export PGDATA=3D/usr/share/postgresql/data
> export
> PATH=3D/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/share/postgresql/data
>=20
> to my .bash_profile (i want a local configuration).
>=20
> now all i have to do in cygwin to start up pgsql is to
> type the following...
>=20
> first...
> cygserver &
>=20
> once cygserver is up and running, i hit [enter] to get
> a prompt then...
>=20
> second...
> pg_ctl start -o -i
>=20
> kinda cool for a rookie - and we won't mention i've
> been typing the directory path for almost a year...  -lol-
>=20
>=20
>=20
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail - Helps protect you from nasty viruses.
> http://promotions.yahoo.com/new_mail
>=20
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>