Ability to use database backup?

[manosbatsis]

postgresql-embedded allows the use of a dump file. Does the plugin allow using a database dump or pgadmin backup in the current version?

[slavaz]

Well... in general, no, the plugin doesn't allow to apply any dump files.

Usually, I use Liquibase + DbUnit, so creating a DB structure and filling by some test data are processed in other way...

But you have good point here, because it may be a case with previously created users, for example. In this case even Liquibase may fail because changesets may contain some kind of GRANT/REVOKE commands with the predefined user...

So, I'll try to implement the feature in near time.

Thanks!

[manosbatsis]

I use Flyway instead of Liquibase, but creating SQL migrations out postgres data is a series of pain, including file format, file spiting to avoid github file size limits etc. If i wanted to implement this, what would be the necessary changes you'd point to/agree with?

[slavaz]

@manosbatsis : Do you have ability to compile & check a code from the branch: #12 ?

[manosbatsis]

Sorry, missed this. I actually tried adding importFile and restoreFile properties to the plugin a couple of days ago and according to the examples of postgres-embedded, see my fork here: manosbatsis@6c8295e

The latter however does not seem to work, probably needs the right combination with dbName and/or pg_dump options, but haven't found time to add a test and explore the issue further.