On 23-Jan-00 Peter Eisentraut wrote:
> On 2000-01-20, Vince Vielhaber mentioned:
>> I thought the data directory was created either in the gmake install step
>> or initdb. Either way the chown might be better as:
>
> No, it never was. Not sure if initdb used to create the data directory
> itself, at least now it does try to do so if it doesn't exist. But if you
> are going to put your data into a root-owned dir (such as
> /usr/local/pgsql/data) you must create it first and change the ownership.
>
>> # chown -R postgres:postgres /usr/local/pgsql
>>
>> that should be the same on most systems with perhaps the exception of the
>> colon. Anyway it'll make sure that all the files have the correct owners.
>
> No. See above.
The reason I mentioned it is on one install where I used:
install -u postgres -g postgres
all of the directories were created ug root:wheel and the files in them
were ug postgres:postgres so I had to go back one and do the above chown.
PostgreSQL couldn't create databases.
Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net 128K ISDN: $24.95/mo or less - 56K Dialup:
$17.95/moor less at Pop4 Online Campground Directory http://www.camping-usa.com Online Giftshop
Superstore http://www.cloudninegifts.com
==========================================================================