pg_docker_deploy.md

#posgresql

#posgresql

docker  run   --name postgres -e POSTGRES_PASSWORD=mysecretpassword -e POSTGRES_USER=test -p 5432:5432 \
-e PGDATA=/var/lib/postgresql/data/pgdata \
-e POSTGRES_DB=foo \
-v /home/code/Desktop/postgres/data:/var/lib/postgresql/data/pgdata postgres


#进入continer 创建用户
docker exec -it pg 

`  sudo -i -u postgres `或者  ` su postgres ` 切换倒psql
`psql -h localhost -d foo -U test -p 5432 ` 进入psql 控制台

创建用户
createuser --interactive

#修改密码

alter user hello with password '123456';

GRANT ALL PRIVILEGES ON DATABASE hello TO hello;

test

func main() {
	data := []byte("123456")
	fmt.Printf("%x", md5.Sum(data))
	var dsn = `user=test password=mysecretpassword host=127.0.0.1 port=5432 dbname=foo`
	_, err := gorm.Open(postgres.Open(dsn), &gorm.Config{})

	if err != nil {
		panic(err)
	}
}