From: Mike <1100100@gmail.com>
To: operationsengineer1@yahoo.com <operationsengineer1@yahoo.com>
Cc: pgsql-novice@postgresql.org
Subject: Re: PGDATA - SOLVED
Date: Tue, 14 Jun 2005 16:41:45 -0400
Message-ID: <8ca4228205061413412de7e75e@mail.gmail.com> (raw)
In-Reply-To: <20050614193443.72767.qmail@web33311.mail.mud.yahoo.com>
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=/var/lib/postgresql/data
Mike
On 6/14/05, operationsengineer1@yahoo.com <operationsengineer1@yahoo.com> wrote:
> --- 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
>
> ---------------------------(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
>
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: 1100100@gmail.com, operationsengineer1@yahoo.com, pgsql-novice@postgresql.org
Subject: Re: PGDATA - SOLVED
In-Reply-To: <8ca4228205061413412de7e75e@mail.gmail.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