Restarting, ownership, and permissions

From: "Aurangzeb M(dot) Agha" <ama-list(at)mltp(dot)com>
To: PostgreSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Restarting, ownership, and permissions
Date: 2003-09-02 20:51:36
Message-ID: Pine.LNX.4.53.0309021351100.20086@cinemaspace.berkeley.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2003-09-02 20:57:43 Re: Table name lengths...
Previous Message Bruno Wolff III 2003-09-02 20:21:05 Re: Commercial postgresql