Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Interfaces Jdbc > Re: postgresql ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 1870 of 1994
Post > Topic >>

Re: postgresql in FreeBSD jails: proposal

by achill@[EMAIL PROTECTED] (Achilleas Mantzios) Jan 17, 2008 at 10:11 AM

=CE=A3=CF=84=CE=B9=CF=82 Thursday 17 January 2008 07:52:50 =CE=BF/=CE=B7
Ma=
rc G. Fournier =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5:
> mischa_sandberg@[EMAIL PROTECTED]
 (Mischa Sandberg) writes:
>=20
> >Unfortunately, with multiple jails running PG servers and (due to app
> >limitations) all servers having same PG****T, you get the situation that
> >when jail#2 (,jail#3,...) server comes up, it:
> >- detects that there is a shm seg with ipc key 5432001
> >- checks whether the associated postmaster process exists (with kill
-0)
> >- overwrites the segment created and being used by jail #1
>=20
> Easiest fix: change the UID of the user running the postmaster (ie.
pgsql=
) so=20
> that each runs as a distinct UID (instead of distinct PG****T) ... been
do=
ing=20
> this since moving to FreeBSD 6.x ... no patches required ...

Hi Marc,
what happened with the patches at
http://docs.freevps.com/doku.php?id=3Dfre=
ebsd:changelog?
Those patches are supposed to make IPC run without collisions in many
jails=
, thus solving the
classic problem with postgresql, allowing the admin to use the same uid,
PG=
****T in all pgsql
server instances.
Do you know if any of this stuff make it anywhere in official FreeBSD?

--=20
Achilleas Mantzios

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@[EMAIL PROTECTED]
 so that your
       message can get through to the mailing list cleanly
 




 1 Posts in Topic:
Re: postgresql in FreeBSD jails: proposal
achill@[EMAIL PROTECTED]   2008-01-17 10:11:30 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sun Jul 20 4:35:34 CDT 2008.