pg数据库
查看当前数据库所有schema:
\l + 列出所有的数据库
\du + 列出角色
\dn 列出所有schema
\du 列出
查询schema所属于那个数据库:
select * from information_schema.schemata;
tomtcat 优化
cd /opt/gdmp/tomcat/bin
echo > setenv.sh
chmod 755 setenv.sh
vim setenv.sh
CATALINA_OPTS=“
C
A
T
A
L
I
N
A
O
P
T
S
−
D
j
a
v
a
.
s
e
c
u
r
i
t
y
.
e
g
d
=
f
i
l
e
:
/
d
e
v
/
.
/
u
r
a
n
d
o
m
"
C
A
T
A
L
I
N
A
O
P
T
S
=
"
CATALINA_OPTS -Djava.security.egd=file:/dev/./urandom" CATALINA_OPTS="
CATALINAOPTS−Djava.security.egd=file:/dev/./urandom"CATALINAOPTS="CATALINA_OPTS -Djava.awt.headless=true -Dfile.encoding=UTF-8 -XX:-OmitStackTraceInFastThrow”
CATALINA_OPTS=“
C
A
T
A
L
I
N
A
O
P
T
S
−
s
e
r
v
e
r
−
X
m
s
2
g
−
X
m
x
2
g
−
X
X
:
M
e
t
a
s
p
a
c
e
S
i
z
e
=
256
m
−
X
X
:
M
a
x
M
e
t
a
s
p
a
c
e
S
i
z
e
=
256
m
"
C
A
T
A
L
I
N
A
O
P
T
S
=
"
CATALINA_OPTS -server -Xms2g -Xmx2g -XX:MetaspaceSize=256m -XX:MaxMetaspaceSize=256m" CATALINA_OPTS="
CATALINAOPTS−server−Xms2g−Xmx2g−XX:MetaspaceSize=256m−XX:MaxMetaspaceSize=256m"CATALINAOPTS="CATALINA_OPTS -XX:+UseConcMarkSweepGC -XX:+UseParNewGC -XX:+CMSClassUnloadingEnabled -XX:+UseCMSInitiatingOccupancyOnly -XX:CMSInitiatingOccupancyFraction=68”
CATALINA_OPTS=“
C
A
T
A
L
I
N
A
O
P
T
S
−
X
X
:
E
r
r
o
r
F
i
l
e
=
CATALINA_OPTS -XX:ErrorFile=
CATALINAOPTS−XX:ErrorFile=CATALINA_BASE/logs/hs_err_pid%p.log”
CATALINA_OPTS=“
C
A
T
A
L
I
N
A
O
P
T
S
−
X
X
:
+
H
e
a
p
D
u
m
p
O
n
O
u
t
O
f
M
e
m
o
r
y
E
r
r
o
r
−
X
X
:
H
e
a
p
D
u
m
p
P
a
t
h
=
CATALINA_OPTS -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=
CATALINAOPTS−XX:+HeapDumpOnOutOfMemoryError−XX:HeapDumpPath=CATALINA_BASE/logs”
CATALINA_OPTS=“
C
A
T
A
L
I
N
A
O
P
T
S
−
v
e
r
b
o
s
e
:
g
c
−
X
X
:
+
P
r
i
n
t
C
o
m
m
a
n
d
L
i
n
e
F
l
a
g
s
−
X
X
:
+
P
r
i
n
t
G
C
A
p
p
l
i
c
a
t
i
o
n
S
t
o
p
p
e
d
T
i
m
e
−
X
X
:
+
P
r
i
n
t
G
C
D
a
t
e
S
t
a
m
p
s
−
X
X
:
+
P
r
i
n
t
G
C
D
e
t
a
i
l
s
−
X
X
:
+
P
r
i
n
t
H
e
a
p
A
t
G
C
−
X
X
:
+
P
r
i
n
t
T
e
n
u
r
i
n
g
D
i
s
t
r
i
b
u
t
i
o
n
−
X
l
o
g
g
c
:
CATALINA_OPTS -verbose:gc -XX:+PrintCommandLineFlags -XX:+PrintGCApplicationStoppedTime -XX:+PrintGCDateStamps -XX:+PrintGCDetails -XX:+PrintHeapAtGC -XX:+PrintTenuringDistribution -Xloggc:
CATALINAOPTS−verbose:gc−XX:+PrintCommandLineFlags−XX:+PrintGCApplicationStoppedTime−XX:+PrintGCDateStamps−XX:+PrintGCDetails−XX:+PrintHeapAtGC−XX:+PrintTenuringDistribution−Xloggc:CATALINA_BASE/logs/gc-
(
d
a
t
e
+
∗
∗
注
意
∗
∗
注
意
:
这
是
8
G
内
存
的
设
置
,
如
果
内
存
是
4
G
。
修
改
这
一
行
C
A
T
A
L
I
N
A
O
P
T
S
=
"
(date +%y%m%d%H%M%S).log" **注意** 注意:这是8G内存的设置,如果内存是4G。修改这一行 CATALINA_OPTS="
(date+∗∗注意∗∗注意:这是8G内存的设置,如果内存是4G。修改这一行CATALINAOPTS="CATALINA_OPTS -server -Xms4g -Xmx4g -XX:MetaspaceSize=256m -XX:MaxMetaspaceSize=256m”
改为
CATALINA_OPTS=“$CATALINA_OPTS -server -Xms2g -Xmx2g -XX:MetaspaceSize=256m -XX:MaxMetaspaceSize=256m”
安装pg数据库
查看用户: cat /etc/passwd|grep -v nologin|grep -v halt|grep -v shutdown|awk -F":" '{ print $1"|“$3”|"KaTeX parse error: Expected 'EOF', got '}' at position 3: 4 }̲'|more cat /e…PATH:
H
O
M
E
/
b
i
n
:
/
h
o
m
e
/
p
o
s
t
g
r
e
s
q
l
/
p
g
s
q
l
/
b
i
n
e
x
p
o
r
t
L
D
L
I
B
R
A
R
Y
P
A
T
H
=
HOME/bin:/home/postgresql/pgsql/bin export LD_LIBRARY_PATH=
HOME/bin:/home/postgresql/pgsql/binexportLDLIBRARYPATH=LD_LIBRARY_PATH:/home/postgresql/pgsql/lib
export PGDATABASE=postgres
export PGPORT=5432
source ~/.bash_profile
查看postgres进程:ps -ef | grep postgres
postgres启动: ./pgsql/bin/pg_ctl -D ./pgsql/pgsql_data/ -l ./pgsql/logfile start #
postgres关闭: ./pgsql/bin/pg_ctl -D ./pgsql/pgsql_data/ stop
postgres重启: ./pgsql/bin/pg_ctl -D ./pgsql/pgsql_data/ -l ./pgsql/logfile restart
cd /home/postgresql/pgsql/pgsql_data
vim postgresql.conf #编辑文件
listen_addresses= ‘*’(默认为localhost,*为所有,也可以指定IP)
cd /home/postgresql/pgsql/pgsql_data
vim pg_hba.conf # 编辑该文件
host all all 0.0.0.0/0 trust
重启数据库即可
pgsql:
进入数据库:psql(psql -h 127.0.0.1)
创建数账号:create user name with password ’ ';
?创建数据库和关联系统用户:CREATE DATABASE database1 WITH OWNER=postgres ENCODING=‘UTF-8’; (如果不创建这个postgres,可行不??)
创建schema:create schema name;
赋予用户权限:grant USAGE on SCHEMA name to pgsql;
更改schema 所属:alter schema name owner to pgsql;
注意:这写对应的是,tomcat中的项目中的配置文件对应(/opt/gdmp/tomcat_beihaiDemo/webapps/ROOT/WEB-INF/classes/application-default.properties)
\l + 列出所有的数据库
\du + 列出角色
\dn 列出所有schema
\du 列出
检查postgres的日志:cd /data/postgresql/pgsql
查看java进程:ps -ef | grep java
启动 activemq
./activemq start
停止 activemq
./activemq stop
跟踪日志文件:tail -f logfile (本项目activemq用户口令为1qaz@WSX)
rm -rf 删除
查看端口号:netstat -ntlp
授予权限问题:chmod 777 文件