GitHub - whupyw/postgresql-json-cache

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 26 Commits
.idea		.idea
.vscode		.vscode
bin		bin
config		config
contrib		contrib
doc		doc
lib/pgxs		lib/pgxs
src		src
.dir-locals.el		.dir-locals.el
.editorconfig		.editorconfig
.git-blame-ignore-revs		.git-blame-ignore-revs
.gitattributes		.gitattributes
.gitignore		.gitignore
.gitrevision		.gitrevision
CMakeLists.txt		CMakeLists.txt
COPYRIGHT		COPYRIGHT
GNUmakefile.in		GNUmakefile.in
HISTORY		HISTORY
INSTALL		INSTALL
Makefile		Makefile
README		README
aclocal.m4		aclocal.m4
alarmdata.sql		alarmdata.sql
configure		configure
configure.ac		configure.ac
flamegraph.html		flamegraph.html
rows.json		rows.json
rows.sh		rows.sh
rows.sql		rows.sql
rows_jsonb.json		rows_jsonb.json
rows_jsonb.sh		rows_jsonb.sh
rows_jsonb.sql		rows_jsonb.sql

Repository files navigation

# 安装以及第一次编译

1. 下载项目源代码并进入项目根目录
git clone https://github.com/Yuan-Yuhan/postgresql-json-cache.git

2. adduser postgres	# 添加postgres用户, 若已添加可以忽略
   mkdir /var/postgresql/data # 创建data文件夹
   chown postgres /var/postgresql/data # 授予postgres权限
   chmod -R 775 ./* # 赋予所有读写权限

3. sh configure --enable-depend --enable-cassert --enable-debug CFLAGS="-ggdb -O0" # 初始化config
   su # 以超级管理员权限进行编译，如果未开启可能出现chmod不允许
   make && make install # 编译，如果在这一步出现了组件缺少报错，则安装组件，并重新初始化Config

4. su - postgres # 登录postgres用户
   /usr/local/pgsql/bin/initdb -D /var/postgresql/data # 初始化数据库文件夹
   /usr/local/pgsql/bin/pg_ctl start -D  /var/postgresql/data # # 启动服务器
   /usr/local/pgsql/bin/createdb postgres	# 创建数据库
   /usr/local/pgsql/bin/psql postgres	# 连接数据库


# 开发更新和编译

1. sudo make distclean	# 清空所有上次configure产生的文件(重新编译时需执行)

2. sh configure --enable-depend --enable-cassert --enable-debug CFLAGS="-ggdb -O0" # 初始化config
   su # 以超级管理员权限进行编译，如果未开启可能出现chmod不允许
   make && make install # 编译，如果在这一步出现了组件缺少报错，则安装组件，并重新初始化Config



PostgreSQL Database Management System
=====================================

This directory contains the source code distribution of the PostgreSQL
database management system.

PostgreSQL is an advanced object-relational database management system
that supports an extended subset of the SQL standard, including
transactions, foreign keys, subqueries, triggers, user-defined types
and functions.  This distribution also contains C language bindings.

PostgreSQL has many language interfaces, many of which are listed here:

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

See the file INSTALL for instructions on how to build and install
PostgreSQL.  That file also lists supported operating systems and
hardware platforms and contains information regarding any other
software packages that are required to build or run the PostgreSQL
system.  Copyright and license information can be found in the
file COPYRIGHT.  A comprehensive documentation set is included in this
distribution; it can be read as described in the installation
instructions.

The latest version of this software may be obtained at
https://www.postgresql.org/download/.  For more information look at our
web site located at https://www.postgresql.org/.