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 --add

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 --ad

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 databas

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 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 datab

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 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 for them >> this evenin

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 10:54:31 +0200, Marcus Mülbüsch 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 CREATE INDEX commands >> a

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 w

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 >> http://www.bacula.org/5.0.x-manuals/en/main/main/Installing_Configuring_Post.html#SECTION00445

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 >> http://www.bacula.org/5.0.x-manuals/en/main/main/Installing_Configuring_Post.html#SECTION004450

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 th

[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 in