Solved

Problem for use chkpass

Posted on 2012-04-09
3
1,003 Views
Last Modified: 2012-04-10
I have postgres 9.0  on Centos 6.2 64 bit , I  am trying create table using chkpass but give follow  error message

postgres=# create table test (p chkpass);
ERROR:  type "chkpass" does not exist
LINE 1: create table test (p chkpass);
                             ^

I have installed postgresql90-contrib the library chkpass was installed with sucess .

rpm -ql postgresql90-contrib |grep ch
/usr/pgsql-9.0/bin/pg_archivecleanup
/usr/pgsql-9.0/bin/pgbench
/usr/pgsql-9.0/lib/chkpass.so
/usr/pgsql-9.0/lib/fuzzystrmatch.so
/usr/pgsql-9.0/lib/passwordcheck.so
/usr/pgsql-9.0/lib/pg_buffercache.so
/usr/pgsql-9.0/share/contrib/chkpass.sql
/usr/pgsql-9.0/share/contrib/fuzzystrmatch.sql
/usr/pgsql-9.0/share/contrib/pg_buffercache.sql
/usr/pgsql-9.0/share/contrib/tsearch2.sql
/usr/pgsql-9.0/share/contrib/uninstall_chkpass.sql
/usr/pgsql-9.0/share/contrib/uninstall_fuzzystrmatch.sql
/usr/pgsql-9.0/share/contrib/uninstall_pg_buffercache.sql
/usr/pgsql-9.0/share/contrib/uninstall_tsearch2.sql


Thanks
0
Comment
Question by:aspenbr
  • 2
3 Comments
 
LVL 22

Accepted Solution

by:
earth man2 earned 355 total points
ID: 37827613
Have you run the chkpass.sql script?
0
 
LVL 1

Author Comment

by:aspenbr
ID: 37827914
No, why ?
0
 
LVL 1

Author Closing Comment

by:aspenbr
ID: 37829579
Thank very much earthman2,

I  follown the process in this http://wiki.postgresql.org/wiki/Module_Manager
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Little introduction about CP: CP is a command on linux that use to copy files and folder from one location to another location. Example usage of CP as follow: cp /myfoder /pathto/destination/folder/ cp abc.tar.gz /pathto/destination/folder/ab…
It’s 2016. Password authentication should be dead — or at least close to dying. But, unfortunately, it has not traversed Quagga stage yet. Using password authentication is like laundering hotel guest linens with a washboard — it’s Passé.
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question