PostgreSQL < 9.4 not supported about holoclean HOT 6 CLOSED

Hi @pmaetzig thank you very much for your interest in holoclean and for digging deep into this issue and coming up with a solution.

We are currently relying on the features in newer versions of postgresql because they provide necessary optimizations especially in joins.

I understand that you might be limited to a particular version of postgresql. If it is possible for you to use dockers, I suggest starting a postgres docker instance with the latest postgres version 11 as follows

docker run --name pghc \
    -e POSTGRES_DB=holo -e POSTGRES_USER=holocleanuser -e POSTGRES_PASSWORD=abcd1234 \
    -p 5432:5432 \
    -d postgres:11

and you can use docker start pghc and docker stop pghc to start/stop the container.

You can find details about this image here and feel free to ask about any details.

from holoclean.

Thanks, I was just sharing it in case someone runs into a similar problem and -- as you said -- if someone else is restricted to some older version of postgres. One thing that would be helpful is referencing the optimal postgres version in the readme.

I will try using the docker solution, thanks!

from holoclean.

@pmaetzig Please let us know of your experience with docker. More than happy to help in case of any issues.

from holoclean.

Hi, sorry for the late update -- docker is not an option with my current setup. The most viable solution would be to get an upgrade of postgresql working. When I tried on another machine with an updated version of postgres, this issue did not occur any more.

What else could be affected by using an older postgresql version, potentially?

from holoclean.

I've managed to upgrade to postgresql 9.4, this fixes the issue as expected. I don't know of any other bugs that occur because of an older postgres version, but this issue can be closed in my opinion.

from holoclean.

Thank you Paul for your feedback... One other alternative instead of dockers is to install a local copy of postgresql form its sources. This would be just like any local program.

from holoclean.