Re: tables, where - Mailing list pgsql-general

From Tom Lane
Subject Re: tables, where
Date
Msg-id 22967.985888173@sss.pgh.pa.us
Whole thread Raw
In response to Re: tables, where  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: tables, where  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
Rich Shepard <rshepard@appl-ecosys.com> writes:
>   For example, (and this is what I tried with the 6.5.x series), in
> ~/.bash_profile I have this:

> PGLIB=/usr/lib/pgsql
> PGDATA=/var/lib/pgsql
> PGDATA2=/home/rshepard/accounting/paisley
> export PGLIB PGDATA PGDATA2

If this is in *your* .bash_profile then it's the wrong thing.  The
environment variables must be set in the *postmaster*'s environment.

The 7.1 documentation for alternative locations is perhaps better than
what we used to have:
http://www.postgresql.org/devel-corner/docs/postgres/managing-databases.html

            regards, tom lane

pgsql-general by date:

Previous
From: Soma Interesting
Date:
Subject: Re: timestamp/function question
Next
From: Soma Interesting
Date:
Subject: Re: timestamp/function question