[prev in list] [next in list] [prev in thread] [next in thread] 

List:       bacula-commits
Subject:    [Bacula-commits] git: Bacula Community Documentation branch,
From:       "Kern Sibbald" <kerns () users ! sourceforge ! net>
Date:       2010-08-09 13:02:55
Message-ID: E1OiS0H-000693-Rr () sfp-scmshell-2 ! v30 ! ch3 ! sourceforge ! com
[Download RAW message or body]

This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "Bacula Community Documentation".

The branch, Branch-5.0 has been updated
       via  28a3766aabe3a470c244e9f0ca2aabbb8fc47a76 (commit)
       via  09a3107587474b5687704176b36e75001531f73d (commit)
      from  ca7b0f4a5e847432e40ab28fabc5924aef485f3b (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 28a3766aabe3a470c244e9f0ca2aabbb8fc47a76
Author: Eric Bollengier <eric@eb.homelinux.org>
Date:   Sun Aug 8 15:44:50 2010 +0200

    Update package version in MySQL -> Postgresql convertion

commit 09a3107587474b5687704176b36e75001531f73d
Author: Eric Bollengier <eric@eb.homelinux.org>
Date:   Sun Aug 8 15:38:33 2010 +0200

    Update MySQL -> Postgresql migration doc

-----------------------------------------------------------------------

Summary of changes:
diff --git a/docs/manuals/en/main/postgresql.tex b/docs/manuals/en/main/postgresql.tex
index 0d22a7b..5214d8e 100644
--- 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
 
@@ -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
 


hooks/post-receive
-- 
Bacula Community Documentation

------------------------------------------------------------------------------
This SF.net email is sponsored by 

Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev 
_______________________________________________
Bacula-commits mailing list
Bacula-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-commits
[prev in list] [next in list] [prev in thread] [next in thread]