how to enable pgcrypto

Started by Ze Victor Harryover 7 years ago2 messagesbugs
Jump to latest
#1Ze Victor Harry
assayabadi@gmail.com

hello again I have a small problem here can someone tell me briefly how to
do it? I am getting this error When i give ant fresh_install it gives error
PostgreSQL 'pgcrypto' extension installed /up to date? False (not
installed) Create extension pgcrypto
<https://stackoverflow.com/questions/45408745/when-i-give-ant-fresh-install-it-gives-error-postgresql-pgcrypto-extension-ins&gt;
.
I have tried to look up for solutions and they all say I have to run a
command
# Login to your "dspace" database as a superuser
psql --username=postgres dspace
# Enable the pgcrypto extension on this database
CREATE EXTENSION pgcrypto;
but where I got confused is from where do i run these commands.is it from
cmd? or in pgadmin sql? I need clearly articulated steps

#2周正中(德歌)
dege.zzz@alibaba-inc.com
In reply to: Ze Victor Harry (#1)
回复:how to enable pgcrypto

connect to database. run it like a sql.

------------------------------------------------------------------
发件人:Ze Victor Harry<assayabadi@gmail.com>
日 期:2018年08月03日 16:14:25
收件人:<pgsql-bugs@postgresql.org>
主 题:how to enable pgcrypto

hello again I have a small problem here can someone tell me briefly how to do it? I am getting this error When i give ant fresh_install it gives error PostgreSQL 'pgcrypto' extension installed /up to date? False (not installed) Create extension pgcrypto.
I have tried to look up for solutions and they all say I have to run a command
# Login to your "dspace" database as a superuser
psql --username=postgres dspace
# Enable the pgcrypto extension on this database
CREATE EXTENSION pgcrypto; but where I got confused is from where do i run these commands.is it from cmd? or in pgadmin sql? I need clearly articulated steps