# pocks

**Repository Path**: lushell/pocks

## Basic Information

- **Project Name**: pocks
- **Description**: pocks is a extend for pg use rocksdb as storage engine.
with rocksdb using fdw
版权问题，暂时私有。

- **Primary Language**: C
- **License**: MulanPSL-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2022-12-15
- **Last Updated**: 2023-11-28

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README



install rocksdb use following steps.
1. Install shared lib into linux. Compilier pocksdb needs this lib.
make shared_lib
make shared_lib install

2. Move pocks into postgresql's source directory contrib/pocksdb
(Be honest, atfer step 1, you can make && make install pocksdb, but
postgresql can not start until install shared lib into pglib(INSTALL/lib).)

3. Install shared lib into pglib(here is installed /usr/local/pgsql). The extension pocksdb need to load it.
[root@dev rocksdb]# install -d /usr/local/pgsql/lib
[root@dev rocksdb]# install -C -m 755 librocksdb.so.7.8.0 /usr/local/pgsql/lib
[root@dev rocksdb]# ln -fs librocksdb.so.7.8.0  /usr/local/pgsql/lib/librocksdb.so.7.8
[root@dev rocksdb]# ln -fs librocksdb.so.7.8.0 /usr/local/pgsql/lib/librocksdb.so.7
[root@dev rocksdb]# ln -fs librocksdb.so.7.8.0 /usr/local/pgsql/lib/librocksdb.so


[postgres@dev pgsql]$ ls -l lib/librocksdb.so*
lrwxrwxrwx. 1 postgres root        19 Apr 26 10:19 lib/librocksdb.so -> librocksdb.so.7.8.0
lrwxrwxrwx. 1 postgres root        19 Apr 26 10:19 lib/librocksdb.so.7 -> librocksdb.so.7.8.0
lrwxrwxrwx. 1 postgres root        19 Apr 26 10:19 lib/librocksdb.so.7.8 -> librocksdb.so.7.8.0
-rwxr-xr-x. 1 postgres root 270053024 Apr 26 10:18 lib/librocksdb.so.7.8.0

4. Install pocksdb.
make && make install

5. You cant not use pocksdb until start or restart your postgresql.


6. Test:query pockdb system catalog.
[postgres@dev pgsql]$ bin/psql 
psql (15.1)
Type "help" for help.

postgres=# select * from pkdb;
 id | columnoid | tableoid | databaseoid | isprimary 
----+-----------+----------+-------------+-----------
  1 |         1 |        1 |           1 | t
(1 row)

postgres=# select * from pkdb_database;
 oid |     name      |     create_time     
-----+---------------+---------------------
   1 | pkdb_database | 2022-03-26 21:12:00
(1 row)

postgres=# select * from pkdb_table;
 id |    name    | database_name | database_oid |     create_time     
----+------------+---------------+--------------+---------------------
  1 | pkdb_table | pkdb_database |            1 | 2022-03-26 21:12:00
(1 row)

postgres=# select * from pkdb_column;
 id |     name      |  type   | type_oid |  index  | index_oid | index_order | table_name | table_oid |     create_time     |     update_time     
----+---------------+---------+----------+---------+-----------+-------------+------------+-----------+---------------------+---------------------
  1 | oid           | int     |        1 | primary |         1 |           1 | pkdb_table |         1 | 2022-03-26 21:12:00 | 2022-03-26 21:12:00
  2 | name          | varchar |        2 |         |         0 |           0 | pkdb_table |         1 | 2022-03-26 21:12:00 | 2022-03-26 21:12:00
  3 | database_name | varchar |        2 |         |         0 |           0 | pkdb_table |         1 | 2022-03-26 21:12:00 | 2022-03-26 21:12:00
  4 | database_oid  | int     |        1 |         |         0 |           0 | pkdb_table |         1 | 2022-03-26 21:12:00 | 2022-03-26 21:12:00
  5 | create_time   | varchar |        2 |         |         0 |           0 | pkdb_table |         1 | 2022-03-26 21:12:00 | 2022-03-26 21:12:00
(5 rows)