[postgres9.6@db ~]$ psql postgres postgres9.6
Null display is "NULL".
Pager is always used.
Timing is on.
psql (9.6.1)
Type "help" for help.
postgres9.6@[local]:5432 postgres# show wal_level;
wal_level
-----------
replica
(1 row)
Time: 0.270 ms
postgres9.6@[local]:5432 postgres# show archive_mode;
archive_mode
--------------
on
(1 row)
Time: 0.214 ms
postgres9.6@[local]:5432 postgres# show archive_command ;
archive_command
--------------------------------------------------------------------------------------------------------
DATE=`date +%Y%m%d`;DIR="/home/postgres9.6/arch/$DATE";(test -d $DIR || mkdir -p $DIR)&& cp %p $DIR/%f
(1 row)
Time: 0.188 ms
postgres9.6@[local]:5432 postgres# select version();
version
---------------------------------------------------------------------------------------------------------
PostgreSQL 9.6.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4), 64-bit
(1 row)
Time: 2.709 ms
postgres9.6@[local]:5432 p
Null display is "NULL".
Pager is always used.
Timing is on.
psql (9.6.1)
Type "help" for help.
postgres9.6@[local]:5432 postgres# show wal_level;
wal_level
-----------
replica
(1 row)
Time: 0.270 ms
postgres9.6@[local]:5432 postgres# show archive_mode;
archive_mode
--------------
on
(1 row)
Time: 0.214 ms
postgres9.6@[local]:5432 postgres# show archive_command ;
archive_command
--------------------------------------------------------------------------------------------------------
DATE=`date +%Y%m%d`;DIR="/home/postgres9.6/arch/$DATE";(test -d $DIR || mkdir -p $DIR)&& cp %p $DIR/%f
(1 row)
Time: 0.188 ms
postgres9.6@[local]:5432 postgres# select version();
version
---------------------------------------------------------------------------------------------------------
PostgreSQL 9.6.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4), 64-bit
(1 row)
Time: 2.709 ms
postgres9.6@[local]:5432 p