Skip site navigation (1) Skip section navigation (2)

Postgres and chroot

From: Melvyn Sopacua <mdev(at)idg(dot)nl>
To: PostgreSQL Adminlist <pgsql-admin(at)postgresql(dot)org>
Subject: Postgres and chroot
Date: 2001-05-27 16:14:08
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Hi all,

I'm new to the list as well as to Postgres. At present we're using MySQL, 
on a BSD platform,
and migrating the databases to AIX, keeping BSD on the frontend. The 
frontend is powered
by Php and Apache and a few Perl scripts since I just love GD::Graphs3d :-).

I hope I can contribute in the near future, but my guess is, I'll be askin' 
a lot first :-). Especially
since it's quite a different setup as opposed to MySQL.

We're considering Postgres at least for some more demanding webapplications 
and therefore
I've setup a little test environment at home on a similar box (well - 
software/OS then).

As for the first questions:
It's customary for us to run web-accessible services chrooted. However, 
postgres needs to
change user context and chroot requires the root user. There are two things 
bugging about
the current Postgres implementation, with respect to a chrooted environment:
1) Postgres requires me to have 'su' in the chrooted env
2) Postgres makes a shell call to the 'cp' command when creating new databases.

The first I've overcome, with the not-so-elegant script below, but the 
second is not so easy.
So my questions:

-- Does anybody run PostgreSQL chrooted and so, how?
-- Is there a way to use PostgreSQL and not have `cp' in the environment?

Many thanx, in advance.

The startupscript:
$ cat /chroot/pgsql/

cp -p /usr/bin/su /chroot/bin/su

/usr/sbin/chroot /chroot /bin/su postgres -c "/pgsql/bin/postmaster -i -D 
/pgsql/data &"

sleep 2

rm /chroot/bin/su


Best regards,

Melvyn Sopacua


pgsql-admin by date

Next:From: Tom LaneDate: 2001-05-27 17:04:26
Subject: Re: Postgres and chroot
Previous:From: Peter EisentrautDate: 2001-05-27 10:45:18
Subject: Re: TCLu and mail

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group