Re: install pgcrypto module to existing postgreSQL

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(at)gmail(dot)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(dot)klaver(at)aklaver(dot)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 *