KOSC Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
===== Подключение из PostgreSQL к Greenplum ======

<code>
[keremet@sl10 postgresql]$ psql
psql (17.0)
Введите "help", чтобы получить справку.

postgres=# select version();
                                                              version                                                              
-----------------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 17.0 on x86_64-pc-linux-gnu, compiled by x86_64-alt-linux-gcc (GCC) 10.3.1 20210703 (ALT Sisyphus 10.3.1-alt2), 64-bit
(1 строка)

postgres=# CREATE EXTENSION postgres_fdw;
CREATE EXTENSION
postgres=# CREATE SERVER gpdb
postgres-#   FOREIGN DATA WRAPPER postgres_fdw
postgres-#   OPTIONS (dbname 'postgres', host 'localhost', port '6000');
CREATE SERVER

postgres=# CREATE EXTENSION dblink;
CREATE EXTENSION
postgres=# CREATE USER MAPPING FOR keremet SERVER gpdb OPTIONS (user 'keremet');
CREATE USER MAPPING
postgres=# SELECT dblink_connect('myconn', 'gpdb');
 dblink_connect 
----------------
 OK
(1 строка)

postgres=# SELECT * FROM dblink('myconn', 'SELECT version()') AS t(version text);
                                                                                                                                version                                                                            
                                                     
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------
 PostgreSQL 9.4.26 (Greenplum Database 6.27.1_arenadata57+dev.48.g431a01f4394 build dev) on x86_64-unknown-linux-gnu, compiled by x86_64-alt-linux-gcc (GCC) 10.3.1 20210703 (ALT Sisyphus 10.3.1-alt2), 64-bit com
piled on Nov 15 2024 22:29:06 (with assert checking)
(1 строка)

postgres=#
</code>