Re: [Bacula-users] migrate catalog from PostgreSQL to MySQL

2007-06-15 Thread Svein-Erik Lund
On Thursday 14 June 2007 10:53:09 Marc Cousin wrote: > There is nothing that will totally solve the performance problems you're > facing... For now, bacula's code does many small operations, each in it's > transaction, and postgresql isn't good at that... > Removing indexes may help the insert spee

Re: [Bacula-users] migrate catalog from PostgreSQL to MySQL

2007-06-14 Thread Marc Cousin
> An: [EMAIL PROTECTED] > > Cc: bacula-users@lists.sourceforge.net > > Betreff: Re: [Bacula-users] migrate catalog from PostgreSQL to MySQL > > > > On Thursday 14 June 2007 08:36:19 Berner Martin wrote: > > > Yes it is because I have some bottleneck with PostgreSQ

Re: [Bacula-users] migrate catalog from PostgreSQL to MySQL

2007-06-14 Thread Berner Martin
erformance? > -Ursprungliche Nachricht- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Auftrag von Marc > Cousin > Gesendet: Donnerstag, 14. Juni 2007 08:45 > An: [EMAIL PROTECTED] > Cc: bacula-users@lists.sourceforge.net > Betreff: Re: [Bacula-users] migrat

Re: [Bacula-users] migrate catalog from PostgreSQL to MySQL

2007-06-13 Thread Marc Cousin
On Thursday 14 June 2007 08:36:19 Berner Martin wrote: > Yes it is because I have some bottleneck with PostgreSQL as backend. So I > try to give MySQL a try on a Testenvirement. But it has no sense if I cant > migrate the catalogue. And to make a true comparison it is important to > have as much en

Re: [Bacula-users] migrate catalog from PostgreSQL to MySQL

2007-06-13 Thread Berner Martin
13. Juni 2007 18:28 > An: bacula-users@lists.sourceforge.net; [EMAIL PROTECTED] > Betreff: Re: [Bacula-users] migrate catalog from PostgreSQL to MySQL > > > On Wednesday 13 June 2007 10:18:44 Berner Martin wrote: > > Hello > > Dos someone have already do a migration of t

Re: [Bacula-users] migrate catalog from PostgreSQL to MySQL

2007-06-13 Thread Frank Sweetser
Marc Cousin wrote: > On Wednesday 13 June 2007 10:18:44 Berner Martin wrote: >> Hello >> Dos someone have already do a migration of the Catalogue from a PostgreSQL >> to y MySQL? Or know how it has to work? I tried to dump Postgres so that he >> dump only the Data and use INSERT in stead of COPY. T

Re: [Bacula-users] migrate catalog from PostgreSQL to MySQL

2007-06-13 Thread Marc Cousin
On Wednesday 13 June 2007 10:18:44 Berner Martin wrote: > Hello > Dos someone have already do a migration of the Catalogue from a PostgreSQL > to y MySQL? Or know how it has to work? I tried to dump Postgres so that he > dump only the Data and use INSERT in stead of COPY. Then I grep only the > lin

[Bacula-users] migrate catalog from PostgreSQL to MySQL

2007-06-13 Thread Berner Martin
Hello Dos someone have already do a migration of the Catalogue from a PostgreSQL to y MySQL? Or know how it has to work? I tried to dump Postgres so that he dump only the Data and use INSERT in stead of COPY. Then I grep only the lines with Inserts. I create the bacula-tables with the script (mak