Skip to content

Commit 89530f6

Browse files
DanielDentDanielDent
committed
POSTGRES_INITDB_XLOGDIR to specify xlog log dir
Adds support for the POSTGRES_INITDB_XLOGDIR environment variable, which specifies where the postgres transaction log is stored. For some use cases, being able to place the transaction log on a different volume is useful. Existing support for providing flags via $POSTGRES_INITDB_ARGS is inadequate because of the need to create and chown/chmod the directory prior to running initdb.
1 parent 7f792e7 commit 89530f6

11 files changed

+99
-0
lines changed

‎9.2/alpine/docker-entrypoint.sh

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -37,6 +37,15 @@ if [ "$1" = 'postgres' ] && [ "$(id -u)" = '0' ]; then
3737
chown -R postgres /var/run/postgresql
3838
chmod g+s /var/run/postgresql
3939

40+
# Create the transaction log directory before initdb is run (below) so the directory is owned by the correct user
41+
file_env 'POSTGRES_INITDB_XLOGDIR'
42+
if [ "$POSTGRES_INITDB_XLOGDIR" ]; then
43+
mkdir -p "$POSTGRES_INITDB_XLOGDIR"
44+
chmod 700 "$POSTGRES_INITDB_XLOGDIR"
45+
chown -R postgres "$POSTGRES_INITDB_XLOGDIR"
46+
export POSTGRES_INITDB_ARGS="$POSTGRES_INITDB_ARGS --xlogdir $POSTGRES_INITDB_XLOGDIR"
47+
fi
48+
4049
exec su-exec postgres "$BASH_SOURCE" "$@"
4150
fi
4251

‎9.2/docker-entrypoint.sh

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -37,6 +37,15 @@ if [ "$1" = 'postgres' ] && [ "$(id -u)" = '0' ]; then
3737
chown -R postgres /var/run/postgresql
3838
chmod g+s /var/run/postgresql
3939

40+
# Create the transaction log directory before initdb is run (below) so the directory is owned by the correct user
41+
file_env 'POSTGRES_INITDB_XLOGDIR'
42+
if [ "$POSTGRES_INITDB_XLOGDIR" ]; then
43+
mkdir -p "$POSTGRES_INITDB_XLOGDIR"
44+
chmod 700 "$POSTGRES_INITDB_XLOGDIR"
45+
chown -R postgres "$POSTGRES_INITDB_XLOGDIR"
46+
export POSTGRES_INITDB_ARGS="$POSTGRES_INITDB_ARGS --xlogdir $POSTGRES_INITDB_XLOGDIR"
47+
fi
48+
4049
exec gosu postgres "$BASH_SOURCE" "$@"
4150
fi
4251

‎9.3/alpine/docker-entrypoint.sh

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -37,6 +37,15 @@ if [ "$1" = 'postgres' ] && [ "$(id -u)" = '0' ]; then
3737
chown -R postgres /var/run/postgresql
3838
chmod g+s /var/run/postgresql
3939

40+
# Create the transaction log directory before initdb is run (below) so the directory is owned by the correct user
41+
file_env 'POSTGRES_INITDB_XLOGDIR'
42+
if [ "$POSTGRES_INITDB_XLOGDIR" ]; then
43+
mkdir -p "$POSTGRES_INITDB_XLOGDIR"
44+
chmod 700 "$POSTGRES_INITDB_XLOGDIR"
45+
chown -R postgres "$POSTGRES_INITDB_XLOGDIR"
46+
export POSTGRES_INITDB_ARGS="$POSTGRES_INITDB_ARGS --xlogdir $POSTGRES_INITDB_XLOGDIR"
47+
fi
48+
4049
exec su-exec postgres "$BASH_SOURCE" "$@"
4150
fi
4251

‎9.3/docker-entrypoint.sh

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -37,6 +37,15 @@ if [ "$1" = 'postgres' ] && [ "$(id -u)" = '0' ]; then
3737
chown -R postgres /var/run/postgresql
3838
chmod g+s /var/run/postgresql
3939

