Tweaks from Dan

[bacula/docs] / docs / manuals / en / main / postgresql.tex

diff --git a/docs/manuals/en/main/postgresql.tex b/docs/manuals/en/main/postgresql.tex
index 0d22a7bedeed318c632fb5366b0ab24d1f3060d4..2b2559e4137b5c265eaaa6ed2ccadb9033f05c4f 100644 (file)
--- a/docs/manuals/en/main/postgresql.tex
+++ b/docs/manuals/en/main/postgresql.tex
@@ -357,10 +357,10 @@ The conversion procedure presented here was worked out by Norm Dressler
 This process was tested using the following software versions: 
 
 \begin{itemize}
-\item Linux Mandrake 10/Kernel 2.4.22-10 SMP 
-\item Mysql Ver 12.21 Distrib 4.0.15, for mandrake-linux-gnu (i586) 
-\item PostgreSQL 7.3.4 
-\item Bacula 1.34.5 
+\item Linux Ubuntu Lucid
+\item Mysql Ver 5.0.83
+\item PostgreSQL 8.4.4
+\item Bacula 5.0
    \end{itemize}
 
 WARNING: Always as a precaution, take a complete backup of your databases
@@ -372,8 +372,11 @@ before proceeding with this process!
 
    \footnotesize
 \begin{verbatim}
-       mysqldump -f -t -n >bacula-backup.dmp
-    
+mysqldump -t -n -c --compatible=postgresql --skip-quote-names --skip-opt \
+          --disable-keys --lock-tables -u bacula -ppassword bacula \
+  | grep -v "INSERT INTO Status" \
+  | sed -e 's/0000-00-00 00:00:00/1970-01-01 00:00:00/g' \
+  | sed -e 's/\\0//' > bacula-backup.sql    
 \end{verbatim}
 \normalsize
 
@@ -388,7 +391,8 @@ before proceeding with this process!
 \item Start PostgreSQL on your system.  
 \item Create a bacula user in Postgres with the createuser command.  Depending on
    your Postgres install, you may have to SU to the  user who has privileges to
-   create a user.  
+   create a user, you can also have to change permissions on catalog scripts
+   to fit your situation.  
 \item Verify your pg\_hba.conf file contains sufficient permissions to  allow
    bacula to access the server. Mine has the following since  it's on a secure
    network:  
@@ -399,8 +403,7 @@ local all all trust
                 
 host all all 127.0.0.1 255.255.255.255 trust
                 
-NOTE: you should restart your postgres server if you
-      made changes
+NOTE: you should reload (or restart) your postgres server if you  made changes
       
 \end{verbatim}
 \normalsize
@@ -445,26 +448,32 @@ psql -Ubacula bacula <bacula-backup.dmp>
 \begin{verbatim}
 psql -Ubacula bacula
                 
-SELECT SETVAL('basefiles_baseid_seq', (SELECT
-MAX(baseid) FROM basefiles));
-SELECT SETVAL('client_clientid_seq', (SELECT
-MAX(clientid) FROM client));
-SELECT SETVAL('file_fileid_seq', (SELECT MAX(fileid)
-FROM file));
-SELECT SETVAL('filename_filenameid_seq', (SELECT
-MAX(filenameid) FROM filename));
-                
-SELECT SETVAL('fileset_filesetid_seq', (SELECT
-MAX(filesetid) FROM fileset));
-                
+SELECT SETVAL('basefiles_baseid_seq', (SELECT MAX(baseid) FROM basefiles));
+SELECT SETVAL('client_clientid_seq', (SELECT MAX(clientid) FROM client));
+SELECT SETVAL('file_fileid_seq', (SELECT MAX(fileid) FROM file));
+SELECT SETVAL('filename_filenameid_seq', (SELECT MAX(filenameid) FROM filename));
+SELECT SETVAL('fileset_filesetid_seq', (SELECT MAX(filesetid) FROM fileset));
 SELECT SETVAL('job_jobid_seq', (SELECT MAX(jobid) FROM job));
-SELECT SETVAL('jobmedia_jobmediaid_seq', (SELECT
-MAX(jobmediaid) FROM jobmedia));
+SELECT SETVAL('jobmedia_jobmediaid_seq', (SELECT MAX(jobmediaid) FROM jobmedia));
+SELECT SETVAL('media_mediaid_seq', (SELECT MAX(mediaid) FROM media));
+SELECT SETVAL('path_pathid_seq', (SELECT MAX(pathid) FROM path));
+SELECT SETVAL('basefiles_baseid_seq', (SELECT MAX(baseid) FROM basefiles));
+SELECT SETVAL('client_clientid_seq', (SELECT MAX(clientid) FROM client));
+SELECT SETVAL('file_fileid_seq', (SELECT MAX(fileid) FROM file));
+SELECT SETVAL('filename_filenameid_seq', (SELECT MAX(filenameid) FROM filename));
+SELECT SETVAL('fileset_filesetid_seq', (SELECT MAX(filesetid) FROM fileset));
+SELECT SETVAL('job_jobid_seq', (SELECT MAX(jobid) FROM job));
+SELECT SETVAL('jobmedia_jobmediaid_seq', (SELECT MAX(jobmediaid) FROM jobmedia));
 SELECT SETVAL('media_mediaid_seq', (SELECT MAX(mediaid) FROM media));
 SELECT SETVAL('path_pathid_seq', (SELECT MAX(pathid) FROM path));
-                
 SELECT SETVAL('pool_poolid_seq', (SELECT MAX(poolid) FROM pool));
-       
+
+SELECT SETVAL('device_deviceid_seq', (SELECT MAX(deviceid) FROM device));
+SELECT SETVAL('location_locationid_seq', (SELECT MAX(locationid) FROM location));
+SELECT SETVAL('locationlog_loclogid_seq', (SELECT MAX(loclogid) FROM locationlog));
+SELECT SETVAL('log_logid_seq', (SELECT MAX(logid) FROM log));
+SELECT SETVAL('mediatype_mediatypeid_seq', (SELECT MAX(mediatypeid) FROM mediatype));
+SELECT SETVAL('storage_storageid_seq', (SELECT MAX(storageid) FROM storage));       
 \end{verbatim}
 \normalsize