I have created (using initlocation) an alternate location for databases.
Yet, when I try to create a test database there, I cannot. When initlocation
created the ../base subdirectory in the path I specified, it was created
with permissions 700.
According to page 9 of the 6.4.2 Users Guide (but I'm trying to use 6.5.2
of postgres), the error message I'm seeing means:
"If the specified location does not exist or the database backend does not
have permission to access it or to write to directories under it, you will
see the following: ... " and that's what I see.
Well, the location exists (I can echo $PGDATA and see it correctly --
minus the base/ directory), so it must be that the backend hasn't the
permission to write to it.
What mode should PGDATA2/base or PGDATA have so I can create databases in
it?
Thanks,
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]
************
