[Mageia-sysadm] [Mageia-webteam] Forum VM needs

Thu Jan 13 13:50:38 CET 2011

* Michael Scherer (misc at zarb.org) wrote:
+> Le mercredi 12 janvier 2011 à 23:05 +0100, Maât a écrit :
+> > Le 12/01/2011 22:37, nicolas vigier a écrit :
+> > > On Wed, 12 Jan 2011, Maât wrote:
+> 
+> > >> So phpBB needs a LAMP Stack : Apache + PHP5 + MysSQL5 (it prefers to have MySQLi extention)
+> > > Do you know if it would be possible to use Postgresql instead of MySQL ?
+> > > We already have a Postgresql server running on alamut that we could use.
+> > phpBB3 is supposed to work with PostgreSQL 7.3+ though it's not as widely used as MySQL as a phpBB backend.
+> 
+> Great, so more testing to do /o\
+
+In practice, if the SQL was properly written, the SQL must work on any
+PGSQL version, especially since it have to work on other SQL server
+(mysql).
+
+But who know with php apps.
+
+> 
+> > The problem (for me) is that i just know the basic of PostgreSQL... so we'll need someone else skilled 
+> > enough to tune it (and i'd be truly happy to learn from him/her)
+> 
+> Nanar will be able to do it, even if hosting a small database like this
+> may not be very appealing to him. There is just 5g, when compared to
+> sophie, I let him give the numbers.
+
+Sophie:
+- on disk size: ~ 200GB
+- biggers tables, rows estimated to 150 millions, next table 16 millions
+- 1208570 rpms in it currently
+
+I manage 5 posgresql servers at works.
+
+-- 
+
+Olivier Thauvin
+CNRS  -  LATMOS
+♖ ♘ ♗ ♕ ♔ ♗ ♘ ♖
+-------------- next part --------------
+A non-text attachment was scrubbed...
+Name: not available
+Type: application/pgp-signature
+Size: 197 bytes
+Desc: not available
+URL: </pipermail/mageia-sysadm/attachments/20110113/3ae129a4/attachment.asc>
+