how to install pgcrypto

Hi

From: Ze Victor Harry [mailto:assayabadi@gmail.com]
Sent: Freitag, 3. August 2018 10:54
To: pgsql-general@postgresql.org
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

<https://stackoverflow.com/questions/45408745/when-i-give-ant-fresh-install-it-gives-error-postgresql-pgcrypto-extension-ins&gt; 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 <http://commands.is/&gt; commands.is it from cmd? or in pgadmin query tool? I need clearly articulated steps

The psql command is a client - an "interactive terminal". It provides a
command-line version of pgAdmin.

See here for other client applications:

https://www.postgresql.org/docs/10/static/reference-client.html

The "create extension..." command is one that you give to either psql or
pgAdmin; they execute it against the current database.

Tim Clarke

Show quoted text

On 03/08/18 09:53, Ze Victor Harry wrote:

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
<http://commands.is/&gt; it from cmd? or in pgadmin query tool? I need
clearly articulated  steps

CCing list.

From: Charles Clavadetscher [mailto:clavadetscher@swisspug.org]
Sent: Freitag, 3. August 2018 17:20
To: 'Ze Victor Harry' <assayabadi@gmail.com>
Subject: RE: how to install pgcrypto

Hi

From: Ze Victor Harry [mailto:assayabadi@gmail.com]
Sent: Freitag, 3. August 2018 17:11
To: Charles Clavadetscher <clavadetscher@swisspug.org <mailto:clavadetscher@swisspug.org> >
Subject: Re: how to install pgcrypto

hello again Charles Clavadetscher

how many hours does it take to complete ant fresh_install

it has been 4 hrs since i have started it but it is still not finished.I am using fast broadband internet(25 MB/s).is something wrong or is usually like that?

Well, to install PostgreSQL itself goes quickly. I can’t tell you exactly how long, but it is a matter of minutes.

In the screenshot that you sent, it looks like you are downloading a file, probably with data used by the appication installed in c:\dspace\webapps.

I assume that this is what is taking time, depending on how big the data is.

You may ask the developers of the web application on that. This is hardly a database question.

BTW: do not top post when responding on the list and, since you are starting a new topic (the pgcrypto installation of the subject is solved), you should start a new thread, so that other people may look at it.

Regards

Charles

On Fri, Aug 3, 2018 at 2:19 PM, Charles Clavadetscher <clavadetscher@swisspug.org <mailto:clavadetscher@swisspug.org> > wrote:

Hi

From: Ze Victor Harry [mailto:assayabadi@gmail.com <mailto:assayabadi@gmail.com> ]
Sent: Freitag, 3. August 2018 12:53
To: Charles Clavadetscher <clavadetscher@swisspug.org <mailto:clavadetscher@swisspug.org> >
Subject: Re: how to install pgcrypto

Thanx Charles Clavadetsche

I am installing dspace in windows 10 and I created the extension by going to OBJECT->CREATE->EXTENSION and created pgcrypto successfully that is what I have been asking and it is working fine. am I welcome to ask further questions on the installation though i am new to this kind of installation?

Of course. That’s the reason of existence of this mailing list.

On Fri, Aug 3, 2018 at 12:21 PM, Charles Clavadetscher <clavadetscher@swisspug.org <mailto:clavadetscher@swisspug.org> > wrote:

Hi

From: Ze Victor Harry [mailto:assayabadi@gmail.com <mailto:assayabadi@gmail.com> ]
Sent: Freitag, 3. August 2018 10:54
To: pgsql-general@postgresql.org <mailto:pgsql-general@postgresql.org>
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

<https://stackoverflow.com/questions/45408745/when-i-give-ant-fresh-install-it-gives-error-postgresql-pgcrypto-extension-ins&gt; 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 <http://commands.is/&gt; commands.is it from cmd? or in pgadmin query tool? I need clearly articulated steps