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
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
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
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:
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
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
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
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
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
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
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
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
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
13 matches
Mail list logo