# __ .______ __ __ .______ .___________. ______ ______ .___ ___. # | | | _ \ | | | | | _ \ | | / | / __ \ | \/ | # | | | |_) | | |__| | | |_) | `---| |----` | ,----'| | | | | \ / | # | | | ___/ | __ | | ___/ | | | | | | | | | |\/| | # | | | | | | | | | | | | __ | `----.| `--' | | | | | # |__| | _| |__| |__| | _| |__| (__) \______| \______/ |__| |__| # ""$o o$"" ""$o o$" o "$""""o "o $" o""" $" "$o "$o" $o " $ o$" "$o $$$o$$$$o$$$$ $" "oooo o "" ""$$$$$$$$""o"" oo oooo" "$$$$$$oo"oo$$$o" o$$$$oo" o$$$o "o$$$$$$$ "$ $$$$$$$$$oo o$$$$$$$$$o"$" $ $$$ $$$$$$ o$$$$$$ "$$o"o $ $$$$o $$$$$$ $$$$$$$ $$$$o"o $ $$$$$ $$$$$" "$$$$$ $$$$$$ $ $o""""" """" """ """"""$" $ o$$$$$"""$$$$$"$$$$$""$$$$$ooo"o $ o"$o $$$$$$$$oo$$$$$$$$o $$"" $ oo$ "$$$$$$$$$$$$$$$$$$$$" o" o $oo o$$$"$ $$o"o $$$$$$$"" "$$$$$$$ o$$ $$$$o IPHPT BUG o$$$$" $ $$$$ o "$$$$$oo o$$$$$$ "o$$$$ $ $$$$$ o$$"" $ $$$$$o" "$$$$$$$$$$$$$ o o$$$$$o$ "" $$ $$" $ $$$" o"o$$$$$$$$$$$$ " "$$$ $ $$o o$$ "o $$ " $$$$$$$$$$$"o "$$ $ $$$ $$$ oo$ $ o""$$""$$$o " $"o$o $$$o o$$$$ o$$$"o"$oo$$$$o" o $o $$$$$oo$ $$$$o $$$$ $$$$ $$$$" $ $$$$$"" $$ o$$$ """$$$$"o" "$$$o "$$$o $$$" o """ $ $$$oo $$$$o" $$ o$$$"o" """"$ o$$$ o$" $$$ $ "$"" o$"o"$$o$$$$ "$$"o" o$$ "$oo $ " $$o $ "oo$"o$$$"o$o"$$$$o" o" $$$ ""$o $$ $$$o "o$$o$"$$"$$o$$o$$"$$o" $$$ ""o $$$ ""$$$ $$$$$$ $$$$ $" $$$$ $$ $$$$ $$$$"$$$o$ $"" $$$ $$$$ "$$$ """ $$$$ $$"" "$$ oo$" $ooo $ "$$ beego postgresql数据迁移报错   -  叶落山城秋

beego postgresql数据迁移报错

2018/01/05 17:19:27 INFO     ▶ 0001 Using 'postgres' as 'driver'
2018/01/05 17:19:27 INFO     ▶ 0002 Using 'postgres:@tcp(127.0.0.1:5432)/postgres' as 'conn'
2018/01/05 17:19:27 INFO     ▶ 0003 Running all outstanding migrations
2018/01/05 17:19:27 FATAL    ▶ 0004 Could not show migrations table: missing "=" after "postgres:@tcp(127.0.0.1:5432)/postgres" in connection info string"

因为他喵的不会!

所以执行了这句:

bee migrate -driver=postgres -conn=“postgres:@tcp(127.0.0.1:5432)/postgres”

然而这句是根据 beego默认的mysql的语法

然后看文档,找到了这句!

bee migrate -driver=postgres -conn=“postgres://postgres:postgres@127.0.0.1:5432/postgres”

然后还他喵的报错!

