那么问题来了,如何快速体验到“泼辣”DB 呢?
三步走。
# 拉取 PolarDB 镜像
docker pull polardb/polardb_pg_local_instance
# 创建并运行容器
podman run -d --name polardb polardb/polardb_pg_local_instance
# 连接容器
podman exec -it polardb psql
接下来,查看一些基础信息。
[root@rocky9 ~]# podman exec -it polardb psql
psql (11.9)
Type "help" for help.
postgres=# SELECT version();
version
--------------------------------
PostgreSQL 11.9 (POLARDB 11.9)
(1 row)
postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
---------------+----------+-----------+---------+-------+-----------------------
polardb_admin | postgres | SQL_ASCII | C | C | =T/postgres +
| | | | | postgres=CTc/postgres
postgres | postgres | SQL_ASCII | C | C |
template0 | postgres | SQL_ASCII | C | C | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | SQL_ASCII | C | C | =c/postgres +
| | | | | postgres=CTc/postgres
(4 rows)
postgres=# select count(name) from pg_settings where name like 'polar%';
count
-------
272
(1 row)
postgres=# select setting from pg_settings where name = 'polar_supported_extensions';
setting
------------------------------
pg_stat_statements +
btree_gin +
btree_gist +
citext +
cube +
dict_int +
earthdistance +
hstore +
intagg +
intarray +
isn +
ltree +
pgcrypto +
pgrowlocks +
pg_prewarm +
pg_trgm +
sslinfo +
tablefunc +
unaccent +
fuzzystrmatch +
pgstattuple +
pg_buffercache +
"uuid-ossp" +
bloom +
smlar +
vector +
plpgsql +
plperl +
postgis +
postgis_raster +
postgis_topology +
postgis_sfcgal +
fuzzystrmatch +
address_standardizer +
address_standardizer_data_us+
postgis_tiger_geocoder +
polar_csn +
polar_monitor +
polar_monitor_preload +
polar_px
(1 row)
这里看到了眼熟的 vector 插件,以及几个 polar 前缀的自定义插件。