Re: [SOGo] SOGo database schema

2022-01-04 Thread Peter Beck
Cédric Archambeau quatschte am Wed, Dec 29, 2021 at 12:22:34PM +0100: > Hi Andre, > > Lots of disagrees with the form in your message. > > Remember you benefit from a FOSS. > Not OK with some feature ?  Report a bug, maybe pull a request (*you* could > hire a database administrator to redesign

Re: [SOGo] SOGo database schema

2021-12-29 Thread cedric.archamb...@solidairesfinancespubliques.org
Hi Andre, Lots of disagrees with the form in your message. Remember you benefit from a FOSS. Not OK with some feature ?  Report a bug, maybe pull a request (*you* could hire a database administrator to redesign database schema), or discuss (not assault !) it here. SOGo nightly is *free*,

Re: [SOGo] SOGo database schema

2021-12-26 Thread mj
Hi, Only to say: YES, specially on #3: the credentials in clear text inside the database. It's terrible. And additionally makes it so much more difficult to change the database credentials than it really should be. MJ Op 23-12-2021 om 10:33 schreef André Rodier (an...@rodier.me): Good

Re: [SOGo] SOGo database move - unsuccessfull

2013-01-28 Thread Khapare Joshi
hi, I had to do pg_dump all and restore then also disabled the ipv6 on the machine. This all worked. thanks KH On Thu, Jan 24, 2013 at 5:19 PM, Christian Mack christian.m...@uni-konstanz.de wrote: Hello Khapare Joshi Am 2013-01-24 18:08, schrieb Khapare Joshi: I have been running

Re: [SOGo] SOGo database move - unsuccessfull

2013-01-24 Thread Christian Mack
Hello Khapare Joshi Am 2013-01-24 18:08, schrieb Khapare Joshi: I have been running sogo for now two years in virtual server. since users increased I wanted to move to another physical server. I am having issue with sogo database. I dumped the sogo database with pg_dump and tried to

Re: [SOGo] SOGo Database Cleanup

2011-12-01 Thread Milos Wimmer
On Thu, 1 Dec 2011, Luca Olivetti wrote: More than accents, I had problems with newlines (i.e., when a note is in multiple lines), at least I see funambol complaints about encountered \r\n and stops the synchronization. look at http://www.sogo.nu/bugs/view.php?id=904 Regards MW --

Re: [SOGo] SOGo Database Cleanup

2011-12-01 Thread Luca Olivetti
Al 29/11/2011 21:42, En/na Dominique ha escrit: So now I have a working calendar, but with entries that need to be cleanup. Does anyone have any idea/tools/scripts how to massively cleanup the database: massive change in times depending on the time zone selected, accent cleanups, More

Re: [SOGo] SOGo database

2011-04-26 Thread Milos Wimmer
On Tue, 26 Apr 2011, Pascal Gienger wrote: Hello Pascal, What's the size/value of shared_buffers = ... and max_locks_per_transaction = ... in your postgresql.conf? shared_buffers = 24MB [default value] max_locks_per_transaction = 256 [default value = 64]

Re: [SOGo] SOGo database

2011-04-26 Thread Sven Marth
Am 26.04.2011 08:05, schrieb Milos Wimmer: On Tue, 26 Apr 2011, Pascal Gienger wrote: Hello Pascal, What's the size/value of shared_buffers = ... and max_locks_per_transaction = ... in your postgresql.conf? shared_buffers = 24MB [default value]

Re: [SOGo] SOGo database

2011-04-26 Thread Milos Wimmer
On Tue, 26 Apr 2011, Sven Marth wrote: Hi Sven, you should increase the kernels maximum size of shared memory segment. To do this. edit your /etc/sysctl.conf. For example: kernel.shmmax = 134217728 (sets the value to 128 MB). You can also find a explanation in

Re: [SOGo] SOGo database

2011-04-25 Thread Milos Wimmer
On Thu, 21 Apr 2011, Pascal Gienger wrote: We have 60552 tables now, and the WAL backup (hot backup) is still running without any problem. PostgreSQL 8.4.7 on Ubuntu 10.04 LTS Server with different volumes for DB files and for DB log (WAL) files, 1G shared memory. I have 125406 tables now,

Re: [SOGo] SOGo database

2011-04-25 Thread Pascal Gienger
Am 26.04.11 00:17, schrieb Milos Wimmer: On Thu, 21 Apr 2011, Pascal Gienger wrote: We have 60552 tables now, and the WAL backup (hot backup) is still running without any problem. PostgreSQL 8.4.7 on Ubuntu 10.04 LTS Server with different volumes for DB files and for DB log (WAL) files, 1G

Re: [SOGo] SOGo database

2011-04-21 Thread Pascal Gienger
Am 21.04.11 07:40, schrieb Martin Rabl: @Pascal Gienger: Pascal, you work with a large SOGo-Installation, do you have any problems with the many tables? We use two Postgres instances: One locally on the SOGo system for the session table, and one in a central Postgres Server infrastructure

Re: [SOGo] SOGo database

2011-04-20 Thread Martin Rabl
Hi, I was wondering, too. It is a little bit ... strange, in terms of common database design ;-) But it is easy to understand: Every table is a folder of an user. Contacts are folders, calendars are folders ... The current used folder for contacts or calendars you will find in the