40+
# Create the transaction log directory before initdb is run (below) so the directory is owned by the correct user
41+
file_env 'POSTGRES_INITDB_XLOGDIR'
42+
if [ "$POSTGRES_INITDB_XLOGDIR" ]; then
43+
mkdir -p "$POSTGRES_INITDB_XLOGDIR"
44+
chmod 700 "$POSTGRES_INITDB_XLOGDIR"
45+
chown -R postgres "$POSTGRES_INITDB_XLOGDIR"
46+
export POSTGRES_INITDB_ARGS="$POSTGRES_INITDB_ARGS --xlogdir $POSTGRES_INITDB_XLOGDIR"
47+
fi
48+
4049
exec gosu postgres "$BASH_SOURCE" "$@"
4150
fi
4251

‎9.4/alpine/docker-entrypoint.sh

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -37,6 +37,15 @@ if [ "$1" = 'postgres' ] && [ "$(id -u)" = '0' ]; then
3737
chown -R postgres /var/run/postgresql
3838
chmod g+s /var/run/postgresql
3939

40+
# Create the transaction log directory before initdb is run (below) so the directory is owned by the correct user
41+
file_env 'POSTGRES_INITDB_XLOGDIR'
42+
if [ "$POSTGRES_INITDB_XLOGDIR" ]; then
43+
mkdir -p "$POSTGRES_INITDB_XLOGDIR"
44+
chmod 700 "$POSTGRES_INITDB_XLOGDIR"
45+
chown -R postgres "$POSTGRES_INITDB_XLOGDIR"
46+
export POSTGRES_INITDB_ARGS="$POSTGRES_INITDB_ARGS --xlogdir $POSTGRES_INITDB_XLOGDIR"
47+
fi
48+
4049
exec su-exec postgres "$BASH_SOURCE" "$@"
4150
fi
4251

‎9.4/docker-entrypoint.sh

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -37,6 +37,15 @@ if [ "$1" = 'postgres' ] && [ "$(id -u)" = '0' ]; then
3737
chown -R postgres /var/run/postgresql
3838
chmod g+s /var/run/postgresql
3939

40+
# Create the transaction log directory before initdb is run (below) so the directory is owned by the correct user
41+
file_env 'POSTGRES_INITDB_XLOGDIR'
42+
if [ "$POSTGRES_INITDB_XLOGDIR" ]; then
43+
mkdir -p "$POSTGRES_INITDB_XLOGDIR"
44+
chmod 700 "$POSTGRES_INITDB_XLOGDIR"
45+
chown -R postgres "$POSTGRES_INITDB_XLOGDIR"
46+
export POSTGRES_INITDB_ARGS="$POSTGRES_INITDB_ARGS --xlogdir $POSTGRES_INITDB_XLOGDIR"
47+
fi
48+
4049
exec gosu postgres "$BASH_SOURCE" "$@"
4150
fi
4251

‎9.5/alpine/docker-entrypoint.sh

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -37,6 +37,15 @@ if [ "$1" = 'postgres' ] && [ "$(id -u)" = '0' ]; then
3737
chown -R postgres /var/run/postgresql
3838
chmod g+s /var/run/postgresql
3939

40+
# Create the transaction log directory before initdb is run (below) so the directory is owned by the correct user
41+
file_env 'POSTGRES_INITDB_XLOGDIR'
42+
if [ "$POSTGRES_INITDB_XLOGDIR" ]; then
43+
mkdir -p "$POSTGRES_INITDB_XLOGDIR"
44+
chmod 700 "$POSTGRES_INITDB_XLOGDIR"
45+
chown -R postgres "$POSTGRES_INITDB_XLOGDIR"
46+
export POSTGRES_INITDB_ARGS="$POSTGRES_INITDB_ARGS --xlogdir $POSTGRES_INITDB_XLOGDIR"
47+
fi
48+
4049
exec su-exec postgres "$BASH_SOURCE" "$@"
4150
fi
4251

‎9.5/docker-entrypoint.sh

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -37,6 +37,15 @@ if [ "$1" = 'postgres' ] && [ "$(id -u)" = '0' ]; then
3737
chown -R postgres /var/run/postgresql
3838
chmod g+s /var/run/postgresql
3939

