Search Postgresql Archives

RE: how to install pgcrypto

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi

 

From: Ze Victor Harry [mailto:assayabadi@xxxxxxxxx]
Sent: Freitag, 3. August 2018 10:54
To: pgsql-general@xxxxxxxxxxxxxx
Subject: how to install 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

 

With this command on the linux shell your run psql, which is the PostgreSQL client that always is shipped with the server.

In the psql shell you can then run the create extension command as below.

You may do this in PgAdmin (a graphical UI for Windows), too.

 

The whole point is that you must first log into the database as a superuser before you install the extension.

 

Hope this helps.

Bye

Charles

 

# 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 query tool? I need clearly articulated  steps

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux