#退出PG交互界面 # psql -h localhost -p 5432 -U postgres #使用postgres用户登录，需要密 码，默认登录postgres库 postgres=# #提示符 => 表示普通账号，=#表示管理员账号 postgres=# #提示符=>前的postgres表示当前数据库名 # psql -h x.x.x.x -p 5432 -U cof -d db_test #使用cof用户登录pg，连接 db_test这个库 db_test=> #提示符 1.122 -p 5432 -U postgres #连接pg数据库， # -h指定地址，-p指定端口号，-U指定用户（默认为当前shell用户名），-W指定 用户密码， # -d指定数据库，默认连接的数据库名同用户名 Password for user postgres: #输入密码 psql (13.13) Type "help"

复制相对物理复制来说是非常方便 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 特性 逻 辑 解 码 复 制 槽 位 技 术 自定义输出插件 自动导出快照 无 D B 限 制 logical 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会

.........................2278 D. SQL Conformance ..................................................................................................................2303 D.1. Supported Features ....... ..............................................................................................2304 D.2. Unsupported Features............................................................................ mailing list. If your bug report has security implications and you’d prefer that it not become immediately visible in public archives, don’t send it to pgsql-bugs. Security

............................2147 D. SQL Conformance ...........................................................................................................2170 D.1. Supported Features ........... ...................................................................................2171 D.2. Unsupported Features....................................................................................... mailing list. If your bug report has security implications and you’d prefer that it not become immediately vis- ible in public archives, don’t send it to pgsql-bugs. Security

.........................2146 D. SQL Conformance ..................................................................................................................2171 D.1. Supported Features ....... ..............................................................................................2172 D.2. Unsupported Features............................................................................ mailing list. If your bug report has security implications and you’d prefer that it not become immediately visible in public archives, don’t send it to pgsql-bugs. Security

............................2019 D. SQL Conformance ...........................................................................................................2042 D.1. Supported Features ........... ...................................................................................2043 D.2. Unsupported Features....................................................................................... mailing list. If your bug report has security implications and you’d prefer that it not become immediately vis- ible in public archives, don’t send it to pgsql-bugs. Security

.................................. 2293 D. SQL Conformance ............................................................................................. 2318 D.1. Supported Features .................. ...................................... 2319 D.2. Unsupported Features .............................................................................. 2335 D.3. XML Limits and Conformance to SQL/XML ... mailing list. If your bug report has security implications and you'd prefer that it not become immediately visible in public archives, don't send it to pgsql-bugs. Security

..................................... 2181 D. SQL Conformance ....................................................................................... 2204 D.1. Supported Features ..................... ......................................... 2205 D.2. Unsupported Features ......................................................................... 2220 D.3. XML Limits and Conformance to SQL/XML ..... 10 https://www.postgresql.org/ xxxv Preface If your bug report has security implications and you'd prefer that it not become immediately visible in public archives, don't send it to pgsql-bugs. Security

.........................2355 D. SQL Conformance ..................................................................................................................2380 D.1. Supported Features ....... ..............................................................................................2381 D.2. Unsupported Features............................................................................ mailing list. If your bug report has security implications and you’d prefer that it not become immediately visible in public archives, don’t send it to pgsql-bugs. Security

............................2226 D. SQL Conformance ...........................................................................................................2249 D.1. Supported Features ........... ...................................................................................2250 D.2. Unsupported Features....................................................................................... mailing list. If your bug report has security implications and you’d prefer that it not become immediately vis- ible in public archives, don’t send it to pgsql-bugs. Security