Hello everybody,
now I achieved to create a backup using !:
sudo -u postgres pg_dumpall > /media/backup/XWIKIBAK/xwiki.sql
is this a good way at all?
Trying to restore the backup, I get an error message (is is very long, here just an excerpt):
psql:xwiki.sql:44257: ERROR: relation "xwvs_end_date" already exists
psql:xwiki.sql:44264: ERROR: relation "xwvs_ip" already exists
psql:xwiki.sql:44271: ERROR: relation "xwvs_name" already exists
psql:xwiki.sql:44278: ERROR: relation "xwvs_page_saves" already exists
psql:xwiki.sql:44285: ERROR: relation "xwvs_page_views" already exists
psql:xwiki.sql:44292: ERROR: relation "xwvs_start_date" already exists
psql:xwiki.sql:44299: ERROR: relation "xwvs_unique_id" already exists
psql:xwiki.sql:44307: ERROR: constraint "fk2780715a3433fd87" for relation "xwikistrings" already exists
psql:xwiki.sql:44315: ERROR: constraint "fk44132acc763934e1" for relation "activitystream_events_targets" already exists
psql:xwiki.sql:44323: ERROR: constraint "fk5a1cd9a1a947aa5" for relation "xwikidoubles" already exists
psql:xwiki.sql:44331: ERROR: constraint "fk6661970f283ee295" for relation "xwikilargestrings" already exists
psql:xwiki.sql:44339: ERROR: constraint "fk7b845b068e772cc" for relation "feeds_aggregatorurlgroups" already exists
psql:xwiki.sql:44347: ERROR: constraint "fk7f8ab31d231efb9b" for relation "xwikiintegers" already exists
psql:xwiki.sql:44355: ERROR: constraint "fkbe0037834855150f" for relation "feeds_feedentrytags" already exists
psql:xwiki.sql:44363: ERROR: constraint "fkbf7104e8cb8c5002" for r
How can I restore my backup properly?
Thank you for help!
All the best,
Vince