Hi Stefano,
You should use the PostgreSQL backuper instead of Octopus.
The PostgreSQL backuper relies on pg_dump to perform the dumps and
should be able to dump/restore your entire database.
Hope this helps,
Emmanuel
I'm trying sequoia and I found an issue with tables with binary data
on postgresql.
My db is:
CREATE TABLE photo
(
id bigint NOT NULL,
photo bytea,
CONSTRAINT photo_pkey PRIMARY KEY (id)
);
CREATE TABLE test
(
id bigint NOT NULL,
name character varying(255),
CONSTRAINT test_pkey PRIMARY KEY (id)
);
(it is not my real db but I wanted isolate the issue).
I'm able to backup the db from a backend, but restoring it on another
backend, just the table "test" is created. I'm using postgres and in
attachment the full_cluster log.
Sequoia console contains the output on the console.
init_test_dump contains the backup (it's just 10kb since there are not
data).
Any suggestion ? Is it a issue with binary data ? My real db has 33
tables and just the one with binary data is missing.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
