Page 1 of 1
Restore DUMP, PostgreSQL
Posted: Wed 02 Oct 2013 18:41
by FCS
Hello,
How to restore a dump created by the UniDump component from PostgreSQL database?
Regards
Michal
Re: Restore DUMP, PostgreSQL
Posted: Thu 03 Oct 2013 11:15
by AlexP
Hello,
A BackUp created in UniDump is a file containing DML commands, therefore you can restore data by executing these scripts in any SQL editor.
Re: Restore DUMP, PostgreSQL
Posted: Thu 03 Oct 2013 11:48
by FCS
Hello,
I have tried do this.
1. There is a problem on the constrains.
2. Is it correct that a dump contains data from database views?
3. My dump file contains blob data too. This way its size is about 100MB. The PgAdmin's SQL editor has problems with so big files. Do you know a good tool to read and execute commands from so big files?
Regards
Michal
Re: Restore DUMP, PostgreSQL
Posted: Thu 03 Oct 2013 14:02
by AlexP
Hello,
1) Before restoring data from the dump, you should disable all constraints and triggers, since tables are dumped alphabetically;
2) Bug with dump data from view was fixed in version 4.5.10;
3) You can try running the commands from your file by the standard console utility - psql.
Re: Restore DUMP, PostgreSQL
Posted: Thu 03 Oct 2013 16:16
by FCS
Hello,
Ad.1
How to do it in proper way?
Ad.2
I use UniDac 4.6.12. Data from the views exist in the dump file.
Ad.3
Thanks.
Regards
Michal
Re: Restore DUMP, PostgreSQL
Posted: Fri 04 Oct 2013 10:35
by AlexP
Hello,
1) If constraints are created with the DEFERRABLE option, you can disable them within a transaction in the following way:
Code: Select all
Start transaction;
ALTER TABLE test drop CONSTRAINT pk_test;
ALTER TABLE test ADD CONSTRAINT pk_test PRIMARY KEY(id) DEFERRABLE;
SET CONSTRAINTS ALL DEFERRED;
--data insert
COMMIT;
2) We have fixed the behaviour, now in UniDAC, as well as in PgDAC, data returned from view is not included to backup
Re: Restore DUMP, PostgreSQL
Posted: Fri 04 Oct 2013 11:19
by FCS
Hello,
Could you check from which version of UniDac the Dump file doesn't contain data from views ?
Thanks
Michal
Re: Restore DUMP, PostgreSQL
Posted: Mon 07 Oct 2013 10:43
by AlexP
Hello,
This fix will be included in the new version
Re: Restore DUMP, PostgreSQL
Posted: Mon 07 Oct 2013 12:01
by FCS
Hello,
When do you plan to release the new version ?
I understand that this version will be next to 5.1.4?
Regards
Michal
Re: Restore DUMP, PostgreSQL
Posted: Mon 07 Oct 2013 12:42
by AlexP
Hello,
This feature will be added to the next UniDAC 5.1.5 release
Re: Restore DUMP, PostgreSQL
Posted: Mon 07 Oct 2013 13:34
by FCS
Hello,
When do you release the new version ?
Regards
Michal
Re: Restore DUMP, PostgreSQL
Posted: Tue 08 Oct 2013 08:38
by AndreyZ
We plan to release all DAC products next month.