Postgresql.dockerfile

ARG BASE_IMAGE=xj4reg/ubuntu-dev:latest
#ARG BASE_IMAGE=registry-vpc.cn-hongkong.aliyuncs.com/xj4reg/ubuntu-dev:latest
FROM ${BASE_IMAGE}

ARG USER=devuser

USER root
#install dependences
RUN sudo apt-get install -y libreadline-dev zlib1g-dev flex bison libxml2-dev libxslt-dev libssl-dev libxml2-utils xsltproc bear python3-pip && pip install compdb

#get source
WORKDIR /home/${USER}
ADD --chown=${USER}:${USER} files/postgresql-13.5.tar.gz /home/${USER}/
RUN mv /home/${USER}/postgresql-13.5 /home/${USER}/postgresql

#make
WORKDIR /home/${USER}/postgresql
RUN ./configure && bear -- make world && make install-world && compdb -p ./ list > compile_commands.compdb.json && mv compile_commands.compdb.json compile_commands.json && make clean

#update profile
ADD --chown=${USER}:${USER} files/dotprofile.postgresql /home/${USER}/.profile
#add .inputrc
ADD --chown=${USER}:${USER} files/dotinputrc /home/${USER}/.inputrc

#clean up
#RUN rm -rf /home/${USER}/postgresql-13.5.tar
RUN chown -R ${USER}:${USER} /home/${USER}/postgresql

#create database
USER ${USER}
RUN mkdir /home/${USER}/pgdata
RUN . /home/${USER}/.profile && initdb -D /home/${USER}/pgdata --username ${USER} --encoding=UTF-8

#add postgresql script
ADD --chown=${USER}:${USER} --chmod=777 files/startdb.sh /home/${USER}/startdb.sh
ADD --chown=${USER}:${USER} --chmod=777 files/stopdb.sh /home/${USER}/stopdb.sh
ADD --chown=${USER}:${USER} --chmod=777 files/psql.sh /home/${USER}/psql.sh
ADD --chown=${USER}:${USER} files/clangd/config.yaml /home/${USER}/.config/clangd/config.yaml

WORKDIR /home/${USER}
ENV TERM xterm-256color
CMD ["zsh"]