1、通过 https://download.docker.com/linux/fedora/28/x86_64/stable/Packages/ 下载自动安装docker最新版本的containerd.io、docker-ce-cli、docker-ce(注意顺序)如下图:
2、连接postgres数据库的服务端代码:
package main
import (
"database/sql"
"fmt"
"html/template"
"log"
"net/http"
_ "github.com/lib/pq"
)
type authUser struct {
UserLoginName string
UserName string
}
//IndexHandler 首页展示用户信息
func IndexHandler(w http.ResponseWriter, r *http.Request) {
if r.Method == "GET" {
dbUser := "postgres"
dbPass := "mypassword"
dbHost := "localhost"
dbPort := "5432"
dbName := "<database_name>"
connStr := fmt.Sprintf("host=%s port=%s user=%s password=%s dbname=%s sslmode=disable", dbHost, dbPort, dbUser, dbPass, dbName)
db, err := sql.Open("postgres", connStr)
if err != nil {
log.Fatal(err)
}
rows, err := db.Query("SELECT USER_LOGIN_NAME,USER_NAME FROM public.AUTH_USER")
if err != nil {
log.Println(err)
}
var authUsers []authUser
for rows.Next() {
var au authUser
rows.Scan(&au.UserLoginName, &au.UserName)
authUsers = append(authUsers, au)
}
t, err := template.ParseFiles("templates/index.html")
if err != nil {
log.Println(err)
}
err = t.Execute(w, authUsers)
if err != nil {
log.Println(err)
}
}
}
func main() {
http.HandleFunc("/", IndexHandler)
fmt.Println("服务端口:8000") //控制台输出信息
err := http.ListenAndServe(":8000", nil) //设置监听的端口
if err != nil {
log.Fatal("ListenAndServe: ", err)
}
}
3、go语言渲染前端模板代码
<div>
{{.}}
</div>
4、把应用放入docker中
1)下载pg的alpine镜像:
sudo docker pull postgres:alpine
2)docker-compose.yml内容
services:
db:
restart: always
image: postgres:alpine
volumes:
- /home/fedora/data:/var/lib/postgresql/data
ports:
- target: 5432
published: 5432
webserver:
image: "webserver"
volumes:
- /home/fedora/datafile:/app/datadir
ports:
- target: 8000
published: 8080
depends_on:
- db
links:
- db:database
3) pg数据库从本地库导出:
在fedora的docker中里执行pg命令行
sudo docker exec -it fedora_db_1 psql -U postgres -d <database_name>
create database <database_name>; #创建数据库
connect <database_name>#连接数据库
pg导出及导入命令:
pg_dump -U postgres 数据库名称>数据库.sql
cat 数据库.sql | sudo docker exec -i fedora_db_1 psql -U postgres -d <database_name>
4)生成docker应用程序
sudo docker build -t webserver -f Dockerfile .
5)启动docker应用
sudo docker-compose up
5、docker镜像导入导出
- 启动docker
systemctl start docker
- 查看镜像
sudo docker images
- 导出webserver和postgres数据库镜像
sudo docker save -o webserver_img.tar webserver
sudo docker save -o postgres_img.tar postgres
4)加载镜像
docker load -i webserver_img.tar
docker load -i postgres_img.tar