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