aerospike_fdw/README at master · sanglijunfengDev/aerospike_fdw · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
Foreign Data Wrapper for AEROSPIKE_FDW
======================================

1. Installation
install aerospike server&client

https://github.com/aerospike/aerospike-server.git
https://github.com/aerospike/aerospike-client-c.git

aql> insert into test.demo(PK,a,b,c) values('key1',1,2,3);
OK, 1 record affected.

aql> select * from test.demo
+-----+-------+---+
| a   | b     | c |
+-----+-------+---+
| 1   | 2     | 3 |
+-----+-------+---+
1 rows in set (0.027 secs)

$ export PATH=/usr/local/pgsql/bin/:$PATH

make

make install

Submodules
The Aerospike_fdw  1 submodules:

lua-core      The Aerospike Core Lua Source Files

$ git submodule update --init

2.Usage

create extension aerospike_fdw;
create server as_server foreign data wrapper aerospike_fdw ;

create foreign table test_as(
a     bigint,
b     bigint,
c     bigint
)
server as_server
options(namespace 'test',set 'demo',key 'key1');

3.User conf parameter
default IP value is 127.0.0.1
aerospike.as_server_ip = 'aerospike server ip'

default PORT is 3000
aerospike.as_server_port= aerospike server port
shared_preload_libraries='/usr/local/psql/lib/postgresql/aerospike_fdw'


4.Add files
mkdir /home/pg/lua
cp lua-core /home/pg
chown -R postgres:postgres /home/pg