Re: [Bacula-users] choosing database.

2013-10-04 Thread Jérôme Blion
Le 2013-10-04 14:25, Dan Langille a écrit : > On 2013-09-19 11:06, Mauro wrote: >> Hello. >> I'm using bacula in a linux debian system. >> >> I've to backup about 30 hosts. >> I've choose postresql as database. >> What do you think about? >> Better mysql or postgres? > > I recommend PostgreSQL. >

Re: [Bacula-users] choosing database.

2013-10-04 Thread Dan Langille
On 2013-09-19 11:06, Mauro wrote: > Hello. > I'm using bacula in a linux debian system. > > I've to backup about 30 hosts. > I've choose postresql as database. > What do you think about? > Better mysql or postgres? I recommend PostgreSQL. As the author of the PostgreSQL database layer, this reco

Re: [Bacula-users] choosing database.

2013-09-20 Thread Uwe Schuerkamp
On Thu, Sep 19, 2013 at 11:07:47AM -0500, Dimitri Maziuk wrote: > > Mysql is known for "features" like inserting 0 in a NOT NULL column > instead of throwing errors, case-sensitive identifiers, and so on and so > forth, with Oracle lawyers looming in the background. I wouldn't pick it > for anythi

Re: [Bacula-users] choosing database.

2013-09-20 Thread lst_hoe02
Zitat von Mauro : > On 19 September 2013 21:53, wrote: > >> >> Zitat von Konstantin Khomoutov : >> >> >> Our biggest single job has about 1TB data with some 3.3 million files. >> This lead to around 1GB spooled attributes which will be absorbed in >> less then 2 minutes. Database is Postgres wit

Re: [Bacula-users] choosing database.

2013-09-19 Thread Mauro
On 19 September 2013 18:03, Andrea Venturoli wrote: > On 09/19/13 17:51, Mauro wrote: > > I've always used postgres for all my needs so I though to use it also >> for bacula server. >> > > That's what I did too: choose Oostgres because I know it better; I never > liked MySQL too much, OTOH. > >

Re: [Bacula-users] choosing database.

2013-09-19 Thread lst_hoe02
Zitat von Konstantin Khomoutov : > On Thu, 19 Sep 2013 17:06:48 +0200 > Mauro wrote: > >> Hello. >> I'm using bacula in a linux debian system. >> I've to backup about 30 hosts. >> I've choose postresql as database. >> What do you think about? >> Better mysql or postgres? > > Unless you will have

Re: [Bacula-users] choosing database.

2013-09-19 Thread Mauro
On 19 September 2013 21:53, wrote: > > Zitat von Konstantin Khomoutov : > > > Our biggest single job has about 1TB data with some 3.3 million files. > This lead to around 1GB spooled attributes which will be absorbed in > less then 2 minutes. Database is Postgres with some minimal tuning: > > sha

Re: [Bacula-users] choosing database.

2013-09-19 Thread Stephen Thompson
On 09/19/2013 08:51 AM, Mauro wrote: > On 19 September 2013 17:20, Stephen Thompson > mailto:step...@seismo.berkeley.edu>> wrote: > > > > The answer may partly come from how much RAM the system running the > database has. I've seen numerous preferences for postgres on this > mailing li

Re: [Bacula-users] choosing database.

2013-09-19 Thread Andrea Venturoli
On 09/19/13 18:15, Mauro wrote: > Have you tuned postgres in a particular way or leaved the default settings? Default settings, but my setup is probably smaller than yours. I usually start with default and only tune if needed: speaking of backup, I never felt this need... they almost run by them

Re: [Bacula-users] choosing database.

2013-09-19 Thread Mauro
On 19 September 2013 17:20, Stephen Thompson wrote: > > > The answer may partly come from how much RAM the system running the > database has. I've seen numerous preferences for postgres on this > mailing list, but I've personally found on my 8Gb RAM system, I get > better performance out of mysql

Re: [Bacula-users] choosing database.

2013-09-19 Thread Konstantin Khomoutov
On Thu, 19 Sep 2013 17:06:48 +0200 Mauro wrote: > Hello. > I'm using bacula in a linux debian system. > I've to backup about 30 hosts. > I've choose postresql as database. > What do you think about? > Better mysql or postgres? Unless you will have directories with unusually high quantities of fi

Re: [Bacula-users] choosing database.

2013-09-19 Thread Andrea Venturoli
On 09/19/13 17:51, Mauro wrote: > I've always used postgres for all my needs so I though to use it also > for bacula server. That's what I did too: choose Oostgres because I know it better; I never liked MySQL too much, OTOH. I never had any problem with its integration with bacula, if that's w

Re: [Bacula-users] choosing database.

2013-09-19 Thread Dimitri Maziuk
On 09/19/2013 10:51 AM, Mauro wrote: > One has about 80G of data, multimedia files and other. > I've always used postgres for all my needs so I though to use it also for > bacula server. Mysql is known for "features" like inserting 0 in a NOT NULL column instead of throwing errors, case-sensitive

[Bacula-users] choosing database.

2013-09-19 Thread Mauro
Hello. I'm using bacula in a linux debian system. I've to backup about 30 hosts. I've choose postresql as database. What do you think about? Better mysql or postgres? -- LIMITED TIME SALE - Full Year of Microsoft Training F

Re: [Bacula-users] choosing database.

2013-09-19 Thread Stephen Thompson
The answer may partly come from how much RAM the system running the database has. I've seen numerous preferences for postgres on this mailing list, but I've personally found on my 8Gb RAM system, I get better performance out of mysql. We backup about 130+ hosts, incrementals nightly, differ