From dd959e549f084696a6c5eb0f45fef31e4fae94cf Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Tue, 6 Apr 2010 22:35:16 +0200 Subject: [PATCH] update db info --- docs/manuals/en/main/install.tex | 39 +++++++++++++++++++------------- 1 file changed, 23 insertions(+), 16 deletions(-) diff --git a/docs/manuals/en/main/install.tex b/docs/manuals/en/main/install.tex index ae98e1eb..2a0eaefc 100644 --- a/docs/manuals/en/main/install.tex +++ b/docs/manuals/en/main/install.tex @@ -634,25 +634,32 @@ because SQLite is compiled into Bacula an requires no administration. It performs well and is suitable for small to medium sized installations (maximum 10-20 machines). However, we should note that a number of users have had unexplained database corruption with SQLite. For that reason, we -recommend that you install either MySQL or PostgreSQL for production +recommend that you install either PostgreSQL or MySQL for production work. -If you wish to use MySQL as the Bacula catalog, please see the -\ilink{Installing and Configuring MySQL}{MySqlChapter} chapter of -this manual. You will need to install MySQL prior to continuing with the +If you wish to use MySQL as the Bacula catalog, please see the +\ilink{Installing and Configuring MySQL}{MySqlChapter} chapter of this +manual. You will need to install MySQL prior to continuing with the configuration of Bacula. MySQL is a high quality database that is very -efficient and is suitable for any sized installation. It is slightly more -complicated than SQLite to setup and administer because it has a number of -sophisticated features such as userids and passwords. It runs as a separate -process, is truly professional and can manage a database of any size. - -If you wish to use PostgreSQL as the Bacula catalog, please see the -\ilink{Installing and Configuring PostgreSQL}{PostgreSqlChapter} -chapter of this manual. You will need to install PostgreSQL prior to -continuing with the configuration of Bacula. PostgreSQL is very similar to -MySQL, though it tends to be slightly more SQL92 compliant and has many more -advanced features such as transactions, stored procedures, and the such. It -requires a certain knowledge to install and maintain. +efficient and is suitable for small and medium sized installation (up to +2,000,000 files per job). It is slightly more complicated than SQLite to setup +and administer because it has a number of sophisticated features such as +userids and passwords. It runs as a separate process, is truly professional and +can manage a database of any size. + +If you wish to use PostgreSQL as the Bacula catalog, please see the +\ilink{Installing and Configuring PostgreSQL}{PostgreSqlChapter} chapter of +this manual. You will need to install PostgreSQL prior to continuing with the +configuration of Bacula. PostgreSQL is very similar to MySQL, though it tends +to be slightly more SQL92 compliant and has many more advanced features such as +transactions, stored procedures, and the such. It requires a certain knowledge +to install and maintain. PostgreSQL is suitable for any sized installation +(some sites have much more than 1 billion objects in the Catalog). Bacula uses +many optimized PostgreSQL functions, and can run more than 10 time faster on +jobs having millions of files than MySQL (Specially in during restore, accurate +mode, bvfs queries and when the database server is not on the same host than +the Director). It's possible to switch from MySQL/SQLite to PostgreSQL, but it +requires some DBA knowledge. If you wish to use SQLite as the Bacula catalog, please see \ilink{Installing and Configuring SQLite}{SqlLiteChapter} chapter of -- 2.39.5