pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Docker with data inside
3+ messages / 2 participants
[nested] [flat]

* Docker with data inside
@ 2016-10-20 09:04 Κοκμάδης Δημήτριος <dkokmadis@gmail.com>
  2016-10-20 09:31 ` Re: Docker with data inside Achilleas Mantzios <achill@matrix.gatewaynet.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Κοκμάδης Δημήτριος @ 2016-10-20 09:04 UTC (permalink / raw)
  To: pgsql-admin

Hello,

I am trying to create a docker Postgres container with database inside.

When I try to run the container I have the following error

2016-10-20 08:58:33 UTC  FATAL:  the database system is starting up
2016-10-20 08:58:33 UTC  DEBUG:  shmem_exit(1): 0 before_shmem_exit
callbacks to make
2016-10-20 08:58:33 UTC  DEBUG:  shmem_exit(1): 0 on_shmem_exit callbacks
to make
2016-10-20 08:58:33 UTC  DEBUG:  proc_exit(1): 1 callbacks to make
2016-10-20 08:58:33 UTC  DEBUG:  exit(1)


The entry point is

su -c "/usr/lib/postgresql/9.4/bin/postgres -d 3 -D
/var/lib/postgresql/9.4/main -c
config_file=/etc/postgresql/9.4/main/postgresql.conf" postgres

and the output of command

2016-10-20 08:56:58 UTC  DEBUG:  postgres: PostmasterMain: initial
environment dump:
2016-10-20 08:56:58 UTC  DEBUG:  -----------------------------------------
2016-10-20 08:56:58 UTC  DEBUG:   HOSTNAME=c0e6a383b652
2016-10-20 08:56:58 UTC  DEBUG:   SHELL=/bin/bash
2016-10-20 08:56:58 UTC  DEBUG:   TERM=xterm
2016-10-20 08:56:58 UTC  DEBUG:   USER=postgres
2016-10-20 08:56:58 UTC  DEBUG:   MAIL=/var/mail/postgres
2016-10-20 08:56:58 UTC  DEBUG:
PATH=/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games
2016-10-20 08:56:58 UTC  DEBUG:   _=/usr/lib/postgresql/9.4/bin/postgres
2016-10-20 08:56:58 UTC  DEBUG:   PWD=/var/ansible
2016-10-20 08:56:58 UTC  DEBUG:   LANG=en_US.UTF-8
2016-10-20 08:56:58 UTC  DEBUG:   HOME=/var/lib/postgresql
2016-10-20 08:56:58 UTC  DEBUG:   SHLVL=2
2016-10-20 08:56:58 UTC  DEBUG:   LOGNAME=postgres
2016-10-20 08:56:58 UTC  DEBUG:   PGLOCALEDIR=/usr/share/locale
2016-10-20 08:56:58 UTC  DEBUG:   PGSYSCONFDIR=/etc/postgresql-common
2016-10-20 08:56:58 UTC  DEBUG:   LC_COLLATE=en_US.UTF-8
2016-10-20 08:56:58 UTC  DEBUG:   LC_CTYPE=en_US.UTF-8
2016-10-20 08:56:58 UTC  DEBUG:   LC_MESSAGES=en_US.UTF-8
2016-10-20 08:56:58 UTC  DEBUG:   LC_MONETARY=C
2016-10-20 08:56:58 UTC  DEBUG:   LC_NUMERIC=C
2016-10-20 08:56:58 UTC  DEBUG:   LC_TIME=C
2016-10-20 08:56:58 UTC  DEBUG:  -----------------------------------------
2016-10-20 08:56:58 UTC  DEBUG:  invoking IpcMemoryCreate(size=294363136)
2016-10-20 08:56:58 UTC  DEBUG:  mmap with MAP_HUGETLB failed, huge pages
disabled: Cannot allocate memory
2016-10-20 08:56:58 UTC  DEBUG:  SlruScanDirectory invoking callback on
pg_notify/0000
2016-10-20 08:56:58 UTC  DEBUG:  removing file "pg_notify/0000"
2016-10-20 08:56:58 UTC  DEBUG:  dynamic shared memory system will support
108 segments
2016-10-20 08:56:58 UTC  DEBUG:  created dynamic shared memory control
segment 1804289383 (876 bytes)
2016-10-20 08:56:58 UTC  DEBUG:  max_safe_fds = 984, usable_fds = 1000,
already_open = 6
2016-10-20 08:56:58 UTC  LOG:  redirecting log output to logging collector
process
2016-10-20 08:56:58 UTC  HINT:  Future log output will appear in directory
"/var/log/postgresql".
2016-10-20 09:00:41 UTC  DEBUG:  logger shutting down
2016-10-20 09:00:41 UTC  DEBUG:  shmem_exit(0): 0 before_shmem_exit
callbacks to make
2016-10-20 09:00:41 UTC  DEBUG:  shmem_exit(0): 0 on_shmem_exit callbacks
to make
2016-10-20 09:00:41 UTC  DEBUG:  proc_exit(0): 0 callbacks to make
2016-10-20 09:00:41 UTC  DEBUG:  exit(0)
2016-10-20 09:00:41 UTC  DEBUG:  shmem_exit(-1): 0 before_shmem_exit
callbacks to make
2016-10-20 09:00:41 UTC  DEBUG:  shmem_exit(-1): 0 on_shmem_exit callbacks
to make
2016-10-20 09:00:41 UTC  DEBUG:  proc_exit(-1): 0 callbacks to make


My configuration parameters are

data_directory = '/var/lib/postgresql/9.4/main' # use data in another
directory
hba_file = '/etc/postgresql/9.4/main/pg_hba.conf' # host-based
authentication file
ident_file = '/etc/postgresql/9.4/main/pg_ident.conf' # ident configuration
file
external_pid_file = '/var/run/postgresql/9.4-main.pid' # write an extra PID
file
listen_addresses = '0.0.0.0'
port = 5432 # (change requires restart)
max_connections = 10
unix_socket_directories = '/var/run/postgresql' # comma-separated list of
directories
ssl = true # (change requires restart)
ssl_cert_file = '/etc/ssl/certs/ssl-cert-snakeoil.pem' # (change requires
restart)
ssl_key_file = '/etc/ssl/private/ssl-cert-snakeoil.key' # (change requires
restart)
shared_buffers = 256MB
work_mem = 256MB
maintenance_work_mem = 128MB
dynamic_shared_memory_type = posix # the default is the first option
wal_level = hot_standby
wal_buffers = 16MB
checkpoint_segments = 64
checkpoint_completion_target = 0.7
max_wal_senders = 6
wal_keep_segments = 8
effective_cache_size = 256MB
default_statistics_target = 100
logging_collector = on
log_directory = '/var/log/postgresql'
log_filename = 'postgresql-%Y-%m-%d.log'
log_rotation_age = 1d
log_min_duration_statement = 5000
log_line_prefix = '%t  '
log_timezone = 'localtime'
stats_temp_directory = '/var/run/postgresql/9.4-main.pg_stat_tmp'
log_autovacuum_min_duration = -1
autovacuum_max_workers = 3
autovacuum_naptime = 15min
autovacuum_vacuum_threshold = 50
autovacuum_analyze_threshold = 50
autovacuum = on
datestyle = 'iso, mdy'
timezone = 'UTC'
timezone = 'Europe/Athens'
client_encoding = UTF8
lc_messages = 'en_US.UTF-8' # locale for system error message
lc_monetary = 'en_US.UTF-8' # locale for monetary formatting
lc_numeric = 'en_US.UTF-8' # locale for number formatting
lc_time = 'en_US.UTF-8' # locale for time formatting
default_text_search_config = 'pg_catalog.english'

Thanks,

Dimitris

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Docker with data inside
  2016-10-20 09:04 Docker with data inside Κοκμάδης Δημήτριος <dkokmadis@gmail.com>
@ 2016-10-20 09:31 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
  2016-10-20 12:07   ` Re: Docker with data inside Κοκμάδης Δημήτριος <dkokmadis@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Achilleas Mantzios @ 2016-10-20 09:31 UTC (permalink / raw)
  To: pgsql-admin

