【AntDB-T Installation and Deployment Documentation】Generated Files List Description and Parameter Setting Instructions
Generated files list description
The list of files generated after AntDB installation is completed is as follows:
File name | Permission | Function |
base | drwx------ | Subdirectories of each database for the subdirectory |
global | drwx------ | A subdirectory containing cluster-wide tables, such as pg_database |
logfile | -rw------- | Startup Log |
pg_commit_ts | drwx------ | Subdirectory containing transaction commit timestamp data |
pg_dynshmem | drwx------ | Subdirectory containing files used by the dynamic shared memory subsystem |
pg_hba.conf | -rw------- | Client authentication control filecontrol file |
pg_ident.conf | -rw------- | Used to configure which operating system users can be mapped as database users |
pg_log | drwx------ | pg run log |
pg_logical | drwx------ | Subdirectory containing state data for logical replication |
pg_multixact | drwx------ | Subdirectory containing multi-transaction state data (user shared row locks) |
pg_notify | drwx------ | Subdirectories containing replication slot data |
pg_replslot | drwx------ | Subdirectory containing LISTEN/NOTIFY status data |
pg_rxlog | drwx------ | Subdirectory containing transaction commit status data |
pg_serial | drwx------ | A subdirectory containing information about committed serializable transactions |
pg_snapshots | drwx------ | Subdirectories containing snapshots of everywhere |
pg_stat | drwx------ | Subdirectory containing permanent files for the statistics subsystem |
pg_stat_tmp | drwx------ | Subdirectory containing temporary files for the statistical information subsystem |
pg_subtrans | drwx------ | Subdirectories containing subtransaction status data |
pg_tblspc | drwx------ | Subdirectory containing symbolic links to tablespaces |
Parameter Setting Instructions
Parameter configuration for the AntDB database cluster can be done through adbmgr.
1. First connect to adbmgr using psql.
psql -d postgres -p [the port number of adbmgr]
For example:
psql -d postgres -p 31000
2. Command to set parameters; Set all nodes of the same type at the same time.
set datanode|coordinator|gtm all(key1=value1, key2=value2...);
Set the parameters of a particular node:
set{datanode|coordinator|gtm} {master|slave|extra} {nodename|all} (key1=value1, key2=value2...);
For example:
set datanode all (max_connections=800,shared_buffers='5GB', max_prepared_transactions=800,lock_timeout='60s',max_pool_size=800, wal_log_hints='on', full_page_writes='on', fsync='off',rep_max_avail_flag = 'on' );
set coordinator all (max_connections=400,shared_buffers='2GB',max_prepared_transactions=400,lock_timeout='60s',fsync='off',rep_max_avail_flag = 'on');
set gtmcoord all (max_connections=400,shared_buffers='2GB',max_prepared_transactions=400,lock_timeout='60s',fsync='off',rep_max_avail_flag = 'on');
3. Reboot. A prompt to reboot for certain parameters to take effect after they have been set.
stop all;
start all;
4. View parameter settings.
show param node name parameter name
For example:
postgres=# show param dm1 max_conn;
type | status | message
--------------------------+--------+------------------------
datanode master dm1 | t | max_connections = 2000
datanode slave ds1_local | t | max_connections = 2000
English
Database
Tools
Industries
Scenarios
