Skip to content
Newer
Older
100644 38 lines (26 sloc) 1.19 KB
ee5b25a @umitanuki Initial version.
authored Sep 3, 2011
1 s3\_fdw
2 =======
3
4 s3\_fdw provides a foreign-data wrapper (FDW) for Amazon S3 files,
5 using the builtin COPY format.
6
7 To build it, just do this:
8
9 make
10 make install
11
12 If you encounter an error such as:
13
14 make: pg_config: Command not found
15
16 Be sure that you have `pg_config` installed and in your path. If you used a
17 package management system such as RPM to install PostgreSQL, be sure that the
18 `-devel` package is also installed. If necessary tell the build process where
19 to find it:
20
21 env PG_CONFIG=/path/to/pg_config make && make installcheck && make install
22
23 Once `make install` is done, connect to your database with psql or other client
24 and type
25
26 CREATE EXTENSION s3_fdw;
27
28 then you'll see the FDW is installed. With the FDW, create server, user mapping,
29 foreign table. You'll need Amazon S3 access key ID and secret access key to
30 authenticate private access to your data. Consult AWS documentation for those keys.
31 The access information is stored in user mapping. Foreign tables stores options
32 for COPY as well as hostname, bucketname and filename.
33
34 Dependencies
35 ------------
36 The `s3_fdw` data type depends on libcurl and openssl. You need those developer
37 packages installed in the system path.
Something went wrong with that request. Please try again.