Καλημέρα Δημήτρη

On 20/10/2016 12:04, Κοκμάδης Δημήτριος wrote:
> Hello,
>
> I am trying to create a docker Postgres container with database inside.
>
> When I try to run the container I have the following error
>
> 2016-10-20 08:58:33 UTC  FATAL:  the database system is starting up
> 2016-10-20 08:58:33 UTC  DEBUG:  shmem_exit(1): 0 before_shmem_exit callbacks to make
> 2016-10-20 08:58:33 UTC  DEBUG:  shmem_exit(1): 0 on_shmem_exit callbacks to make
> 2016-10-20 08:58:33 UTC  DEBUG:  proc_exit(1): 1 callbacks to make
> 2016-10-20 08:58:33 UTC  DEBUG:  exit(1)
>

In IPC-enabled/compiled versions you might want to set some kernel tunables related to IPC :
sysctl -a | grep -e 'sem|shm'
and adjust accordingly.
It seems that your installation uses mmap so you gotta handle this error first :
"mmap with MAP_HUGETLB failed, huge pages disabled: Cannot allocate memory"

See some Docker info how to resolve this.

>
> The entry point is
>
> su -c "/usr/lib/postgresql/9.4/bin/postgres -d 3 -D /var/lib/postgresql/9.4/main -c config_file=/etc/postgresql/9.4/main/postgresql.conf" postgres
>
> and the output of command
>
> 2016-10-20 08:56:58 UTC  DEBUG:  postgres: PostmasterMain: initial environment dump:
> 2016-10-20 08:56:58 UTC  DEBUG:  -----------------------------------------
> 2016-10-20 08:56:58 UTC  DEBUG: HOSTNAME=c0e6a383b652
> 2016-10-20 08:56:58 UTC  DEBUG: SHELL=/bin/bash
> 2016-10-20 08:56:58 UTC  DEBUG: TERM=xterm
> 2016-10-20 08:56:58 UTC  DEBUG: USER=postgres
> 2016-10-20 08:56:58 UTC  DEBUG: MAIL=/var/mail/postgres
> 2016-10-20 08:56:58 UTC  DEBUG: PATH=/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games
> 2016-10-20 08:56:58 UTC  DEBUG: _=/usr/lib/postgresql/9.4/bin/postgres
> 2016-10-20 08:56:58 UTC  DEBUG: PWD=/var/ansible
> 2016-10-20 08:56:58 UTC  DEBUG: LANG=en_US.UTF-8
> 2016-10-20 08:56:58 UTC  DEBUG: HOME=/var/lib/postgresql
> 2016-10-20 08:56:58 UTC  DEBUG: SHLVL=2
> 2016-10-20 08:56:58 UTC  DEBUG: LOGNAME=postgres
> 2016-10-20 08:56:58 UTC  DEBUG: PGLOCALEDIR=/usr/share/locale
> 2016-10-20 08:56:58 UTC  DEBUG: PGSYSCONFDIR=/etc/postgresql-common
> 2016-10-20 08:56:58 UTC  DEBUG: LC_COLLATE=en_US.UTF-8
> 2016-10-20 08:56:58 UTC  DEBUG: LC_CTYPE=en_US.UTF-8
> 2016-10-20 08:56:58 UTC  DEBUG: LC_MESSAGES=en_US.UTF-8
> 2016-10-20 08:56:58 UTC  DEBUG: LC_MONETARY=C
> 2016-10-20 08:56:58 UTC  DEBUG: LC_NUMERIC=C
> 2016-10-20 08:56:58 UTC  DEBUG: LC_TIME=C
> 2016-10-20 08:56:58 UTC  DEBUG:  -----------------------------------------
> 2016-10-20 08:56:58 UTC  DEBUG:  invoking IpcMemoryCreate(size=294363136)
> 2016-10-20 08:56:58 UTC  DEBUG:  mmap with MAP_HUGETLB failed, huge pages disabled: Cannot allocate memory
> 2016-10-20 08:56:58 UTC  DEBUG:  SlruScanDirectory invoking callback on pg_notify/0000
> 2016-10-20 08:56:58 UTC  DEBUG:  removing file "pg_notify/0000"
> 2016-10-20 08:56:58 UTC  DEBUG:  dynamic shared memory system will support 108 segments
> 2016-10-20 08:56:58 UTC  DEBUG:  created dynamic shared memory control segment 1804289383 (876 bytes)
> 2016-10-20 08:56:58 UTC  DEBUG:  max_safe_fds = 984, usable_fds = 1000, already_open = 6
> 2016-10-20 08:56:58 UTC  LOG:  redirecting log output to logging collector process
> 2016-10-20 08:56:58 UTC  HINT:  Future log output will appear in directory "/var/log/postgresql".
> 2016-10-20 09:00:41 UTC  DEBUG:  logger shutting down
> 2016-10-20 09:00:41 UTC  DEBUG:  shmem_exit(0): 0 before_shmem_exit callbacks to make
> 2016-10-20 09:00:41 UTC  DEBUG:  shmem_exit(0): 0 on_shmem_exit callbacks to make
> 2016-10-20 09:00:41 UTC  DEBUG:  proc_exit(0): 0 callbacks to make
> 2016-10-20 09:00:41 UTC  DEBUG:  exit(0)
> 2016-10-20 09:00:41 UTC  DEBUG:  shmem_exit(-1): 0 before_shmem_exit callbacks to make
> 2016-10-20 09:00:41 UTC  DEBUG:  shmem_exit(-1): 0 on_shmem_exit callbacks to make
> 2016-10-20 09:00:41 UTC  DEBUG:  proc_exit(-1): 0 callbacks to make
>
>
> My configuration parameters are
>
> data_directory = '/var/lib/postgresql/9.4/main'# use data in another directory
> hba_file = '/etc/postgresql/9.4/main/pg_hba.conf'# host-based authentication file
> ident_file = '/etc/postgresql/9.4/main/pg_ident.conf'# ident configuration file
> external_pid_file = '/var/run/postgresql/9.4-main.pid'# write an extra PID file
> listen_addresses = '0.0.0.0'
> port = 5432# (change requires restart)
> max_connections = 10
> unix_socket_directories = '/var/run/postgresql'# comma-separated list of directories
> ssl = true# (change requires restart)
> ssl_cert_file = '/etc/ssl/certs/ssl-cert-snakeoil.pem'# (change requires restart)
> ssl_key_file = '/etc/ssl/private/ssl-cert-snakeoil.key'# (change requires restart)
> shared_buffers = 256MB
> work_mem = 256MB
> maintenance_work_mem = 128MB
> dynamic_shared_memory_type = posix# the default is the first option
> wal_level = hot_standby
> wal_buffers = 16MB
> checkpoint_segments = 64
> checkpoint_completion_target = 0.7
> max_wal_senders = 6
> wal_keep_segments = 8
> effective_cache_size = 256MB
> default_statistics_target = 100
> logging_collector = on
> log_directory = '/var/log/postgresql'
> log_filename = 'postgresql-%Y-%m-%d.log'
> log_rotation_age = 1d
> log_min_duration_statement = 5000
> log_line_prefix = '%t  '
> log_timezone = 'localtime'
> stats_temp_directory = '/var/run/postgresql/9.4-main.pg_stat_tmp'
> log_autovacuum_min_duration = -1
> autovacuum_max_workers = 3
> autovacuum_naptime = 15min
> autovacuum_vacuum_threshold = 50
> autovacuum_analyze_threshold = 50
> autovacuum = on
> datestyle = 'iso, mdy'
> timezone = 'UTC'
> timezone = 'Europe/Athens'
> client_encoding = UTF8
> lc_messages = 'en_US.UTF-8'# locale for system error message
> lc_monetary = 'en_US.UTF-8'# locale for monetary formatting
> lc_numeric = 'en_US.UTF-8'# locale for number formatting
> lc_time = 'en_US.UTF-8'# locale for time formatting
> default_text_search_config = 'pg_catalog.english'
>
> Thanks,
>
> Dimitris