2018/01/05 17:21:29 INFO     ▶ 0001 Using 'postgres' as 'driver'
2018/01/05 17:21:29 INFO     ▶ 0002 Using 'postgres://postgres:postgres@127.0.0.1:5432/postgres' as 'conn'
2018/01/05 17:21:29 INFO     ▶ 0003 Running all outstanding migrations
2018/01/05 17:21:29 FATAL    ▶ 0004 Could not show migrations table: pq: SSL is not enabled on the server

找到了解决办法:

bee migrate -driver=postgres -conn=“postgres://postgres:postgres@127.0.0.1:5432/postgres?sslmode=disable”

不会又报错了

应该是账号密码不对


2018/01/05 17:34:00 INFO     ▶ 0001 Using 'postgres' as 'driver'
2018/01/05 17:34:00 INFO     ▶ 0002 Using 'postgres://postgres:postgres@127.0.0.1:5432/postgres?sslmode=disable' as 'conn'
2018/01/05 17:34:00 INFO     ▶ 0003 Running all outstanding migrations
2018/01/05 17:34:00 FATAL    ▶ 0004 Could not show migrations table: pq: password authentication failed for user "postgres"

后来看到这个…

db, err := sql.Open(“postgres”, “postgres://username:password@localhost/db_name?sslmode=disable”)

原来我把密码写成了 postgres,我的密码是 123456

bee migrate -driver=postgres -conn=“postgres://postgres:123456@127.0.0.1:5432/postgres?sslmode=disable”

然后执行 还是报错

2018/01/05 17:43:24 INFO     ▶ 0001 Using 'postgres' as 'driver'
2018/01/05 17:43:24 INFO     ▶ 0002 Using 'postgres://postgres:123456@127.0.0.1:5432/postgres?sslmode=disable' as 'conn'
2018/01/05 17:43:24 INFO     ▶ 0003 Running all outstanding migrations
2018/01/05 17:43:28 INFO     ▶ 0004 |> 2018/01/05 17:43:26 [I] start upgrade User_20180105_163508
2018/01/05 17:43:28 INFO     ▶ 0005 |> 2018/01/05 17:43:26 [I] exec sql: CREATE TABLE user(id serial primary key,name TEXT NOT NULL,email TEXT NOT NULL,password TEXT NOT NULL)
2018/01/05 17:43:28 INFO     ▶ 0006 |> 2018/01/05 17:43:26 [E] execute error: pq: syntax error at or near "user"
2018/01/05 17:43:28 ERROR    ▶ 0007 Could not run migration binary: exit status 2

哈哈,这个问题就麻烦了!我查了好久没解决之法!

然后我把表的名字改成了 users

他喵的! 成功了!

2018/01/05 18:04:46 INFO     ▶ 0001 Using 'postgres' as 'driver'
2018/01/05 18:04:46 INFO     ▶ 0002 Using 'postgres://postgres:123456@127.0.0.1:5432/postgres?sslmode=disable' as 'conn'
2018/01/05 18:04:46 INFO     ▶ 0003 Running all outstanding migrations
2018/01/05 18:04:50 INFO     ▶ 0004 |> 2018/01/05 18:04:48 [I] start upgrade User_20180105_163508
2018/01/05 18:04:50 INFO     ▶ 0005 |> 2018/01/05 18:04:48 [I] exec sql: CREATE TABLE users(id serial primary key,name TEXT NOT NULL,email TEXT NOT NULL,password TEXT NOT NULL)
2018/01/05 18:04:50 INFO     ▶ 0006 |> 2018/01/05 18:04:48 [I] end upgrade: User_20180105_163508
2018/01/05 18:04:50 INFO     ▶ 0007 |> 2018/01/05 18:04:48 [I] total success upgrade: 1  migration
2018/01/05 18:04:50 SUCCESS  ▶ 0008 Migration successful!


然后在软件里看到了我要的表!

哎!不会玩只能瞎鸡巴摸索了!(希望一段时间后的我看到这,不要觉得自己是个傻x就行)


欢迎转载,但请附上原文地址哦,尊重原创,谢谢大家 本文地址: https://www.iphpt.com/detail/108/
本站(PHP --> Golang)已重构,代码开源

当你能力不能满足你的野心的时候,你就该沉下心来学习