Skip to content

PostgreSQL

Configuration

Configuration files for PostgreSQL® are available on the current Primary worker.

In the following table:

  • ${onteon_node_manager_path} - absolute path to Onteon Node Manager (by default /usr/local/bin/onteon-node-manager),
  • ${applicationId} - is the newest application id of the postgresql-microservice,
  • ${applicationInstanceId} - is the newest application instance id of the postgresql-microservice
Key Value
Microservice Files ${onteon_node_manager_path}/app/postgresql-microservice/1.0.0/${applicationId}/runtime/${applicationInstanceId}
Binary Files ${onteon_node_manager_path}/store/drbd/onteon-ha-resource-0/postgresql/application/lib/bin
Data Directory ${onteon_node_manager_path}/store/drbd/onteon-ha-resource-0/postgresql/data
Config File ${onteon_node_manager_path}/store/drbd/onteon-ha-resource-0/postgresql/data/postgresql.conf
Logs Directory ${onteon_node_manager_path}/log/app/postgresql-microservice/1.0.0/${applicationId}/${applicationInstanceId}/postgresql.log
PID File ${onteon_node_manager_path}/log/app/postgresql-microservice/1.0.0/${applicationId}/${applicationInstanceId}/postgresql.pid
Extensions Directory ${onteon_node_manager_path}/app/postgresql-microservice/1.0.0/${applicationId}/runtime/${applicationInstanceId}/bin/lib/lib/x86_64-linux-gnu/postgresql
Listen Address Address of the Primary worker
Port 5432
Default User Username postgres
Default User Password postgres

Extensions

PosgreSQL extensions are located in the ${onteon_node_manager_path}/app/postgresql-microservice/1.0.0/${applicationId}/runtime/${applicationInstanceId}//bin/lib/lib/x86_64-linux-gnu/postgresql directory (see Configuration table).

Files

.
├── _int.so
├── amcheck.so
├── auth_delay.so
├── auto_explain.so
├── autoinc.so
├── basebackup_to_shell.so
├── basic_archive.so
├── bloom.so
├── btree_gin.so
├── btree_gist.so
├── citext.so
├── cube.so
├── cyrillic_and_mic.so
├── dblink.so
├── dict_int.so
├── dict_snowball.so
├── dict_xsyn.so
├── earthdistance.so
├── euc2004_sjis2004.so
├── euc_cn_and_mic.so
├── euc_jp_and_sjis.so
├── euc_kr_and_mic.so
├── euc_tw_and_big5.so
├── file_fdw.so
├── fuzzystrmatch.so
├── hstore.so
├── insert_username.so
├── isn.so
├── latin2_and_win1250.so
├── latin_and_mic.so
├── libpqwalreceiver.so
├── lo.so
├── ltree.so
├── moddatetime.so
├── pageinspect.so
├── passwordcheck.so
├── pg_buffercache.so
├── pg_freespacemap.so
├── pg_prewarm.so
├── pg_stat_statements.so
├── pg_surgery.so
├── pg_trgm.so
├── pg_visibility.so
├── pg_walinspect.so
├── pgcrypto.so
├── pgoutput.so
├── pgrowlocks.so
├── pgstattuple.so
├── pgxs
├── plpgsql.so
├── postgres_fdw.so
├── refint.so
├── seg.so
├── sslinfo.so
├── tablefunc.so
├── tcn.so
├── test_decoding.so
├── tsm_system_rows.so
├── tsm_system_time.so
├── unaccent.so
├── utf8_and_big5.so
├── utf8_and_cyrillic.so
├── utf8_and_euc2004.so
├── utf8_and_euc_cn.so
├── utf8_and_euc_jp.so
├── utf8_and_euc_kr.so
├── utf8_and_euc_tw.so
├── utf8_and_gb18030.so
├── utf8_and_gbk.so
├── utf8_and_iso8859.so
├── utf8_and_iso8859_1.so
├── utf8_and_johab.so
├── utf8_and_sjis.so
├── utf8_and_sjis2004.so
├── utf8_and_uhc.so
├── utf8_and_win.so
└── vector.so

PG Vector

The following SQL operations can be executed using psql.

For more details on pgvector, visit the official project's website.

Enable Extension

Enable the pgvector extension in the databaase:

CREATE EXTENSION vector;

Binary Files

Binary files are located in the ${onteon_node_manager_path}/store/drbd/onteon-ha-resource-0/postgresql/application/lib/bin directory (see Configuration table).

To run any binary files, execute the following command:

./${binary_file_name}

Files

.
├── clusterdb
├── createdb
├── createuser
├── dropdb
├── dropuser
├── ecpg
├── initdb
├── oid2name
├── pg_amcheck
├── pg_archivecleanup
├── pg_basebackup
├── pgbench
├── pg_checksums
├── pg_combinebackup
├── pg_config
├── pg_controldata
├── pg_createsubscriber
├── pg_ctl
├── pg_dump
├── pg_dumpall
├── pg_isready
├── pg_receivewal
├── pg_recvlogical
├── pg_resetwal
├── pg_restore
├── pg_rewind
├── pg_test_fsync
├── pg_test_timing
├── pg_upgrade
├── pg_verifybackup
├── pg_waldump
├── pg_walsummary
├── postgres
├── psql
├── reindexdb
├── vacuumdb
└── vacuumlo

psql

To connect to the psql execute the following command in the binary files directory:

./psql -U postgres -h ${primary_worker_ip} -p 5432