Re: Alternate database locations

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: Glen Parker <glenebob(at)nwlink(dot)com>
Cc: Pg-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Alternate database locations
Date: 2002-02-19 21:08:07
Message-ID: Pine.LNX.4.44.0202191306130.2601-100000@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 19 Feb 2002, Glen Parker wrote:

> your init script is using the '-s /bin/sh' argument to 'su', which means
> bash runs in compat mode (sh is a soft link to bash on linux), and does not
> use .bash_profile. you need to set up a file ~postgres/.profile (along side
> of .bash_profile) and put your PGDATA2 environment export in there, or
> possibly source .profile from .bash_profile. restart the postmaster and it
> should now work.

Glen,

I'll be darned! I haven't learned this about shells in the four years I've
been running linux here. Sure makes a difference 'cause now the alternate
location works. Perhaps this ought to go into the docs somewhere -- or a
FAQ.

Many thanks!

Rich

Dr. Richard B. Shepard, President

Applied Ecosystem Services, Inc. (TM)
2404 SW 22nd Street | Troutdale, OR 97060-1247 | U.S.A.
+ 1 503-667-4517 (voice) | + 1 503-667-8863 (fax) | rshepard(at)appl-ecosys(dot)com
http://www.appl-ecosys.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Wolfe 2002-02-19 21:36:11
Previous Message Bruce Momjian 2002-02-19 20:58:20 Re: Copying to float8 data type