lightdb启动与停止
[zjh@hs-10-20-30-193 ~]$ lt_ctl -D lightdb-x-dev-server/data stop #停止 waiting for server to shut down............................... done server stopped [zjh@hs-10-20-30-193 ~]$ lt_ctl -D lightdb-x-dev-server/data start # 启动 waiting for server to start....2022-05-26 06:43:53.407933C @ postmaster 00000[2022-05-26 06:43:53 UTC] 0 [167878] LOG: LightDB autoprewarm: prewarm dbnum=0 2022-05-26 06:43:53.408078C @ postmaster 00000[2022-05-26 06:43:53 UTC] 0 [167878] LOG: Auto detecting pg_stat_kcache.linux_hz parameter... 2022-05-26 06:43:53.408093C @ postmaster 00000[2022-05-26 06:43:53 UTC] 0 [167878] LOG: pg_stat_kcache.linux_hz is set to 1000000 2022-05-26 06:43:53.410947C @ postmaster 00000[2022-05-26 06:43:53 UTC] 0 [167878] LOG: pgaudit extension initialized 2022-05-26 06:43:53.617145C @ postmaster 00000[2022-05-26 06:43:53 UTC] 0 [167878] LOG: redirecting log output to logging collector process 2022-05-26 06:43:53.617145C @ postmaster 00000[2022-05-26 06:43:53 UTC] 0 [167878] HINT: Future log output will appear in directory "log". done server started [zjh@hs-10-20-30-193 ~]$ lt_ctl --help lt_ctl is a utility to initialize, start, stop, or control a LightDB server. Usage: lt_ctl init[db] [-D DATADIR] [-s] [-o OPTIONS] lt_ctl start [-D DATADIR] [-l FILENAME] [-W] [-t SECS] [-K KEY-CMD] [-s] [-o OPTIONS] [-p PATH] [-c] lt_ctl stop [-D DATADIR] [-m SHUTDOWN-MODE] [-W] [-t SECS] [-s] lt_ctl restart [-D DATADIR] [-m SHUTDOWN-MODE] [-W] [-t SECS] [-K KEY-CMD] [-s] [-o OPTIONS] [-c] lt_ctl reload [-D DATADIR] [-s] lt_ctl status [-D DATADIR] lt_ctl promote [-D DATADIR] [-W] [-t SECS] [-s] lt_ctl logrotate [-D DATADIR] [-s] lt_ctl kill SIGNALNAME PID Common options: -D, --pgdata=DATADIR location of the database storage area -K, --encryption-key-command command that returns encryption key -s, --silent only print errors, no informational messages -t, --timeout=SECS seconds to wait when using -w option -V, --version output version information, then exit -w, --wait wait until operation completes (default) -W, --no-wait do not wait until operation completes -Y, --SM key file external import SM2/SM4 key file path -?, --help show this help, then exit If the -D option is omitted, the environment variable PGDATA is used. Options for start or restart: -c, --core-files allow lightdb to produce core files -l, --log=FILENAME write (or append) server log to FILENAME -o, --options=OPTIONS command line options to pass to postgres (PostgreSQL server executable) or initdb -p PATH-TO-POSTGRESQL normally not necessary Options for stop or restart: -m, --mode=MODE MODE can be "smart", "fast", or "immediate" Shutdown modes are: smart quit after all clients have disconnected fast quit directly, with proper shutdown (default) immediate quit without complete shutdown; will lead to recovery on restart Allowed signal names for kill: ABRT HUP INT KILL QUIT TERM USR1 USR2 Report bugs to <https://github.com/hslightdb>. LightDB home page: <https://www.hs.net/lightdb> [zjh@hs-10-20-30-193 ~]$ ltsql -Ulightdb ltsql (13.3-22.1) Type "help" for help. lightdb@postgres=# select current_user; current_user -------------- lightdb (1 row) lightdb@postgres=# show %data%; name | setting | description ---------------------+-------------------------+----------------------------------------------------------------- cron.database_name | postgres | Database in which pg_cron metadata is kept. data_checksums | off | Shows whether data checksums are turned on for this cluster. data_directory | /mnt/pmem0/data/data524 | Sets the server's data directory. data_directory_mode | 0700 | Mode of the data directory. data_encryption | off | Shows whether data encryption is turned on for this cluster. data_sync_retry | off | Whether to continue running after a failure to sync data files. (6 rows)
initdb选项会让lightdb启动程序进入bootstrap模式创建lightdb实例。
不重启修改参数
lightdb@postgres=# alter system set data_sync_retry=on; ALTER SYSTEM lightdb@postgres=# exit [zjh@hs-10-20-30-193 ~]$ lt_ctl -D lightdb-x-dev-server/data reload server signaled [zjh@hs-10-20-30-193 ~]$
