pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: PGDATA - SOLVED
2+ messages / 2 participants
[nested] [flat]
* Re: PGDATA - SOLVED
@ 2005-06-14 19:34 operationsengineer1@yahoo.com
0 siblings, 1 reply; 2+ messages in thread
From: operationsengineer1@yahoo.com @ 2005-06-14 19:34 UTC (permalink / raw)
To: pgsql-novice@postgresql.org
--- 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: PGDATA - SOLVED
@ 2005-06-14 20:41 Mike <1100100@gmail.com>
parent: operationsengineer1@yahoo.com
0 siblings, 0 replies; 2+ messages in thread
From: Mike @ 2005-06-14 20:41 UTC (permalink / raw)
To: operationsengineer1@yahoo.com <operationsengineer1@yahoo.com>; +Cc: pgsql-novice@postgresql.org
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
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-06-14 20:41 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-06-14 19:34 Re: PGDATA - SOLVED operationsengineer1@yahoo.com
2005-06-14 20:41 ` Mike <1100100@gmail.com>
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