There is no table "file name" ??? This is strange.
Here is part of the database update script:
-- merge Filename in File table
INSERT INTO TmpMergeFilenameIntoFileTable
(FileId, FileIndex, JobId, PathId, Name, DeltaSeq, MarkId, LStat, Md5)
SELECT File.FileId, File.FileIndex, File.JobId, File. PathId,
Filename.Name, File.DeltaSeq,
File.MarkId, File.LStat, File.Md5 FROM File, Filename
WHERE File.FilenameId = Filename.FilenameId;
This operation takes most of the time.
And she is not optimal. Now I am trying to find a way out of this situation.
I also have a large base ...
The easiest way to solve the problem is to clear tables "file" and
"filename".
четверг, 10 октября 2019 г., 19:38:44 UTC+3 пользователь Kai Zimmer написал:
>
> Hi,
>
> i'm trying to upgrade my bareos installation from 15.2.2.-37.1 to
> 17.2.4-9.1. Updating the postgres 9.3 tables under Debian 16.04 runs for
> about 10 days already. I can see postgres is doing read and write access
> to temporary tables in the postgres directory (with fatrace) - and there
> is no other postgres database involved. I have plenty of free RAM and
> disk space. Swap is slowly growing (about 3 GB now).
>
> Is there any way to see how much progress update_bareos_tables script
> has made?
>
> Best,
>
> Kai
>
>
--
You received this message because you are subscribed to the Google Groups
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/bareos-users/2cf39f24-1f51-41e2-b9c3-865c7259b2f0%40googlegroups.com.
