Posted at

Postgres remote db

More than 1 year has passed since last update.

# yum install postgresql94-server postgresql94-contrib

Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
* base: ftp.iij.ad.jp
* epel: ftp.riken.jp
* epel-debuginfo: ftp.riken.jp
* epel-source: ftp.riken.jp
* extras: ftp.iij.ad.jp
* updates: ftp.iij.ad.jp
Package postgresql94-server-9.4.11-2PGDG.rhel7.x86_64 already installed and latest version
Resolving Dependencies
--> Running transaction check
---> Package postgresql94-contrib.x86_64 0:9.4.11-2PGDG.rhel7 will be installed
--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.22)(64bit) for package: postgresql94-contrib-9.4.11-2PGDG.rhel7.x86_64
--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.18)(64bit) for package: postgresql94-contrib-9.4.11-2PGDG.rhel7.x86_64
--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.11)(64bit) for package: postgresql94-contrib-9.4.11-2PGDG.rhel7.x86_64
--> Processing Dependency: libxslt.so.1()(64bit) for package: postgresql94-contrib-9.4.11-2PGDG.rhel7.x86_64
--> Running transaction check
---> Package libxslt.x86_64 0:1.1.28-5.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=====================================================================================================================================================================
Package Arch Version Repository Size
=====================================================================================================================================================================
Installing:
postgresql94-contrib x86_64 9.4.11-2PGDG.rhel7 pgdg94 616 k
Installing for dependencies:
libxslt x86_64 1.1.28-5.el7 base 242 k

Transaction Summary
=====================================================================================================================================================================
Install 1 Package (+1 Dependent package)

Total download size: 858 k
Installed size: 2.6 M
Is this ok [y/d/N]: y
Downloading packages:
(1/2): libxslt-1.1.28-5.el7.x86_64.rpm | 242 kB 00:00:00
(2/2): postgresql94-contrib-9.4.11-2PGDG.rhel7.x86_64.rpm | 616 kB 00:00:02
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 411 kB/s | 858 kB 00:00:02
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : libxslt-1.1.28-5.el7.x86_64 1/2
Installing : postgresql94-contrib-9.4.11-2PGDG.rhel7.x86_64 2/2
Verifying : postgresql94-contrib-9.4.11-2PGDG.rhel7.x86_64 1/2
Verifying : libxslt-1.1.28-5.el7.x86_64 2/2

Installed:
postgresql94-contrib.x86_64 0:9.4.11-2PGDG.rhel7

Dependency Installed:
libxslt.x86_64 0:1.1.28-5.el7

Complete!

-bash-4.2$ psql postgres

psql (9.4.11)
Type "help" for help.

postgres=# create extension postgres_fdw;
CREATE EXTENSION
postgres=#