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

Import:

pg_restore -O archiveName.tar -d databaseName]]> http://dev.libresource.org/home/community/forum/220a4814c0a8001e00f04006609041c8/579bc8a9c0a8001e014e52129ee05b82 Guest 2006-01-11T12:22:53+01:00 You can find more information about the "pgdump" utility there: http://www.postgresql.org/docs/7.3/static/app-pgdump.html]]> http://dev.libresource.org/home/community/forum/220a4814c0a8001e00f04006609041c8/5459e718c0a8001e01906c6605a259e1 Rüdiger Lincke 2006-01-11T12:22:53+01:00 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]]> http://dev.libresource.org/home/community/forum/220a4814c0a8001e00f04006609041c8/5367594ac0a8001e01629355410603f6 Maxime Biais 2006-01-11T12:22:53+01:00 $ pg_dump libresource > ls-dump.sql

and then, reload the dumped base:

$ psql -d libresource -f ls-dump.sql

And you will be in the "backuped state"]]> http://dev.libresource.org/home/community/forum/220a4814c0a8001e00f04006609041c8/4cf6cefbc0a8001e01838ae3fa004791 Rüdiger Lincke 2006-01-11T12:22:53+01:00 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?]]> http://dev.libresource.org/home/community/forum/220a4814c0a8001e00f04006609041c8/38748ccdc0a8001e004b1eb00e50b80d Sebastien Jourdain 2006-01-11T12:22:53+01:00 (quoted message not found : ls://dev.libresource.org/home/forum/220a4814c0a8001e00f04006609041c8/35197081c0a8001e008c425fd8ae2d17)

Exactly… But we do not provide the user migration. When you move a project, you will have to add again the developers and members insides your groups to allow them to access to there data… And the personn who made the import will be the owner of the whole project…]]> http://dev.libresource.org/home/community/forum/220a4814c0a8001e00f04006609041c8/35197081c0a8001e008c425fd8ae2d17 Guest 2006-01-11T12:22:53+01:00 http://dev.libresource.org/home/community/forum/220a4814c0a8001e00f04006609041c8/35148d97c0a8001e01dc0489b7354d1e Guest 2006-01-11T12:22:53+01:00 http://dev.libresource.org/home/community/forum/220a4814c0a8001e00f04006609041c8/33911013c0a8001e010ec7cc504c133b pascal bertrand 2006-01-11T12:22:53+01:00 http://dev.libresource.org/home/community/forum/220a4814c0a8001e00f04006609041c8/2aff7d0fc0a8001e00d57256bed870df Maxime Biais 2006-01-11T12:22:53+01:00