PG从小工到专家学习笔记-服务管理.pdf

蔡璐

云和恩墨交付战队

390

1页

9次

2021-12-06

5墨值下载



 postgres ; postgres-D/home/osdba/pgdata&

 pg_ctl pg_ctl-D/home/osdba/pgdatastart

  postgres signal

 ;

SIGTERM: SmartShutdown

SIGINT: FastShutdown

SIGQUIT: ImmediateShutdown

 pg_ctl

pg_ctlstop-DDATADIR-msmart

pg_ctlstop-DDATADIR-mfast

pg_ctlstop-DDATADIR-mimmediate

pg_ctl



 PostgreSQL

  PostgreSQL

 PostgreSQL



 Windows

pg_ctlinit[db][-s][-Ddatadir][-ooptions]

-S:

-Ddatadir: 

ooptions: initdb initdb

pgctlstart[-w)[-tseconds)[-s)[-Ddatadir)[-1ﬁlename)[-ooptions)[-ppath)[-cl



pgctlstop[-W)[-tseconds)[-s)[ Ddatadir)[-ms[mart)If[ast)Ii[mmediate))



 pgctlrestart[-w)[-tseconds)[-s)[-Ddatadir)[-c)[-ms[mart)If[ast)Ii[mmediate)][-o·options)

 pg_ctlreload[-s](-Ddatadir]



 pg_ctlstatus(-Ddatadir]





postgres



 selectversion();

 selectpg_postmaster_start_time();

 load selectpg_conf_load_time();

 pg_ctl_reload pg_ctl_reload

 showtimezone;

 selectuser;selectcurrent_user;

 session selectsession_user;



 session IP port

selectinet_client_addr(),inet_client_port(),

inet_server_addr(),inet_server_port();



selectpg_backend_pid();ps-ef|grep$pid|

grep-vgrep

 wal

selectpg_xlogﬁle_name(pg_current_xlog_

location());



 selectpg_is_in_back(),pg_back_start_time();

 HotStandby



selectpg_is_in_recovery();



 selectpg_size_pretty(pg_relation_size('pgdb2'));

 selectpg_size_pretty(pg_total_relation_size('pgdb2'));

 selectpg_size_pretty(pg_indexs_size('pgdb2'));

selectpg_database_size('osdba'),pg_size_

pretty(pg_database_size('osdba'));



 postgresql_conf

pg_ctlreload

selectpg_reload_confg();

 log selectpg_rotate_logﬁle();

 WAL selectpg_switch_xlog();

 checkpoint checkpoint;

 sql



pg_cancel_backend(pid);

pg_terminate_backend(pid);

1.pg_cancel_backend(pid); sql



 2.pg_terminate_backend(pid);

 sql



 selectenumvalsfrompg_settingswherename= client_min_messages’;

 selectunitfrompg_settingswherename=’atitovacuum_vacuum_cost_delay’;

 selectshortdesc,extradescfrompgsettingswherename=’autovacuumvacuumcostdelay';



internal:

postgres

 



 postgresql.conf postgres 



postmaster: 

 PostgreSQL

 postgresql.onf

 PostgreSQL

sighup: postgresql.onf



 postmaster SIG JP



postmaster SIGHUP SIGHUP

  

backend: postgresql.conf

 

 postmaster SIGHUP

 postgresql.conf

 

superuser:

 set

 sesssion 

postmaster SIGHUP 

user: set



  superuser

selectname,contextfrompg_settingswherenamelike’wal_buﬀers’;



listen_addresses:string  

 TCP/IP 

“0.0.0.0” “*" IP

 IP   

 “localhost”  “loopback”



port:integer TCP 

5432

 IP

max_connections:integer 



 100

 (  tdb )  100

 

  PostgreSQL SystemV

 

 HOTStandby 

  HOTStandby

superuser_reserved_connections:integer 

 PostgreSQL 

  3

  max_connections-superuser_reserved_

connections

 maxconnections

unix_socket_directory:string 

 UNTX  

  /tmp

 .s.PGSQL.nnnn,.s.PGSQL.nnnn.lock(nnnn  )



unix_socket_group:string   UN 

 (  )



   

unix_socket_permissions:integer   

UnIX

 

 0777  0770(

 ) 0700(  )

 

bonjour:boolean bonjour  

Bnjour PostgreSQL   o

bonjour_name:string Bonjour     

   Bonjour  

tcp_keepalives_idle:integer TCP  keepalive  0



SmartShutdown:  

   

 

FastShutdown:  

  SIGTERM



ImmediateShutdown:    postgres

 SIGQUIT 



 postgres ; postgres-D/home/osdba/pgdata&

 pg_ctl pg_ctl-D/home/osdba/pgdatastart

  postgres signal

 ;

SIGTERM: SmartShutdown

SIGINT: FastShutdown

SIGQUIT: ImmediateShutdown

 pg_ctl

pg_ctlstop-DDATADIR-msmart

pg_ctlstop-DDATADIR-mfast

pg_ctlstop-DDATADIR-mimmediate

pg_ctl



 PostgreSQL

  PostgreSQL

 PostgreSQL



 Windows

pg_ctlinit[db][-s][-Ddatadir][-ooptions]

-S:

-Ddatadir: 

ooptions: initdb initdb

pgctlstart[-w)[-tseconds)[-s)[-Ddatadir)[-1ﬁlename)[-ooptions)[-ppath)[-cl



pgctlstop[-W)[-tseconds)[-s)[ Ddatadir)[-ms[mart)If[ast)Ii[mmediate))



 pgctlrestart[-w)[-tseconds)[-s)[-Ddatadir)[-c)[-ms[mart)If[ast)Ii[mmediate)][-o·options)

 pg_ctlreload[-s](-Ddatadir]



 pg_ctlstatus(-Ddatadir]





postgres



 selectversion();

 selectpg_postmaster_start_time();

 load selectpg_conf_load_time();

 pg_ctl_reload pg_ctl_reload

 showtimezone;

 selectuser;selectcurrent_user;

 session selectsession_user;



 session IP port

selectinet_client_addr(),inet_client_port(),

inet_server_addr(),inet_server_port();



selectpg_backend_pid();ps-ef|grep$pid|

grep-vgrep

 wal

selectpg_xlogﬁle_name(pg_current_xlog_

location());



 selectpg_is_in_back(),pg_back_start_time();

 HotStandby



selectpg_is_in_recovery();



 selectpg_size_pretty(pg_relation_size('pgdb2'));

 selectpg_size_pretty(pg_total_relation_size('pgdb2'));

 selectpg_size_pretty(pg_indexs_size('pgdb2'));

selectpg_database_size('osdba'),pg_size_

pretty(pg_database_size('osdba'));



 postgresql_conf

pg_ctlreload

selectpg_reload_confg();

 log selectpg_rotate_logﬁle();

 WAL selectpg_switch_xlog();

 checkpoint checkpoint;

 sql



pg_cancel_backend(pid);

pg_terminate_backend(pid);

1.pg_cancel_backend(pid); sql



 2.pg_terminate_backend(pid);

 sql



 selectenumvalsfrompg_settingswherename= client_min_messages’;

 selectunitfrompg_settingswherename=’atitovacuum_vacuum_cost_delay’;

 selectshortdesc,extradescfrompgsettingswherename=’autovacuumvacuumcostdelay';



internal:

postgres

 



 postgresql.conf postgres 



postmaster: 

 PostgreSQL

 postgresql.onf

 PostgreSQL

sighup: postgresql.onf



 postmaster SIG JP



postmaster SIGHUP SIGHUP

  

backend: postgresql.conf

 

 postmaster SIGHUP

 postgresql.conf

 

superuser:

 set

 sesssion 

postmaster SIGHUP 

user: set



  superuser

selectname,contextfrompg_settingswherenamelike’wal_buﬀers’;



listen_addresses:string  

 TCP/IP 

“0.0.0.0” “*" IP

 IP   

 “localhost”  “loopback”



port:integer TCP 

5432

 IP

max_connections:integer 



 100

 (  tdb )  100

 

  PostgreSQL SystemV

 

 HOTStandby 

  HOTStandby

superuser_reserved_connections:integer 

 PostgreSQL 

  3

  max_connections-superuser_reserved_

connections

 maxconnections

unix_socket_directory:string 

 UNTX  

  /tmp

 .s.PGSQL.nnnn,.s.PGSQL.nnnn.lock(nnnn  )



unix_socket_group:string   UN 

 (  )



   

unix_socket_permissions:integer   

UnIX

 

 0777  0770(

 ) 0700(  )

 

bonjour:boolean bonjour  

Bnjour PostgreSQL   o

bonjour_name:string Bonjour     

   Bonjour  

tcp_keepalives_idle:integer TCP  keepalive  0



SmartShutdown:  

   

 

FastShutdown:  

  SIGTERM



ImmediateShutdown:    postgres

 SIGQUIT 



of 1

5墨值下载

postgresql

关注

评论