On Sat, 27 Nov 1999, Lamar Owen wrote:
> 700 is the right permissions -- make sure that the postgres user is the
> owner of the PGDATA2.
Lamar,
Ah, ha! That must be the problem. The definition of PGLIB, PGDATA and
PGDATA2 are in *my* ~/.bash_profile. When I was logged in as postgres, I
set up user 'rshepard' with permission to create databases. But, when user
'rshepard' tries to create a database, the attempt fails.
Since the /home directory for user 'postgres' is /var/lib/pgsql, where do
I put the environment variables which define PGLIB, PGDATA and PGDATA2?
Especially so that the locations are available to other authorized database
creators and users?
TIA -- again,
Rich
Dr. Richard B. Shepard, President
Applied Ecosystem Services, Inc. (TM)
Making environmentally-responsible mining happen. (SM)
--------------------------------
2404 SW 22nd Street | Troutdale, OR 97060-1247 | U.S.A.
+ 1 503-667-4517 (voice) | + 1 503-667-8863 (fax) | [EMAIL PROTECTED]
************
