install pgcrypto module to existing postgreSQL
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 *
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
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 *
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
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
<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 pgcryptomodule on
postgres cluster.
what is the way to install pgcrypt library ?please advise
--
Angular momentum makes the world go 'round.
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 *
