Re: [Bacula-users] Migrating form mysql to postgresql: Loading the database takes very long

2011-06-27 Thread Marcus Mülbüsch
Am 26.06.2011 00:18, schrieb Gavin McCullagh: It seems you need to drop --quick which is implied in --skip-opt. The resulting command that I'm working with at the moment is: mysqldump -t -n -c --compatible=postgresql --skip-quote-names --quick \ --lock-tables --add-drop-table

Re: [Bacula-users] Migrating form mysql to postgresql: Loading the database takes very long

2011-06-27 Thread Gavin McCullagh
On Sat, 25 Jun 2011, Gavin McCullagh wrote: It seems you need to drop --quick which is implied in --skip-opt. The resulting command that I'm working with at the moment is: mysqldump -t -n -c --compatible=postgresql --skip-quote-names --quick \ --lock-tables --add-drop-table

Re: [Bacula-users] Migrating form mysql to postgresql: Loading the database takes very long

2011-06-25 Thread Gavin McCullagh
On Tue, 21 Jun 2011, Marcus Mülbüsch wrote: I want to migrate my bacula installation from mysql to postgresql, following the guide in http://www.bacula.org/5.0.x-manuals/en/main/main/Installing_Configuring_Post.html#SECTION00445 After dumping and converting the database

Re: [Bacula-users] Migrating form mysql to postgresql: Loading the database takes very long

2011-06-23 Thread Phil Stracchino
On 06/23/11 01:55, Bruno Friedmann wrote: Did you prepare ( I suppose ) postgresql to manage bacula database. As most of distribution around send postgresql with a very very little setup (like use 32MB ram etc) Adjusting the setup of postgresql can make a huge difference. Rule of thumb:

Re: [Bacula-users] Migrating form mysql to postgresql: Loading the database takes very long

2011-06-22 Thread Marcus Mülbüsch
Am 22.06.2011 06:14, schrieb Stuart McGraw: You can identify the indexes from the CREATE INDEX commands in /usr/libexec/bacula/make_postgresql_tables. Drop them prior to loading, and then rerun the CREATE INDEX commands after loading -- it can make a big difference in loading time. I will

Re: [Bacula-users] Migrating form mysql to postgresql: Loading the database takes very long

2011-06-22 Thread Jérôme Blion
On Wed, 22 Jun 2011 10:54:31 +0200, Marcus Mülbüsch muelbue...@as-infodienste.de wrote: Am 22.06.2011 06:14, schrieb Stuart McGraw: You can identify the indexes from the CREATE INDEX commands in /usr/libexec/bacula/make_postgresql_tables. Drop them prior to loading, and then rerun the

Re: [Bacula-users] Migrating form mysql to postgresql: Loading the database takes very long

2011-06-22 Thread Marcus Mülbüsch
Am 22.06.2011 12:05, schrieb Jérôme Blion: I don't know how you dumped your mysql database. Did you try to use mysqldump -T ? mysql2pgsql ? I used some other scripts to migrate data pieces. I will look for them this evening... mysqldump -t -n -c --compatible=postgresql --skip-quote-names

Re: [Bacula-users] Migrating form mysql to postgresql: Loading the database takes very long

2011-06-22 Thread Jérôme Blion
On Wed, 22 Jun 2011 12:22:34 +0200, Marcus Mülbüsch muelbue...@as-infodienste.de wrote: Am 22.06.2011 12:05, schrieb Jérôme Blion: I don't know how you dumped your mysql database. Did you try to use mysqldump -T ? mysql2pgsql ? I used some other scripts to migrate data pieces. I will look

Re: [Bacula-users] Migrating form mysql to postgresql: Loading the database takes very long

2011-06-22 Thread Bruno Friedmann
On 06/21/2011 09:59 AM, Marcus Mülbüsch wrote: I want to migrate my bacula installation from mysql to postgresql, following the guide in http://www.bacula.org/5.0.x-manuals/en/main/main/Installing_Configuring_Post.html#SECTION00445 After dumping and converting the database

[Bacula-users] Migrating form mysql to postgresql: Loading the database takes very long

2011-06-21 Thread Marcus Mülbüsch
I want to migrate my bacula installation from mysql to postgresql, following the guide in http://www.bacula.org/5.0.x-manuals/en/main/main/Installing_Configuring_Post.html#SECTION00445 After dumping and converting the database the sql-file now has 9GiB. I began loading the db

Re: [Bacula-users] Migrating form mysql to postgresql: Loading the database takes very long

2011-06-21 Thread Dan Langille
On Jun 21, 2011, at 3:59 AM, Marcus Mülbüsch wrote: I want to migrate my bacula installation from mysql to postgresql, following the guide in http://www.bacula.org/5.0.x-manuals/en/main/main/Installing_Configuring_Post.html#SECTION00445 After dumping and converting the

Re: [Bacula-users] Migrating form mysql to postgresql: Loading the database takes very long

2011-06-21 Thread Phil Stracchino
On 06/21/11 22:06, Dan Langille wrote: On Jun 21, 2011, at 3:59 AM, Marcus Mülbüsch wrote: I want to migrate my bacula installation from mysql to postgresql, following the guide in

Re: [Bacula-users] Migrating form mysql to postgresql: Loading the database takes very long

2011-06-21 Thread Stuart McGraw
On 06/21/2011 08:06 PM, Dan Langille wrote: On Jun 21, 2011, at 3:59 AM, Marcus Mülbüsch wrote: I want to migrate my bacula installation from mysql to postgresql, following the guide in