pgsql大象的安装以及配置加外网穿透

Download PostgreSQL Binaries

下载大象地址》》》》》》》如上

一键配置环境代码如下

配置pgsql环境变量执行选择目录版vbs
Set shell = CreateObject("Shell.Application")
Set selFolder = shell.BrowseForFolder(0, "请选择PGHOME目录", 0, ssfDRIVES)
Set selFolderItem = selFolder.Self
selPath = selFolderItem.Path
dim wsh
Set wsh = WScript.CreateObject("WScript.Shell")
wsh.Environment("system").Item("PGHOME")=selPath
wsh.Environment("system").Item("PGHOST")="localhost"
wsh.Environment("system").Item("Path")=wsh.Environment("system").Item("path")+"\bin;"+wsh.Environment("system").Item("Path")
wsh.Environment("system").Item("PGLIB")=wsh.Environment("system").Item("PGHOME")+"\lib"
wsh.Environment("system").Item("PGDATA")=wsh.Environment("system").Item("PGHOME")+"\data"
msgbox "oklfq666帮您完成配置"



配置固定路径版vbs
Set shell = CreateObject("Shell.Application")
dim wsh
Set wsh = WScript.CreateObject("WScript.Shell")
wsh.Environment("system").Item("PGHOME")="C:\Users\LFQ666\Desktop\postgresql\pgsql"
wsh.Environment("system").Item("PGHOST")="localhost"
wsh.Environment("system").Item("Path")=wsh.Environment("system").Item("path")+"\bin;"+wsh.Environment("system").Item("Path")
wsh.Environment("system").Item("PGLIB")=wsh.Environment("system").Item("PGHOME")+"\lib"
wsh.Environment("system").Item("PGDATA")=wsh.Environment("system").Item("PGHOME")+"\data"
msgbox "oklfq666帮您完成配置"

执行如上的记得文件后缀改成.vbs

 ./initdb.exe -D C:\Users\LFQ666\Desktop\postgresql\pgsql\data -E UTF-8 --locale=chs -U postgres -W

./pg_ctl.exe register -N "pgsql" -D "C:\Users\LFQ666\Desktop\postgresql\pgsql\data"

./pg_ctl start -D C:\Users\LFQ666\Desktop\postgresql\pgsql\data

执行上面三段代码

用powershell管理员模式执行

 

 

 

 

 下面是重头戏开启内网穿透

 然后你用pg大象链接对应网址就可以链接你本地数据库操作了

各位告辞，晚安