Restarting, ownership, and permissions - Mailing list pgsql-general

From Aurangzeb M. Agha
Subject Restarting, ownership, and permissions
Date
Msg-id Pine.LNX.4.53.0309021351100.20086@cinemaspace.berkeley.edu
Whole thread Raw
Responses Re: Restarting, ownership, and permissions  (Richard Huxton <dev@archonet.com>)
List pgsql-general
I run my Postgres DB on a virtual linux server where I don't have root.
I'm 'admin', by default, and have created a 'postgres' user to own the DB
dir.

My problem is that on occassion, my ISP restarts my server, stranding all
my processes.  While I have scripts to restart Apache and my Servlet
engine on reboot, I don't know how to get the Postgres DB up and running
again.  The main problem is that the dir is owned (postgres.postgres) and
chmod'd to 700, keeping anyone but the 'postgres' user from starting it
up.

I tried chownin'g the DB dir to postgres.admin, and chmodding to 770, but
when I tried to start the DB, I got a fatal error in the log indicating
that postgres must own the dir, and the permissions must be u=rwx.  What
can I do?

    Thanks,
    Zeb


pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Commercial postgresql
Next
From: Ron Johnson
Date:
Subject: Re: Table name lengths...