On 16/01/2021 07:16, Ken Johnson wrote:
Thanks for the helpful advice. It sounds like an issue with timestamp
translation, though I am far from a database expert.
I am working on the same approach, pgloader to postgresql. I do not do
incrementals, so that particular issue will not be a problem here. Of course,
full backups five times/week probably contributes to the 5GB size of the
database, which adds challenges of its own.
If my energy holds up and my to-do list is not too long, I hope to post a
summary here when complete.
I'd say that 5GB isn't much.
When I moved from MySQL to PostgreSQL I had to massage ~45Gb of data, I
never looked at how long it took, it was just fire it off and check for
it being finished, as I wasn't going to start using the new database
until I was sure that it was complete.
It took about a week of running the various scripts I came up with to
get a final set, I then ran them in the morning, changed Bacula to see
the new server in the arvo, and it all worked.
Mild disclaimer: I've written databases - in the sense of the underlying
code that stores and fetches the various values - for a living. Writing
chains of shell and perl and whatever scripts to move data from here to
there is almost organic these days!
Cheers,
Gary B-)
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
