`
[lightdb@hs-10-20-30-199 ~]$ lt_initdb -p9876 -D lightdb22.1-data
The files belonging to this database system will be owned by user “lightdb”.
This user must also own the server process.
The database cluster will be initialized with locale “C”.
The default database encoding has accordingly been set to “SQL_ASCII”.
initdb: warning: specified text search configuration “simple” might not match locale “C”
The default text search configuration will be set to “simple”.
Data page checksums are disabled.
Data encryption is disabled.
creating directory lightdb22.1-data … ok
creating subdirectories … ok
selecting dynamic shared memory implementation … posix
selecting default max_connections … 100
selecting default shared_buffers … 128MB
selecting default time zone … Asia/Shanghai
creating configuration files … ok
running bootstrap script … 2022-05-26 14:56:17.842069T @ not initialized 00000[2022-05-26 14:56:17 CST] 0 [259431] LOG: checkpoint starting: shutdown immediate
2022-05-26 14:56:17.843277T @ not initialized 00000[2022-05-26 14:56:17 CST] 0 [259431] LOG: checkpoint complete: wrote 211 buffers (1.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.001 s, total=0.002 s; sync files=0, longest=0.000 s, average=0.000 s; distance=725 kB, estimate=725 kB
ok
performing post-bootstrap initialization … 2022-05-26 14:56:18.173448T @ not initialized 00000[2022-05-26 14:56:17 CST] 480 [259445] LOG: checkpoint starting: immediate force wait flush-all
2022-05-26 14:56:18.173448T @ not initialized 00000[2022-05-26 14:56:17 CST] 480 [259445] STATEMENT: CREATE DATABASE template0 IS_TEMPLATE = true ALLOW_CONNECTIONS = false;
2022-05-26 14:56:18.178813T @ not initialized 00000[2022-05-26 14:56:17 CST] 480 [259445] LOG: checkpoint complete: wrote 845 buffers (5.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.005 s, sync=0.001 s, total=0.006 s; sync files=0, longest=0.000 s, average=0.000 s; distance=7606 kB, estimate=7606 kB
2022-05-26 14:56:18.178813T @ not initialized 00000[2022-05-26 14:56:17 CST] 480 [259445] STATEMENT: CREATE DATABASE template0 IS_TEMPLATE = true ALLOW_CONNECTIONS = false;
2022-05-26 14:56:18.190468T @ not initialized 00000[2022-05-26 14:56:17 CST] 480 [259445] LOG: checkpoint starting: immediate force wait
2022-05-26 14:56:18.190468T @ not initialized 00000[2022-05-26 14:56:17 CST] 480 [259445] STATEMENT: CREATE DATABASE template0 IS_TEMPLATE = true ALLOW_CONNECTIONS = false;
2022-05-26 14:56:18.191312T @ not initialized 00000[2022-05-26 14:56:17 CST] 480 [259445] LOG: checkpoint complete: wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.000 s, total=0.001 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=6845 kB
2022-05-26 14:56:18.191312T @ not initialized 00000[2022-05-26 14:56:17 CST] 480 [259445] STATEMENT: CREATE DATABASE template0 IS_TEMPLATE = true ALLOW_CONNECTIONS = false;
2022-05-26 14:56:18.191902T @ not initialized 00000[2022-05-26 14:56:17 CST] 485 [259445] LOG: checkpoint starting: immediate force wait flush-all
2022-05-26 14:56:18.191902T @ not initialized 00000[2022-05-26 14:56:17 CST] 485 [259445] STATEMENT: CREATE DATABASE postgres;
2022-05-26 14:56:18.192810T @ not initialized 00000[2022-05-26 14:56:17 CST] 485 [259445] LOG: checkpoint complete: wrote 11 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.001 s; sync files=0, longest=0.000 s, average=0.000 s; distance=42 kB, estimate=6165 kB
2022-05-26 14:56:18.192810T @ not initialized 00000[2022-05-26 14:56:17 CST] 485 [259445] STATEMENT: CREATE DATABASE postgres;
2022-05-26 14:56:18.202844T @ not initialized 00000[2022-05-26 14:56:17 CST] 485 [259445] LOG: checkpoint starting: immediate force wait
2022-05-26 14:56:18.202844T @ not initialized 00000[2022-05-26 14:56:17 CST] 485 [259445] STATEMENT: CREATE DATABASE postgres;
2022-05-26 14:56:18.203554T @ not initialized 00000[2022-05-26 14:56:17 CST] 485 [259445] LOG: checkpoint complete: wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.000 s, total=0.001 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=5549 kB
2022-05-26 14:56:18.203554T @ not initialized 00000[2022-05-26 14:56:17 CST] 485 [259445] STATEMENT: CREATE DATABASE postgres;
2022-05-26 14:56:18.203657T @ not initialized 00000[2022-05-26 14:56:17 CST] 0 [259445] LOG: checkpoint starting: shutdown immediate
2022-05-26 14:56:18.203954T @ not initialized 00000[2022-05-26 14:56:17 CST] 0 [259445] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.000 s, total=0.001 s; sync files=0, longest=0.000 s, average=0.000 s; distance=1 kB, estimate=4994 kB
ok
syncing data to disk … ok
initdb: warning: enabling “trust” authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
–auth-local and –auth-host, the next time you run initdb.
Success. You can now start the database server using:
/home/lightdb/base0524/lightdb-x/13.3-22.1/bin/lt_ctl -D lightdb22.1-data -l logfile start
Notice: It is recommended to use lt_initdb, otherwise some functions are unavailable.
If you are run initdb directly, you can using like:
$PGHOME/scripts/5_lightdb_modify_para.sh $PGHOME $PGDATA OLTP/OLAP shared_buffers(MB) effective_cache_size(MB) $PGPORT
$PGHOME/scripts/6_lightdb_start.sh $PGHOME $PGDATA (if not started)
$PGHOME/scripts/8_lightdb_create_extension.sh $PGHOME $PGPORT
for optimised performance.
INFO modify effective_cache_size successfully
INFO modify wal_buffers successfully
INFO modify max_wal_size successfully
INFO modify min_wal_size successfully
INFO modify random_page_cost successfully
INFO modify max_parallel_maintenance_workers successfully
INFO modify default_statistics_target successfully
INFO modify min_parallel_index_scan_size successfully
INFO modify transform_null_equals successfully
INFO modify max_worker_processes successfully
INFO modify max_parallel_workers successfully
INFO modify logging_collector successfully
INFO modify enable_partitionwise_aggregate successfully
INFO modify shared_buffers successfully
INFO modify pg_stat_statements.track_planning successfully
INFO modify bgwriter_lru_maxpages successfully
INFO modify max_slot_wal_keep_size successfully
INFO modify parallel_setup_cost successfully
INFO modify shared_preload_libraries successfully
INFO modify track_io_timing successfully
INFO modify log_min_messages successfully
INFO modify temp_buffers successfully
INFO modify commit_siblings successfully
INFO modify canopy.shard_count successfully
INFO modify cron.database_name successfully
INFO modify min_parallel_table_scan_size successfully
CREATE SCHEMA
GRANT
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE TEXT SEARCH CONFIGURATION
ALTER TEXT SEARCH CONFIGURATION
ALTER TEXT SEARCH DICTIONARY
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE SCHEMA
GRANT
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE TEXT SEARCH CONFIGURATION
ALTER TEXT SEARCH CONFIGURATION
ALTER TEXT SEARCH DICTIONARY
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
CREATE EXTENSION
schedule
2
(1 row)
schedule
4
(1 row)
schedule
Original: https://www.cnblogs.com/zhjh256/p/16313523.html
Author: zhjh256
Title: lightdb实例初始化
原创文章受到原创版权保护。转载请注明出处：https://www.johngo689.com/554504/
转载文章受原作者版权保护。转载请注明原作者出处！