The exact lines to import/export the PostgresQL Database:

Export:

pg_dump -f archiveName.tar -F tar -v -b databaseName

Import:

pg_restore -O archiveName.tar -d databaseName

Hello,

thank you for the tip. This was a good hint, but it did not work exactly as provided. After doing this and importing the database again, the repository was missing. As we found out there are some additioinal parameters necessary to get everything from the database. You need to specify: pg_dump -b dbname > outputfile

-b for dumping also the blobs (important) optionally also -c for cleaning the db before import -C for including create information in the export -f for specifying output file

Ok, thank you for the explanation, I understand now. First I also did a mistake with the So6. I expected after a import of a project, that the workspace is there, but it was not, so I thought the repository got not ex/imported. But I was wrong. The WorkSpace is userdependent and therefore was not moved.

Now just one question about a complete backup, not moving a project or platform to another server, but having a backup for the case of system failure. How do I do this, so that I have the users backed up as well? This does obviously not work using export/import.

When I am making a backup of the PostgreSQL database, is this enough to have everything? So that I can restore it after a break down and continue exactly where I was as I made the backup?

I am not sure if I understood now, if I can create a complete backup of a project or platform, including all forums, files, and repositories (So6 Queue?). Maybe I need to read a bit more about So6 to understand it. But as I understood, LibreSource should make it possible to move complete projects from one server to another, and this should include the maybe not necessarily the user accounts, but for sure the complete source code in the repository, so that the same or new developers on the new server can check out the complete source code for working with it. Or do I understand or expect something wrong?

How is it possible to import the saved data on a specified ressource path? By now I've only been able to import them with the bootstrap page where you cannot specified a prefix to the relative path saved.

Hi,

great, thank you for the information. It works great. Just the Repository (So6 queue) is not exported. Any idea, how I can backup this? Or is it done, and I need to activate it in some way?

Greetings, Rüdiger

Hello everybody,

maybe, I missed it somewhere in the existing documentation, but I wonder how actually export a LibreSource project into some file or folder structure, so that you can move it to another server, or have it as backup.

Thank you for your help.

Rüdiger Lincke rudiger.lincke@msi.vxu.se