Postgres Pro
Downloads
Home   >   mailing lists

Re: install pgcrypto module to existing postgreSQL - Mailing list pgsql-general

From Pavan Kumar
Subject Re: install pgcrypto module to existing postgreSQL
Date
Msg-id CA+M0sHHKhLj+t05DbyE32w0qf2AoUzBJqE28ZM21Q4orqK7H4w@mail.gmail.com
Whole thread Raw
In response to Re: install pgcrypto module to existing postgreSQL  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
Tree view
Ron, 

yes, Installed with source code. here is my postgres configuration 
BINDIR = /pgbin/11.2/bin
DOCDIR = /pgbin/11.2/share/doc/postgresql
HTMLDIR = /pgbin/11.2/share/doc/postgresql
INCLUDEDIR = /pgbin/11.2/include
PKGINCLUDEDIR = /pgbin/11.2/include/postgresql
INCLUDEDIR-SERVER = /pgbin/11.2/include/postgresql/server
LIBDIR = /pgbin/11.2/lib
PKGLIBDIR = /pgbin/11.2/lib/postgresql
LOCALEDIR = /pgbin/11.2/share/locale
MANDIR = /pgbin/11.2/share/man
SHAREDIR = /pgbin/11.2/share/postgresql
SYSCONFDIR = /pgbin/11.2/etc/postgresql
PGXS = /pgbin/11.2/lib/postgresql/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--prefix=/pgbin/11.2' '--with-segsize=32' '--with-pgport=5432'
CC = gcc
CPPFLAGS = -D_GNU_SOURCE
CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2
CFLAGS_SL = -fPIC
LDFLAGS = -Wl,--as-needed -Wl,-rpath,'/pgbin/11.2/lib',--enable-new-dtags
LDFLAGS_EX =
LDFLAGS_SL =
LIBS = -lpgcommon -lpgport -lpthread -lz -lreadline -lrt -lcrypt -ldl -lm
VERSION = PostgreSQL 11.2

On Tue, Sep 17, 2019 at 4:22 PM Ron <ronljohnsonjr@gmail.com> wrote:
IOW, you installed it from source instead of a package.

On 9/17/19 4:18 PM, Pavan Kumar wrote:
Hello Adrian,

i have used configure command install postgres 

  $ ./configure --prefix=/pgbin/11.2 --with-segsize=32 --with-pgport=5432

once configure is done, used make and make install to install postgres.



On Tue, Sep 17, 2019 at 4:06 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 9/17/19 1:25 PM, Pavan Kumar wrote:
> hello experts,
>
> i have Installed and created postgres 11.2 and created couple of

How did you install?

> database.  Now i got new requirement to encrypt data on  few tables. to 
> perform this application team is asking us to install pgcrypto module on
> postgres cluster.
> what is the way to install pgcrypt library ?
>
> please advise

--
Angular momentum makes the world go 'round.


--
Regards,

#!  Pavan Kumar
-----------------------------------------------
Sr. Database Administrator..!
NEXT GENERATION PROFESSIONALS, LLC
Cell    #  267-799-3182 #  pavan.dba27 (Gtalk)  
India   # 9000459083

Take Risks; if you win, you will be very happy. If you lose you will be Wise  

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: install pgcrypto module to existing postgreSQL
Next
From: Andreas Joseph Krogh
Date:
Subject: Re: PostgreSQL License