Im now working on PostgreSQL on EL6
|
1 2 3 4 5 6 7 8 |
[suse@work 1]$ rpm -qa| grep postgre postgresql94-devel-9.4.4-1PGDG.rhel6.x86_64 postgresql94-server-9.4.4-1PGDG.rhel6.x86_64 postgresql94-libs-9.4.4-1PGDG.rhel6.x86_64 postgresql94-9.4.4-1PGDG.rhel6.x86_64 Repo is: pgdg-centos94-9.4-1.noarch |
Im tring to create extension pgcrypto to store passwd.
failed. with following message
|
1 2 3 4 5 |
warehouse_db=# create extension pgcrypto; ERROR: could not open extension control file \ "/usr/pgsql-9.4/share/extension/pgcrypto.control": \ No such file or directory |
the fix is to reinstall postgresql94-contrib
|
1 |
#yum install postgresql94-contrib... |
Package postgresql94-contrib.x86_64 0:9.4.4-1PGDG.rhel6 will be installed