zarb-ml/mageia-sysadm/2011-January/002019.html


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
 <HEAD>
   <TITLE> [Mageia-sysadm] [Mageia-webteam]  Forum VM needs
   </TITLE>
   <LINK REL="Index" HREF="index.html" >
   <LINK REL="made" HREF="mailto:mageia-sysadm%40mageia.org?Subject=Re%3A%20%5BMageia-sysadm%5D%20%5BMageia-webteam%5D%20%20Forum%20VM%20needs&In-Reply-To=%3C20110113125038.GO10402%40virgo.home.nanardon.zarb.org%3E">
   <META NAME="robots" CONTENT="index,nofollow">
   <META http-equiv="Content-Type" content="text/html; charset=us-ascii">
   <LINK REL="Previous"  HREF="002013.html">
   <LINK REL="Next"  HREF="002083.html">
 </HEAD>
 <BODY BGCOLOR="#ffffff">
   <H1>[Mageia-sysadm] [Mageia-webteam]  Forum VM needs</H1>
    <B>Olivier Thauvin</B> 
    <A HREF="mailto:mageia-sysadm%40mageia.org?Subject=Re%3A%20%5BMageia-sysadm%5D%20%5BMageia-webteam%5D%20%20Forum%20VM%20needs&In-Reply-To=%3C20110113125038.GO10402%40virgo.home.nanardon.zarb.org%3E"
       TITLE="[Mageia-sysadm] [Mageia-webteam]  Forum VM needs">nanardon at nanardon.zarb.org
       </A><BR>
    <I>Thu Jan 13 13:50:38 CET 2011</I>
    <P><UL>
        <LI>Previous message: <A HREF="002013.html">[Mageia-sysadm] [Mageia-webteam]  Forum VM needs
</A></li>
        <LI>Next message: <A HREF="002083.html">[Mageia-sysadm] [Mageia-webteam]    Forum VM needs
</A></li>
         <LI> <B>Messages sorted by:</B> 
              <a href="date.html#2019">[ date ]</a>
              <a href="thread.html#2019">[ thread ]</a>
              <a href="subject.html#2019">[ subject ]</a>
              <a href="author.html#2019">[ author ]</a>
         </LI>
       </UL>
    <HR>  
<!--beginarticle-->
<PRE>* Michael Scherer (<A HREF="https://www.mageia.org/mailman/listinfo/mageia-sysadm">misc at zarb.org</A>) wrote:
&gt;<i> Le mercredi 12 janvier 2011 &#224; 23:05 +0100, Ma&#226;t a &#233;crit :
</I>&gt;<i> &gt; Le 12/01/2011 22:37, nicolas vigier a &#233;crit :
</I>&gt;<i> &gt; &gt; On Wed, 12 Jan 2011, Ma&#226;t wrote:
</I>&gt;<i> 
</I>&gt;<i> &gt; &gt;&gt; So phpBB needs a LAMP Stack : Apache + PHP5 + MysSQL5 (it prefers to have MySQLi extention)
</I>&gt;<i> &gt; &gt; Do you know if it would be possible to use Postgresql instead of MySQL ?
</I>&gt;<i> &gt; &gt; We already have a Postgresql server running on alamut that we could use.
</I>&gt;<i> &gt; phpBB3 is supposed to work with PostgreSQL 7.3+ though it's not as widely used as MySQL as a phpBB backend.
</I>&gt;<i> 
</I>&gt;<i> Great, so more testing to do /o\
</I>
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.

&gt;<i> 
</I>&gt;<i> &gt; The problem (for me) is that i just know the basic of PostgreSQL... so we'll need someone else skilled 
</I>&gt;<i> &gt; enough to tune it (and i'd be truly happy to learn from him/her)
</I>&gt;<i> 
</I>&gt;<i> Nanar will be able to do it, even if hosting a small database like this
</I>&gt;<i> may not be very appealing to him. There is just 5g, when compared to
</I>&gt;<i> sophie, I let him give the numbers.
</I>
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
&#9814; &#9816; &#9815; &#9813; &#9812; &#9815; &#9816; &#9814;
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: not available
URL: &lt;/pipermail/mageia-sysadm/attachments/20110113/3ae129a4/attachment.asc&gt;
</PRE>


<!--endarticle-->
    <HR>
    <P><UL>
        <!--threads-->
	<LI>Previous message: <A HREF="002013.html">[Mageia-sysadm] [Mageia-webteam]  Forum VM needs
</A></li>
	<LI>Next message: <A HREF="002083.html">[Mageia-sysadm] [Mageia-webteam]    Forum VM needs
</A></li>
         <LI> <B>Messages sorted by:</B> 
              <a href="date.html#2019">[ date ]</a>
              <a href="thread.html#2019">[ thread ]</a>
              <a href="subject.html#2019">[ subject ]</a>
              <a href="author.html#2019">[ author ]</a>
         </LI>
       </UL>

<hr>
<a href="https://www.mageia.org/mailman/listinfo/mageia-sysadm">More information about the Mageia-sysadm
mailing list</a><br>
</body></html>