# postgresql_docker

**Repository Path**: moxuanzu/postgresql_docker

## Basic Information

- **Project Name**: postgresql_docker
- **Description**: No description available
- **Primary Language**: Docker
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 1
- **Created**: 2019-08-28
- **Last Updated**: 2023-08-16

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# postgresql_docker

#### 介绍
镜像包含postgresql、postgis、全文分词

#### 安装docker


#### 安装docker-compose  


```
curl -L https://get.daocloud.io/docker/compose/releases/download/1.22.0/docker-compose-`uname -s`-`uname -m` > /usr/local/bin/docker-compose
chmod +x /usr/local/bin/docker-compose
```

#### 修改了官方的dockerfinle
```
&& sed -i 's/dl-cdn.alpinelinux.org/mirrors.ustc.edu.cn/g' /etc/apk/repositories \
	&& apk add --update-cache bash \
	&& apk add wget \
```
前两句是设置了alpinelinux的镜像，使其下载更快；
第三句是更新了wget
主要为了解决 docker wget: error getting response: Connection reset by peer 问题


如果使用分词，可以在postgresql.conf增加
```
zhparser.multi_short = true #短词复合: 1
zhparser.multi_duality = true  #散字二元复合: 2
zhparser.multi_zmain = true  #重要单字复合: 4
zhparser.multi_zall = false  #全部单字复合: 8
```

为了使用密码需要修改pg_hba.conf,将trust修改为md5
```
# "local" is for Unix domain socket connections only
local   all             all                                     md5
# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
host    all             all             0.0.0.0/0               md5
# IPv6 local connections:
host    all             all             ::1/128                 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local   replication     postgres                                trust
#host    replication     postgres        127.0.0.1/32            trust
#host    replication     postgres        ::1/128                 trust
```

![以使用padmin修改密码](https://images.gitee.com/uploads/images/2020/0110/113243_bc4cda29_901903.png "屏幕截图.png")