FROM supabase/postgres:17.6.1.136
USER root
COPY 99-roles.sql /docker-entrypoint-initdb.d/init-scripts/99-roles.sql
COPY 99-jwt.sql /docker-entrypoint-initdb.d/init-scripts/99-jwt.sql
COPY railway-entrypoint.sh /usr/local/bin/railway-entrypoint.sh
RUN sed -i 's/\r$//' /usr/local/bin/railway-entrypoint.sh && chmod 0755 /usr/local/bin/railway-entrypoint.sh
ENV POSTGRES_DB=postgres PGPORT=5432 POSTGRES_PORT=5432 JWT_EXP=3600 PGDATA=/var/lib/postgresql/data/pgdata
ENTRYPOINT ["/usr/local/bin/railway-entrypoint.sh"]
CMD ["postgres", "-c", "config_file=/etc/postgresql/postgresql.conf", "-c", "listen_addresses=*"]
