LoginSignup
0
0

More than 5 years have passed since last update.

Postgres remote db

Posted at
# 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=# 
0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0