go git

Err

main.go:7:2: cannot find package "github.com/lib/pq" in any of:

        /usr/local/go/src/github.com/lib/pq (from $GOROOT)

        /home/ub1/go/src/github.com/lib/pq (from $GOPATH)

sudo apt install git

Err

b1@ub1-System-Product-Name:~/golang/03$ go get github.com/mattn/go-sqlite3

# github.com/mattn/go-sqlite3

cgo: C compiler "gcc" not found: exec: "gcc": executable file not found in $PATH

sudo apt install gcc

Ubuntu sqlitebrowser

https://linuxhint.com/install_sqlite_browser_ubuntu/

sudo apt install sqlitebrowser

Golang

sudo snap install go 

rror: This revision of snap "go" was published using classic confinement and

       thus may perform arbitrary system changes outside of the security

       sandbox that snaps are usually confined to, which may put your system at

       risk.

       If you understand and want to proceed repeat the command including

       --classic.

---

export PATH=$PATH:/usr/local/go/bin

source ~/.bashrcexport PATH=$PATH:/usr/local/go/bin

source ~/.bashrc

 sudo gedit ~/.bashrc

Uuntu20.04 Golang

https://golang.org/

https://mebee.info/2020/05/01/post-10627/

---

https://ja.linux-console.net/?p=637

cd /home/ub1/ダウンロード

go1.17.2.linux-amd64.tar.gz

sudo tar -C /usr/local -xzf go1.17.2.linux-amd64.tar.gz

---

git
sudo apt install git
export PATH=$PATH:/usr/local/go/bin

source ~/.bashrc

sudo gedit ~/.bashrc



go version

---

no required module provides package github.com/lib/pq: go.mod file not found in current directory or any parent directory; see 'go help modules'

git
sudo apt install git



go get github.com/lib/pq

---

go help modules


a1@a1-System-Product-Name:~/golang/01$ go help modulesModules are how Go manages dependencies.A module is a collection of packages that are released, versioned, anddistributed together. Modules may be downloaded directly from version controlrepositories or from module proxy servers.For a series of tutorials on modules, seehttps://golang.org/doc/tutorial/create-module.For a detailed reference on modules, see https://golang.org/ref/mod.By default, the go command may download modules from https://proxy.golang.org.It may authenticate modules using the checksum database athttps://sum.golang.org. Both services are operated by the Go team at Google.The privacy policies for these services are available athttps://proxy.golang.org/privacy and https://sum.golang.org/privacy,respectively.The go command's download behavior may be configured using GOPROXY, GOSUMDB,GOPRIVATE, and other environment variables. See 'go help environment'and https://golang.org/ref/mod#private-module-privacy for more information.a1@a1-System-Product-Name:~/golang/01$

VSCODE
https://future-architect.github.io/articles/20201117/

1. >Go: Install/Update Tools と入力する。

Ubuntu20.04 VS CODE

https://code.visualstudio.com/docs/?dv=linux64_deb

install end









pgadmin4 v6.0 Ubuntu20.04

https://www.pgadmin.org/download/pgadmin-4-apt/

sudo curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo apt-key add

sudo sh -c 'echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update'

sudo apt install pgadmin4

sudo apt install pgadmin4-desktop

PostgreSQL14 Ubuntu20.04

https://www.postgresql.org/download/linux/ubuntu/

sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

sudo apt-get update

sudo apt-get -y install postgresql

---

sudo -i u postgresql   /  sudo su - postgres 

psql

select version();

---

err

-bash: u: コマンドが見つかりません

sudo su - postgres 

psql

---

alter role postgres with password 'NewPasswd123';

sudo service postgresql restart

---

pg_dump database名 > backup_file名

psql dbname < infile

pg_restore -U "ユーザー名" -C -d "DB名" db.dump

---

sudo gedit /etc/postgresql/14/main/postgresql.conf