installing postgresql twice

[ltalirz]

@yakutovicha You're currently installing postgresql twice in the aiidalab-1.0-migration branch:

version 10

aiidalab-docker-stack/Dockerfile

Line 41 in 530c7f5

postgresql \

and version 9.6

aiidalab-docker-stack/Dockerfile

Lines 72 to 77 in 530c7f5

	# Add repo for postgres-9.6
	RUN echo "deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main" >> /etc/apt/sources.list.d/pgdg.list
	RUN wget -q https://www.postgresql.org/media/keys/ACCC4CF8.asc -O - | apt-key add -
	RUN apt-get update && apt-get install -y --no-install-recommends \
	postgresql-9.6 \
	&& rm -rf /var/lib/apt/lists/*

What ends up running is version 10:

# ps -ef | grep postgresql
scienti+    43     1  0 19:59 ?        00:00:00 /usr/lib/postgresql/10/bin/postgres -D /project/.postgresql

This will bite you when you try to migrate databases from the previous image that was running postgres 9.6.
Either you add some migration scripts or you switch back to version 9.6

[yakutovicha]

I choose to run version 10 and provide migration scripts. This is anyways done for aiida-1.0 (0.12 uses Postgres 9.6)

Thanks for catching this error!

[yakutovicha]

This is now fixed, I created a separate issue #25 to remind myself about migration scripts.