Thread: PostgreSQL ontop of FreeBSD jails, maybe there is still hope!

PostgreSQL ontop of FreeBSD jails, maybe there is still hope!

From
Achilleas Mantzios
Date:
It seems there are certain projects running at the moment that will eventually make possible
to run PostgreSQL on FreeBSD's jail (virtual server on plain iron speed).

Pre jail resource limits:
http://freebsdfoundation.blogspot.com/2010/07/resource-containers-project.html

Further generalization improvements:
http://freebsdfoundation.blogspot.com/2010/06/update-on-jail-based-virtualization.html

"Further, the project includes generalization of the virtual network stack framework, factoring out common code. 
This will provide an infrastructure and will ease virtualization of further subsystems like SYSV/Posix IPC with minimal
overhead.
 
All further virtualized subsystems will immediately benefit from shared debugging facilities, an essential feature for
earlyadopters 
 
of the new technology."

By solving the SYSV/IPC problems, PostgreSQL will be able to be run on jails, even easier and more robustly 
than it is the case now.

Lets hope those guys will deliver smth good.

-- 
Achilleas Mantzios


Re: PostgreSQL ontop of FreeBSD jails, maybe there is still hope!

From
Dave Page
Date:
On Wed, Jul 21, 2010 at 7:47 AM, Achilleas Mantzios
<achill@matrix.gatewaynet.com> wrote:
> It seems there are certain projects running at the moment that will eventually make possible
> to run PostgreSQL on FreeBSD's jail (virtual server on plain iron speed).

We've been doing that across the project infrastructure for 10 years
or more. The only issue we run into is that we need to use a unique
port in each jail as shared memory isn't entirely isolated between
jails.


-- 
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company


Re: PostgreSQL ontop of FreeBSD jails, maybe there is still hope!

From
Achilleas Mantzios
Date:
Στις Wednesday 21 July 2010 10:57:45 ο/η Dave Page έγραψε:
> On Wed, Jul 21, 2010 at 7:47 AM, Achilleas Mantzios
> <achill@matrix.gatewaynet.com> wrote:
> > It seems there are certain projects running at the moment that will eventually make possible
> > to run PostgreSQL on FreeBSD's jail (virtual server on plain iron speed).
>
> We've been doing that across the project infrastructure for 10 years
> or more. The only issue we run into is that we need to use a unique
> port in each jail as shared memory isn't entirely isolated between
> jails.

Thats a pretty known workaround, still inconvenient and annoying for massive scale
virtual environments.

>
>
> --
> Dave Page
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise Postgres Company
>



--
Achilleas Mantzios