Skip site navigation (1) Skip section navigation (2)

Re: tables, where

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: tables, where
Date: 2001-03-29 17:49:33
Message-ID: 22967.985888173@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
Rich Shepard <rshepard(at)appl-ecosys(dot)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

In response to

Responses

pgsql-general by date

Next:From: Soma InterestingDate: 2001-03-29 17:51:54
Subject: Re: timestamp/function question
Previous:From: Soma InterestingDate: 2001-03-29 17:44:20
Subject: Re: timestamp/function question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group