How To Build File Log Postgresql Before Haven't Log On Your PGDATA

dba@dba-rizky:~$ ssh root@x.x.x.x

root@x.x.x.x's password:

Last login: Thu Apr 19 16:54:32 2018 from dba

[root@prod-odgpostgres ~]#

[postgres@prod-odgpostgres ~]$pg_ctl10 -D /DATA/PG10/data/ stop

[postgres@prod-odgpostgres ~]$cd /DATA/PG10/data/

[postgres@prod-odgpostgres data]$vi postgresql.conf

log_line_prefix = '%t [%p] %a %u %d %r %e'

# %t = wktu tanpa milisecond

# %a = nama aplikasinya

# %p = PIDnya

# %d = nama databasenya

# %r = host dan portnya

# %e = sql statenya

Save ctrl+c → shift + ; → wq! → enter

[postgres@prod-odgpostgres data]$pg_ctl10 -D /DATA/PG10/data/ -l /DATA/PG10/data/pg10_logs start

[postgres@prod-odgpostgres data]$cd /DATA/PG10/data/

[postgres@ prod-odgpostgres data]$ ll

total 984

drwxrwxr-x 2 postgres postgres 856064 Apr 30 14:35 archive

drwx------ 6 postgres postgres 4096 Apr 23 15:46 base

drwx------ 2 postgres postgres 4096 Apr 30 14:36 global

-rw------- 1 postgres postgres 6317 Apr 30 14:49 pg10_logs

drwx------ 2 postgres postgres 4096 Apr 9 09:28 pg_commit_ts

drwx------ 2 postgres postgres 4096 Apr 9 09:28 pg_dynshmem

-rw------- 1 postgres postgres 4700 Apr 27 18:47 pg_hba.conf

-rw------- 1 postgres postgres 1636 Apr 9 09:28 pg_ident.conf

drwx------ 4 postgres postgres 4096 Apr 30 14:40 pg_logical

drwx------ 4 postgres postgres 4096 Apr 9 09:28 pg_multixact

drwx------ 2 postgres postgres 4096 Apr 30 14:35 pg_notify

drwx------ 2 postgres postgres 4096 Apr 9 11:02 pg_replslot

drwx------ 2 postgres postgres 4096 Apr 9 09:28 pg_serial

drwx------ 2 postgres postgres 4096 Apr 9 09:28 pg_snapshots

drwx------ 2 postgres postgres 4096 Apr 30 14:35 pg_stat

drwx------ 2 postgres postgres 4096 May 2 14:38 pg_stat_tmp

drwx------ 2 postgres postgres 4096 Apr 28 19:52 pg_subtrans

drwx------ 2 postgres postgres 4096 Apr 9 09:28 pg_tblspc

drwx------ 2 postgres postgres 4096 Apr 9 09:28 pg_twophase

-rw------- 1 postgres postgres 3 Apr 9 09:28 PG_VERSION

drwx------ 3 postgres postgres 20480 Apr 30 14:35 pg_wal

drwx------ 2 postgres postgres 4096 Apr 28 19:08 pg_xact

-rw------- 1 postgres postgres 506 Apr 9 10:08 postgresql.auto.conf

-rw------- 1 postgres postgres 22811 Apr 30 07:19 postgresql.conf

-rw------- 1 postgres postgres 53 Apr 30 14:35 postmaster.opts

-rw------- 1 postgres postgres 74 Apr 30 14:35 postmaster.pid