Thread: install pgcrypto module to existing postgreSQL

install pgcrypto module to existing postgreSQL

From

Pavan Kumar

Date:

17 September 2019, 23:25:20

hello experts,

i have Installed and created postgres 11.2 and created couple of 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

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

Re: install pgcrypto module to existing postgreSQL

From

Adrian Klaver

Date:

18 September 2019, 00:06:22

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
> 
> -- 
> *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 *
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

Re: install pgcrypto module to existing postgreSQL

From

Pavan Kumar

Date:

18 September 2019, 00:18:45

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
>
> --
> *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 *
>

--
Adrian Klaver
adrian.klaver@aklaver.com

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

Re: install pgcrypto module to existing postgreSQL

From

Adrian Klaver

Date:

18 September 2019, 00:21:13

On 9/17/19 2: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.

Full instructions are here at bottom:
https://www.postgresql.org/docs/11/contrib.html

> 
> 
> 
> On Tue, Sep 17, 2019 at 4:06 PM Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto: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
>      >
>      > --
>      > *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 *
>      >
> 
> 
>     -- 
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 
> 
> 
> -- 
> *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 *
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

Re: install pgcrypto module to existing postgreSQL

From

Ron

Date:

18 September 2019, 00:22:01

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.

Re: install pgcrypto module to existing postgreSQL

From

Pavan Kumar

Date:

18 September 2019, 00:23:31

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

Re: install pgcrypto module to existing postgreSQL

From

Luca Ferrari

Date:

18 September 2019, 11:36:31

On Tue, Sep 17, 2019 at 11:19 PM Pavan Kumar <pavan.dba27@gmail.com> wrote:
> once configure is done, used make and make install to install postgres.

cd contrib && make && make install
that should work.

Luca