40+
# Create the transaction log directory before initdb is run (below) so the directory is owned by the correct user
41+
file_env 'POSTGRES_INITDB_XLOGDIR'
42+
if [ "$POSTGRES_INITDB_XLOGDIR" ]; then
43+
mkdir -p "$POSTGRES_INITDB_XLOGDIR"
44+
chmod 700 "$POSTGRES_INITDB_XLOGDIR"
45+
chown -R postgres "$POSTGRES_INITDB_XLOGDIR"
46+
export POSTGRES_INITDB_ARGS="$POSTGRES_INITDB_ARGS --xlogdir $POSTGRES_INITDB_XLOGDIR"
47+
fi
48+
4049
exec gosu postgres "$BASH_SOURCE" "$@"
4150
fi
4251

‎9.6/alpine/docker-entrypoint.sh

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -37,6 +37,15 @@ if [ "$1" = 'postgres' ] && [ "$(id -u)" = '0' ]; then
3737
chown -R postgres /var/run/postgresql
3838
chmod g+s /var/run/postgresql
3939

40+
# Create the transaction log directory before initdb is run (below) so the directory is owned by the correct user
41+
file_env 'POSTGRES_INITDB_XLOGDIR'
42+
if [ "$POSTGRES_INITDB_XLOGDIR" ]; then
43+
mkdir -p "$POSTGRES_INITDB_XLOGDIR"
44+
chmod 700 "$POSTGRES_INITDB_XLOGDIR"
45+
chown -R postgres "$POSTGRES_INITDB_XLOGDIR"
46+
export POSTGRES_INITDB_ARGS="$POSTGRES_INITDB_ARGS --xlogdir $POSTGRES_INITDB_XLOGDIR"
47+
fi
48+
4049
exec su-exec postgres "$BASH_SOURCE" "$@"
4150
fi
4251

‎9.6/docker-entrypoint.sh

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -37,6 +37,15 @@ if [ "$1" = 'postgres' ] && [ "$(id -u)" = '0' ]; then
3737
chown -R postgres /var/run/postgresql
3838
chmod g+s /var/run/postgresql
3939

40+
# Create the transaction log directory before initdb is run (below) so the directory is owned by the correct user
41+
file_env 'POSTGRES_INITDB_XLOGDIR'
42+
if [ "$POSTGRES_INITDB_XLOGDIR" ]; then
43+
mkdir -p "$POSTGRES_INITDB_XLOGDIR"
44+
chmod 700 "$POSTGRES_INITDB_XLOGDIR"
45+
chown -R postgres "$POSTGRES_INITDB_XLOGDIR"
46+
export POSTGRES_INITDB_ARGS="$POSTGRES_INITDB_ARGS --xlogdir $POSTGRES_INITDB_XLOGDIR"
47+
fi
48+
4049
exec gosu postgres "$BASH_SOURCE" "$@"
4150
fi
4251

‎docker-entrypoint.sh

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -37,6 +37,15 @@ if [ "$1" = 'postgres' ] && [ "$(id -u)" = '0' ]; then
3737
chown -R postgres /var/run/postgresql
3838
chmod g+s /var/run/postgresql
3939

40+
# Create the transaction log directory before initdb is run (below) so the directory is owned by the correct user
41+
file_env 'POSTGRES_INITDB_XLOGDIR'
42+
if [ "$POSTGRES_INITDB_XLOGDIR" ]; then
43+
mkdir -p "$POSTGRES_INITDB_XLOGDIR"
44+
chmod 700 "$POSTGRES_INITDB_XLOGDIR"
45+
chown -R postgres "$POSTGRES_INITDB_XLOGDIR"
46+
export POSTGRES_INITDB_ARGS="$POSTGRES_INITDB_ARGS --xlogdir $POSTGRES_INITDB_XLOGDIR"
47+
fi
48+
4049
exec gosu postgres "$BASH_SOURCE" "$@"
4150
fi
4251

0 commit comments

Comments
 (0)