yum install https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-centos10-10-2.noarch.rpm

yum install postgresql10

yum install postgresql10-server

yum install -y postgresql10-contrib

wget https://www.zombodb.com/releases/v10-1.0.3/zombodb_centos7_pg10-10-1.0.3_1.x86_64.rpm

rpm -Uvh zombodb_centos7_pg10-10-1.0.3_1.x86_64.rpm

host all all 0.0.0.0/0 trust

listen_addresses = '0.0.0.0'

port = 5432

/usr/pgsql-10/bin/postgresql-10-setup initdb

systemctl enable postgresql-10

systemctl start postgresql-10

yum install -y yum-utils

yum-config-manager --add-repo http://mirrors.aliyun.com/docker-ce/linux/centos/docker-ce.repo

yum install -y docker-ce

加速

sudo mkdir -p /etc/docker

sudo tee /etc/docker/daemon.json <<-'EOF'

{

  "registry-mirrors": ["https://b3uey254.mirror.aliyuncs.com"]

}

EOF

sudo systemctl daemon-reload

sudo systemctl restart docker

version: '2'

services:

  elasticsearch:

    image: elasticsearch:6.6.0

    ports:

    - "9200:9200"

    environment:

      - http.host=0.0.0.0

      - transport.host=0.0.0.0

      - network.host=0.0.0.0

      - "ES_JAVA_OPTS=-Xms512m -Xmx512m"

    ulimits:

      memlock:

        soft: -1

        hard: -1

    mem_limit: 1g

可能需要配置系统vm 参数

echo vm.max_map_count=655360 >> /etc/sysctl.conf && \

sysctl -p

docker-compose up -d

CREATE EXTENSION zombodb;

CREATE TABLE products (

    id SERIAL8 NOT NULL PRIMARY KEY,

    name text NOT NULL,

    keywords varchar(64)[],

    short_summary text,

    long_description zdb.fulltext,

    price bigint,

    inventory_count integer,

    discontinued boolean default false,

    availability_date date

);

COPY products FROM PROGRAM 'curl https://raw.githubusercontent.com/zombodb/zombodb/master/TUTORIAL-data.dmp';

CREATE INDEX idxproducts

                     ON products

                  USING zombodb ((products.*))

                   WITH (url='http://localhost:9200/');

SELECT * FROM products WHERE products ==> 'sports box';