-- 
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Docker with data inside
  2016-10-20 09:04 Docker with data inside Κοκμάδης Δημήτριος <dkokmadis@gmail.com>
  2016-10-20 09:31 ` Re: Docker with data inside Achilleas Mantzios <achill@matrix.gatewaynet.com>
@ 2016-10-20 12:07   ` Κοκμάδης Δημήτριος <dkokmadis@gmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Κοκμάδης Δημήτριος @ 2016-10-20 12:07 UTC (permalink / raw)
  To: Achilleas Mantzios <achill@matrix.gatewaynet.com>; +Cc: pgsql-admin

Hello,



The problem is that I am not able to set kernel parameters inside docker as
it is running as readonly
sysctl: setting key "kernel.sem": Read-only file system

Thanks,
Dimitris




2016-10-20 12:31 GMT+03:00 Achilleas Mantzios <achill@matrix.gatewaynet.com>
:

> Καλημέρα Δημήτρη
>
> On 20/10/2016 12:04, Κοκμάδης Δημήτριος wrote:
>
> Hello,
>
> I am trying to create a docker Postgres container with database inside.
>
> When I try to run the container I have the following error
>
> 2016-10-20 08:58:33 UTC  FATAL:  the database system is starting up
> 2016-10-20 08:58:33 UTC  DEBUG:  shmem_exit(1): 0 before_shmem_exit
> callbacks to make
> 2016-10-20 08:58:33 UTC  DEBUG:  shmem_exit(1): 0 on_shmem_exit callbacks
> to make
> 2016-10-20 08:58:33 UTC  DEBUG:  proc_exit(1): 1 callbacks to make
> 2016-10-20 08:58:33 UTC  DEBUG:  exit(1)
>
>
> In IPC-enabled/compiled versions you might want to set some kernel
> tunables related to IPC :
> sysctl -a | grep -e 'sem|shm'
> and adjust accordingly.
> It seems that your installation uses mmap so you gotta handle this error
> first :
> "mmap with MAP_HUGETLB failed, huge pages disabled: Cannot allocate memory"
>
> See some Docker info how to resolve this.
>
>
>
> The entry point is
>
> su -c "/usr/lib/postgresql/9.4/bin/postgres -d 3 -D
> /var/lib/postgresql/9.4/main -c config_file=/etc/postgresql/9.4/main/postgresql.conf"
> postgres
>
> and the output of command
>
> 2016-10-20 08:56:58 UTC  DEBUG:  postgres: PostmasterMain: initial
> environment dump:
> 2016-10-20 08:56:58 UTC  DEBUG:  -----------------------------------------
> 2016-10-20 08:56:58 UTC  DEBUG:   HOSTNAME=c0e6a383b652
> 2016-10-20 08:56:58 UTC  DEBUG:   SHELL=/bin/bash
> 2016-10-20 08:56:58 UTC  DEBUG:   TERM=xterm
> 2016-10-20 08:56:58 UTC  DEBUG:   USER=postgres
> 2016-10-20 08:56:58 UTC  DEBUG:   MAIL=/var/mail/postgres
> 2016-10-20 08:56:58 UTC  DEBUG:   PATH=/usr/local/bin:/usr/bin:/
> bin:/usr/local/games:/usr/games
> 2016-10-20 08:56:58 UTC  DEBUG:   _=/usr/lib/postgresql/9.4/bin/postgres
> 2016-10-20 08:56:58 UTC  DEBUG:   PWD=/var/ansible
> 2016-10-20 08:56:58 UTC  DEBUG:   LANG=en_US.UTF-8
> 2016-10-20 08:56:58 UTC  DEBUG:   HOME=/var/lib/postgresql
> 2016-10-20 08:56:58 UTC  DEBUG:   SHLVL=2
> 2016-10-20 08:56:58 UTC  DEBUG:   LOGNAME=postgres
> 2016-10-20 08:56:58 UTC  DEBUG:   PGLOCALEDIR=/usr/share/locale
> 2016-10-20 08:56:58 UTC  DEBUG:   PGSYSCONFDIR=/etc/postgresql-common
> 2016-10-20 08:56:58 UTC  DEBUG:   LC_COLLATE=en_US.UTF-8
> 2016-10-20 08:56:58 UTC  DEBUG:   LC_CTYPE=en_US.UTF-8
> 2016-10-20 08:56:58 UTC  DEBUG:   LC_MESSAGES=en_US.UTF-8
> 2016-10-20 08:56:58 UTC  DEBUG:   LC_MONETARY=C
> 2016-10-20 08:56:58 UTC  DEBUG:   LC_NUMERIC=C
> 2016-10-20 08:56:58 UTC  DEBUG:   LC_TIME=C
> 2016-10-20 08:56:58 UTC  DEBUG:  -----------------------------------------
> 2016-10-20 08:56:58 UTC  DEBUG:  invoking IpcMemoryCreate(size=294363136)
> 2016-10-20 08:56:58 UTC  DEBUG:  mmap with MAP_HUGETLB failed, huge pages
> disabled: Cannot allocate memory
> 2016-10-20 08:56:58 UTC  DEBUG:  SlruScanDirectory invoking callback on
> pg_notify/0000
> 2016-10-20 08:56:58 UTC  DEBUG:  removing file "pg_notify/0000"
> 2016-10-20 08:56:58 UTC  DEBUG:  dynamic shared memory system will support
> 108 segments
> 2016-10-20 08:56:58 UTC  DEBUG:  created dynamic shared memory control
> segment 1804289383 (876 bytes)
> 2016-10-20 08:56:58 UTC  DEBUG:  max_safe_fds = 984, usable_fds = 1000,
> already_open = 6
> 2016-10-20 08:56:58 UTC  LOG:  redirecting log output to logging collector
> process
> 2016-10-20 08:56:58 UTC  HINT:  Future log output will appear in directory
> "/var/log/postgresql".
> 2016-10-20 09:00:41 UTC  DEBUG:  logger shutting down
> 2016-10-20 09:00:41 UTC  DEBUG:  shmem_exit(0): 0 before_shmem_exit
> callbacks to make
> 2016-10-20 09:00:41 UTC  DEBUG:  shmem_exit(0): 0 on_shmem_exit callbacks
> to make
> 2016-10-20 09:00:41 UTC  DEBUG:  proc_exit(0): 0 callbacks to make
> 2016-10-20 09:00:41 UTC  DEBUG:  exit(0)
> 2016-10-20 09:00:41 UTC  DEBUG:  shmem_exit(-1): 0 before_shmem_exit
> callbacks to make
> 2016-10-20 09:00:41 UTC  DEBUG:  shmem_exit(-1): 0 on_shmem_exit callbacks
> to make
> 2016-10-20 09:00:41 UTC  DEBUG:  proc_exit(-1): 0 callbacks to make
>
>
> My configuration parameters are
>
> data_directory = '/var/lib/postgresql/9.4/main' # use data in another
> directory
> hba_file = '/etc/postgresql/9.4/main/pg_hba.conf' # host-based
> authentication file
> ident_file = '/etc/postgresql/9.4/main/pg_ident.conf' # ident
> configuration file
> external_pid_file = '/var/run/postgresql/9.4-main.pid' # write an extra
> PID file
> listen_addresses = '0.0.0.0'
> port = 5432 # (change requires restart)
> max_connections = 10
> unix_socket_directories = '/var/run/postgresql' # comma-separated list of
> directories
> ssl = true # (change requires restart)
> ssl_cert_file = '/etc/ssl/certs/ssl-cert-snakeoil.pem' # (change requires
> restart)
> ssl_key_file = '/etc/ssl/private/ssl-cert-snakeoil.key' # (change
> requires restart)
> shared_buffers = 256MB
> work_mem = 256MB
> maintenance_work_mem = 128MB
> dynamic_shared_memory_type = posix # the default is the first option
> wal_level = hot_standby
> wal_buffers = 16MB
> checkpoint_segments = 64
> checkpoint_completion_target = 0.7
> max_wal_senders = 6
> wal_keep_segments = 8
> effective_cache_size = 256MB
> default_statistics_target = 100
> logging_collector = on
> log_directory = '/var/log/postgresql'
> log_filename = 'postgresql-%Y-%m-%d.log'
> log_rotation_age = 1d
> log_min_duration_statement = 5000
> log_line_prefix = '%t  '
> log_timezone = 'localtime'
> stats_temp_directory = '/var/run/postgresql/9.4-main.pg_stat_tmp'
> log_autovacuum_min_duration = -1
> autovacuum_max_workers = 3
> autovacuum_naptime = 15min
> autovacuum_vacuum_threshold = 50
> autovacuum_analyze_threshold = 50
> autovacuum = on
> datestyle = 'iso, mdy'
> timezone = 'UTC'
> timezone = 'Europe/Athens'
> client_encoding = UTF8
> lc_messages = 'en_US.UTF-8' # locale for system error message
> lc_monetary = 'en_US.UTF-8' # locale for monetary formatting
> lc_numeric = 'en_US.UTF-8' # locale for number formatting
> lc_time = 'en_US.UTF-8' # locale for time formatting
> default_text_search_config = 'pg_catalog.english'
>
> Thanks,
>
> Dimitris
>
>
>
> --
> Achilleas Mantzios
> IT DEV Lead
> IT DEPT
> Dynacom Tankers Mgmt
>
>

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2016-10-20 12:07 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-10-20 09:04 Docker with data inside Κοκμάδης Δημήτριος <dkokmadis@gmail.com>
2016-10-20 09:31 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2016-10-20 12:07   ` Κοκμάδης Δημήτριος <dkokmadis@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox