for workaroud I try via psql in restored DB:
ALTER TABLE res_user ADD PRIMARY KEY (id);
I see that the primary key is back but this procedure I'll need to do for all the tables that I find without.
what's going wrong in my backup procedure, is better use pg_dump / pg_restore?
Thanks
for workaroud I try via psql in restored DB:
ALTER TABLE res_user ADD PRIMARY KEY (id);
I see that the primary key is back but this procedure I'll need to do for all the tables that I find without.
what's going wrong in my backup procedure, is better use pg_dump / pg_restore?
Thanks