postgresql操作手册systemctl start postgresql-13 ★第2章、设置数据存储路径 PostgreSQL 初始化数据库之后, 10版本的默认的数据目录是/var/lib/pgsql/ 13版本的默认的数据目录是/var/lib/pgsql/13/ 现在想修改为/data_pg/ 目录 ★PG-13版本 # systemctl stop postgresql-13 chown postgres:postgres /data_pg # vi /var/lib/pgsql/13/data/postgresql.conf #pg-13版本,添加或修改以下配 置 data_directory = '/data_pg/data/' # mv /var/lib/pgsql/13/* /data_pg/ /usr/lib/systemd/system/postgresql-13.service #pg-13版本,修改systemd服 务文件,指定数据目录 #修改这行:Environment=PGDATA=/var/lib/pgsql/13/data/ 改为新的路径,如 下: Environment=PGDATA=/data_pg/data/ # systemctl daemon-reload # systemctl0 码力 | 17 页 | 445.84 KB | 1 年前3
PostgreSQL 9.3.25 Documentation..............................................................................................805 VAR................................................................................................... numeric double precision for floating-point arguments, otherwise numeric historical alias for var_samp var_pop(expression) smallint, int, bigint, real, double precision, or numeric double precision for otherwise numeric population variance of the input values (square of the population standard deviation) var_samp(expression) smallint, int, bigint, real, double precision, or numeric double precision for floating-point0 码力 | 3002 页 | 7.47 MB | 1 年前3
PostgreSQL 9.3 Documentation..............................................................................................852 VAR................................................................................................... numeric double precision for floating-point arguments, otherwise numeric historical alias for var_samp var_pop(expression) smallint, int, bigint, real, double precision, or numeric double precision for otherwise numeric population variance of the input values (square of the population standard deviation) var_samp(expression) smallint, int, bigint, real, double precision, or numeric double precision for floating-point0 码力 | 3183 页 | 7.53 MB | 1 年前3
PostgreSQL 9.5.25 Documentation
..............................................................................................862 VAR................................................................................................... numeric double precision for floating-point arguments, otherwise numeric historical alias for var_samp var_pop(expression) smallint, int, bigint, real, double precision, or numeric double precision for otherwise numeric population variance of the input values (square of the population standard deviation) var_samp(expression) smallint, int, bigint, real, double precision, or numeric double precision for floating-point0 码力 | 2558 页 | 6.27 MB | 1 年前3
PostgreSQL 9.1.24 Documentation
..............................................................................................754 VAR................................................................................................... numeric double precision for floating-point arguments, otherwise numeric historical alias for var_samp var_pop(expression) smallint, int, bigint, real, double precision, or numeric double precision for otherwise numeric population variance of the input values (square of the population standard deviation) var_samp(expression) smallint, int, bigint, real, double precision, or numeric double precision for floating-point0 码力 | 2667 页 | 6.57 MB | 1 年前3
PostgreSQL 9.1 Documentation..............................................................................................798 VAR................................................................................................... numeric double precision for floating-point arguments, otherwise numeric historical alias for var_samp var_pop(expression) smallint, int, bigint, real, double precision, or numeric double precision for otherwise numeric population variance of the input values (square of the population standard deviation) var_samp(expression) smallint, int, bigint, real, double precision, or numeric double precision for floating-point0 码力 | 2836 页 | 6.62 MB | 1 年前3
PostgreSQL 9.4.26 Documentation
..............................................................................................835 VAR................................................................................................... numeric double precision for floating-point arguments, otherwise numeric historical alias for var_samp var_pop(expression) smallint, int, bigint, real, double precision, or numeric double precision for otherwise numeric population variance of the input values (square of the population standard deviation) var_samp(expression) smallint, int, bigint, real, double precision, or numeric double precision for floating-point0 码力 | 2452 页 | 5.99 MB | 1 年前3
PostgreSQL 9.5 Documentation..............................................................................................912 VAR................................................................................................... numeric double precision for floating-point arguments, otherwise numeric historical alias for var_samp var_pop(expression) smallint, int, bigint, real, double precision, or numeric double precision for deviation) 308 Chapter 9. Functions and Operators Function Argument Type Return Type Description var_samp(expression) smallint, int, bigint, real, double precision, or numeric double precision for floating-point0 码力 | 2714 页 | 6.33 MB | 1 年前3
PostgreSQL 9.4 Documentation..............................................................................................882 VAR................................................................................................... numeric double precision for floating-point arguments, otherwise numeric historical alias for var_samp var_pop(expression) smallint, int, bigint, real, double precision, or numeric double precision for otherwise numeric population variance of the input values (square of the population standard deviation) var_samp(expression) smallint, int, bigint, real, double precision, or numeric double precision for floating-point0 码力 | 2603 页 | 6.05 MB | 1 年前3
PostgreSQL 9.2 Documentation..............................................................................................781 VAR................................................................................................... numeric double precision for floating-point arguments, otherwise numeric historical alias for var_samp var_pop(expression) smallint, int, bigint, real, double precision, or numeric double precision for otherwise numeric population variance of the input values (square of the population standard deviation) var_samp(expression) smallint, int, bigint, real, double precision, or numeric double precision for floating-point0 码力 | 2829 页 | 7.02 MB | 1 年前3
共 41 条
- 1
- 2
- 3
- 4
- 5













