Re: pldbgapi extension

I installed devel and contrib also but not worked here. Regards, Prakash.R On Tue, Sep 17, 2019, 19:58 Adrian Klaver wrote: > On 9/17/19 7:20 AM, Prakash Ramakrishnan wrote: > > Hi Adrian, > > > > I did it yum installation postgresql 11 from repo file.but I don'

Re: pldbgapi extension

Hi Adrian, I did it yum installation postgresql 11 from repo file.but I don't know why it's giving wrong path and symbolic link how to create it please advise. Regards, Prakash.R On Tue, Sep 17, 2019, 19:10 Adrian Klaver wrote: > On 9/16/19 11:51 PM, Prakash Ramakrishnan wrote

pldbgapi extension

Hi Team, Not able to create the extension pldbgapi in cluster and if i run make and make install it will going .sql file in /usr/share/pgsql/extension this path but actually i need to create these files into below path, How to create this one please advise ==> psql psql (11.5) Type "help" for

Re: pgrounting extension in 11

Thanks, I'll check it out. On Tue, Sep 10, 2019, 19:49 Adrian Klaver wrote: > On 9/10/19 6:53 AM, Prakash Ramakrishnan wrote: > > Hi Adrian, > > > > I have only these files in pgdg, > > That is something you will need to take up with the PGDG RH package

Re: pgrounting extension in 11

On Tue, Sep 10, 2019, 19:16 Adrian Klaver wrote: > On 9/10/19 5:59 AM, Prakash Ramakrishnan wrote: > > Hi Team, > > > > Anyone help me to solve the below issue not able to create the pgrouting > > extension 11 version in rhel 6.9 OS, > > What repo's are you

pgrounting extension in 11

Hi Team, Anyone help me to solve the below issue not able to create the pgrouting extension 11 version in rhel 6.9 OS, [root@hkgrhepdbp001 ~]# yum install pgrouting_11 Loaded plugins: enabled_repos_upload, package_upload, product-id, rhnplugin, search-disabled-repos, security, subscription-manag

Re:

Thanks a lot. I will check and let you know. Regards, Prakash.R On Tue, Jul 2, 2019 at 1:15 PM Laurenz Albe wrote: > On Tue, 2019-07-02 at 13:09 +0530, Prakash Ramakrishnan wrote: > > We are getting below error while during import the csv file please do > the needful. > > I

[no subject]

Hi Team, We are getting below error while during import the csv file please do the needful. CREATE TABLE ujshjk ( pod_id bigint NOT NULL, src_id smallint, eff_strt_dt date,eff_end_dt date,ins_dt timestamp without time zone,updt_dt timestamp without time zone,nat_key_1 character(50),nat_key_2 char

Re: restore error

Thanks, I'll check it out. Regards, Prakash.R On Tue, Jul 2, 2019 at 1:05 PM Laurenz Albe wrote: > Prakash Ramakrishnan wrote: > > While restoring the database using psql getting below error any idea > about this? > > > > psql:AICH01PR.sql:641367264: ERROR:

restore error

Hi Team, While restoring the database using psql getting below error any idea about this? psql:AICH01PR.sql:641367264: ERROR: connection for foreign table "mf_adm_spotservicefiles" cannot be established DETAIL: ORA-12170: TNS:Connect timeout occurred -- Thanks, Prakash.R

Re: patch 11.2 to 11.4

Thanks lot it's working fine now. Regards, Prakash.R On Fri, Jun 28, 2019, 17:46 Fabrízio de Royes Mello wrote: > > Em qui, 27 de jun de 2019 às 22:01, Prakash Ramakrishnan < > prakash.ramakrishnan...@nielsen.com> escreveu: > >> Hi Fabrizo, >> >> After

Re: patch 11.2 to 11.4

version - PostgreSQL 11.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-36), 64-bit (1 row) Please do the needful. On Thu, Jun 27, 2019 at 7:08 PM Prakash Ramakrishnan < prak

Re: patch 11.2 to 11.4

Thanks for your support. On Thu, Jun 27, 2019, 18:58 Fabrízio de Royes Mello wrote: > > Em qui, 27 de jun de 2019 às 05:35, Prakash Ramakrishnan < > prakash.ramakrishnan...@nielsen.com> escreveu: > >> Hi Team, >> >> I done the installation using yum poostgres

patch 11.2 to 11.4

Hi Team, I done the installation using yum poostgresql 11 server method now i need to update or apply the patch using repo file how to do this 11.2 to 11.4 please share me the steps . -- Thanks, Prakash.R

minor upgrade

Hi Team, I had an one small issue i did the installation 11.2 using pgdg repo file in production server now how can i update or upgrade the 11.4 version please do the needfull? -- Thanks, Prakash.R

perl extension error

Hi Team, We have using PostgreSQL 11 in one production server and while creating extension getting below error,please do the needful, A4.Italy_UAT=# A4.Italy_UAT=# Create extension plperl; ERROR: could not open extension control file "/usr/pgsql-11/share/extension/plperl.control": No such file o

Re: pg_repack issue

Sathish Kumar wrote: > Hi Prakash, > > You can see all the available options from here. > > http://reorg.github.io/pg_repack/#installation > > On Wed, Jun 5, 2019, 8:48 PM Prakash Ramakrishnan < > prakash.ramakrishnan...@nielsen.com> wrote: > >> Hi Sathish,

Re: pg_repack issue

; You can run below command. > > pg_repack -d dbname -E DEBUG > > > On Wed, Jun 5, 2019, 7:55 PM Prakash Ramakrishnan < > prakash.ramakrishnan...@nielsen.com> wrote: > >> Hi Peter, >> >> Thanks i have successfully created the extension how to use full

Re: pg_repack issue

Hi Peter, Thanks i have successfully created the extension how to use full vacuum using pg_repack. Regards, Prakash.R On Wed, Jun 5, 2019 at 5:23 PM Peter Eisentraut < peter.eisentr...@2ndquadrant.com> wrote: > On 2019-06-05 12:48, Prakash Ramakrishnan wrote: > > gcc -Wall -Wmis

pg_repack issue

Hi Team, While during the pg_repack installation getting below error please someone help postg...@brurhen001.enterprisenet.org: /home/postgres/software/pg_repack-1.4.4 ==> ll total 16 drwx--. 3 postgres postgres 71 Oct 18 2018 bin -rw---. 1 postgres postgres 1662 Oct 18 2018 COPYRIGHT

Re: pldbgapi error

Hi Ian, Thanks for replying can you please help me to solve this problem which code will be support for postgresql 11 can you please share me the link or file. Regards, Prakash.R On Mon, May 20, 2019 at 5:25 PM Ian Barwick wrote: > On 5/20/19 7:07 PM, Prakash Ramakrishnan wrote:> H

pldbgapi error

Hi Team, We are trying to install the pldbgapi extension in postgresql 11.3 server but we getting below error,Please do the needful, ==> make USE_PGXS=1 gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-st

Re: perl path issue

Hi Adrian, I don't much about pgbackrest i think it will take backup from archives Now only one the issue means perl cant load. Regards, Prakash.R On Tue, May 14, 2019 at 8:15 PM Adrian Klaver wrote: > On 5/14/19 7:40 AM, Prakash Ramakrishnan wrote: > > Hi Adrian, >

Re: perl path issue

, May 14, 2019 at 8:01 PM Adrian Klaver wrote: > On 5/14/19 7:28 AM, Prakash Ramakrishnan wrote: > > Yes, that is correct. > > How about graphical layout of your backup/restore procedure? > > > > > On Tue, May 14, 2019 at 7:54 PM Adrian Klaver > <mail

Re: perl path issue

Yes, that is correct. On Tue, May 14, 2019 at 7:54 PM Adrian Klaver wrote: > On 5/14/19 2:51 AM, Prakash Ramakrishnan wrote: > > Hi Ravi, > > > > Not , am saying we have the daily backup and full backup in prod server > > only and there is one database like a4 the

Re: perl path issue

Hi Ravi, Not , am saying we have the daily backup and full backup in prod server only and there is one database like a4 the db size is 1.5TB. so am not restore again in prod . Am taking directly single backup restore in dev its means in dev server only restore the database in new cluster. existing

Re: perl path issue

ath=/pgBACKUP/A4_sydcosafpp001/backup/A4_sydcosafpp001 [A4_sydcosafpp001] pg1-path=/Postgres/prakash_pgbackrest On Mon, May 13, 2019 at 10:54 PM Adrian Klaver wrote: > On 5/13/19 8:14 AM, Prakash Ramakrishnan wrote: > > Hi Ravi, > > > > I tried manually export the lib path mu

Re: perl path issue

Hi Ravi, I tried manually export the lib path multiple times not working. prod: ==> echo $LD_LIBRARY_PATH /usr/lib64/perl5/CORE:/opt/app/PostgreSQL/10/lib:/opt/edb/languagepack-10/Perl-5.24/lib/CORE:/opt/app/PostgreSQL/10/lib dev --- ==> echo $LD_LIBRARY_PATH /usr/lib/perl5/5.10.0/i386-linux-th

Re: perl path issue

libpcre.so.1 (0x7f5ec924b000) libfreebl3.so => /lib64/libfreebl3.so (0x7f5ec9048000) postg...@sydcosausd001.enterprisenet.org:/home/postgres On Mon, May 13, 2019 at 8:04 PM Adrian Klaver wrote: > On 5/13/19 7:03 AM, Prakash Ramakrishnan wrote: > > Hi

Re: perl path issue

n Klaver wrote: > On 5/13/19 2:20 AM, Prakash Ramakrishnan wrote: > > Hi Adrian, > > > > Yes am using edb standard edition and installed pgbackrest in prod and > dev. > > To be clear your have on the prod server: > > 1) Postgres installed via EDB installer. >

Re: perl path issue

Hi Ravi, Please find the below details, Dev: ==> echo $LD_LIBRARY_PATH /usr/lib/perl5/5.10.0/i386-linux-thread-multi/CORE:/opt/rh/rh-perl526/root/usr/lib64:/usr/lib64/perl5/CORE:/opt/edb/languagepack-10/Perl-5.24/lib/CORE postg...@sydcosausd001.enterprisenet.org:/home/postgres Prod: ==

Re: perl path issue

Hi Ravi, Path is there , ==> ls /usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so /usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so postg...@sydcosausd001.enterprisenet.org:/home/postgres and perl DBD also installed but it cant load that is the issue please advise me. Regards, Prakash.R On Mon, Ma

Re: perl path issue

/Pg/Pg.so\...') called at /usr/share/perl5/vendor_perl/Carp.pm line 100 May be above path is corrupt or something issue not able to load the path. Regards, Prakash.R On Sat, May 11, 2019 at 7:18 PM Adrian Klaver wrote: > On 5/10/19 6:49 PM, Prakash Ramakrishnan wrote: > > Hi Adria

Re: perl path issue

krest. On Fri, May 10, 2019 at 9:44 PM Adrian Klaver wrote: > On 5/10/19 7:50 AM, Prakash Ramakrishnan wrote: > > Hi Adrian, > > > > Production backup working fine now and previously dev server also > > working fine. > > > > Now the business team wants to re

Re: perl path issue

osafpp001/backup/A4_sydcosafpp001* *[A4_sydcosafpp001]* *pg1-path=/Postgres/prakash_pgbackrest* postg...@sydcosausd001.enterprisenet.org:/home/postgres On Fri, May 10, 2019 at 8:15 PM Adrian Klaver wrote: > On 5/10/19 7:36 AM, Prakash Ramakrishnan wrote: > > Hi Adrian, > > > &

Re: perl path issue

sr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so* /usr/local/lib64/perl5/auto/DBD/Pg/Pg.so On Fri, May 10, 2019 at 7:54 PM Adrian Klaver wrote: > On 5/10/19 2:24 AM, Prakash Ramakrishnan wrote: > > Hi Adrian, > > > > Some perl path is not working here please find the below details

Re: perl path issue

e 286 pgBackRest::Main::main('remote') called at (eval 269) line 1 eval '($iResult, $bErrorC, $strMessage) = pgBackRest::Main::main(\'remote\') ;' called at /usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 0 Compilation failed in require at /l

Re: perl path issue

esult, $bErrorC, $strMessage) = pgBackRest::Main::main(\'remote\') ;' called at /usr/lib64/perl5/vendor_perl/DBD/Pg.pm line 0 can you please help this we are struggling to solve the issue, Regards, Prakash.R On Thu, May 9, 2019 at 10:58 PM Adrian Klaver wrote: > On

Re: perl path issue

Hi David, I did the installation for using postgresql 10.4 version edb standard edition.so again need to run the yum command or please advise me . Regards, Prakash.R On Thu, May 9, 2019, 22:24 David Steele wrote: > On 5/9/19 12:51 PM, Prakash Ramakrishnan wrote: > > Hi Adrian,

Re: perl path issue

Hi Adrian, I don't know about that client libraries can you please explain or share me the command I will show you the output and we need the solution for this pgbackrest issue . Regards, Prakash.R On Thu, May 9, 2019, 22:07 Adrian Klaver wrote: > On 5/9/19 8:12 AM, Prakash Rama

Re: perl path issue

: postgres@pts/0 On Thu, May 9, 2019 at 8:38 PM David Steele wrote: > On 5/9/19 10:57 AM, Prakash Ramakrishnan wrote: > > > > David am trying to restore the backup in dev server please find the > > below details , > > libpq should be installed with Postgres. Have

Re: perl path issue

/usr /share/perl5/vendor_perl/Carp.pm line 100 Carp::croak('Can't load '/usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so...') called at /usr/lib64/perl5/Dy naLoader.pm line 98 DynaLoader::croak('Can't load '/usr/lib64/perl5/vendor_perl/auto/DBD/Pg/Pg.so...') calle

perl path issue

Hi Team, We having perl issue for while during restore operation for using pgbackrest backup tool can you please do the needful. 2019-05-08 18:42:09.415 P00 INFO: restore command begin 2.13: --db-include=A4_Copy --log-level-console=info --pg1-path=/Postgres/prakash_pgbackrest --process-max=2 --

orafce error

Hi Team, While am creating the orafce extension we are getting below error. ==> ll total 728 -rw-r--r--. 1 postgres postgres 7863 Mar 27 18:54 aggregate.c -rw-r--r--. 1 postgres postgres 21826 Mar 27 18:54 alert.c -rw-r--r--. 1 postgres postgres 9234 Mar 27 18:54 assert.c -rw-r--r--. 1 postg

upgrade issue 10 to 11

Hi Team, While using pg_upgrade 10 to 11 version we are getting below error.Please do the needful. postg...@hamrhenppp001.enterprisenet.org:/BACKUP/hamrhenppp001/upgrade_logs ==> /usr/pgsql-11/bin/pg_upgrade -d /DATA/data10 -D /DATA/data11 -b /opt/app/PostgreSQL/10/bin -B /usr/pgsql-11/bin -p 543

Re: os upgrade 7.3 to 7.5 (postgres version 10.5)

Thanks for the information. So we can upgrade the os right thomas On Thu, Apr 11, 2019, 09:39 Thomas Munro wrote: > On Thu, Apr 11, 2019 at 2:47 PM Prakash Ramakrishnan > wrote: > > We are planned to upgrade the os version rhel 7.3 to 7.5 and now > currently postgresql commu

os upgrade 7.3 to 7.5 (postgres version 10.5)

Hi Team, We are planned to upgrade the os version rhel 7.3 to 7.5 and now currently postgresql community version in 10.5 and there is some extensions working in database need your inputs if we upgrade the os mean it will impact anything in current settings and extensions please do the needful.Than

Re: plctl extension issue postgresql 11.2

Hi Christopher,Adrian,Tom Thanks for quick response finally i did the pltcl install extension activity done thanks for your support. Regards, Prakash.R On Fri, Mar 29, 2019 at 3:08 AM Christopher Browne wrote: > > > On Thu, 28 Mar 2019 at 17:11, Prakash Ramakrishnan < > praka

Re: plctl extension issue postgresql 11.2

*pltcl--1.0.sql* btree_gin--1.0--1.1.sql hstore_plperlu--1.0.sql pageinspect--unpackaged--1.0.sql * pltcl.control* btree_gin--1.0.sql hstore_plperlu.control pg_buffercache--1.0--1.1.sql * pltclu--1.0.sql* On Thu, Mar 28, 2019 at 9:09 PM Prakash R

Re: plctl extension issue postgresql 11.2

Thanks, I'll check it out. On Thu, Mar 28, 2019, 20:26 Tom Lane wrote: > Adrian Klaver writes: > > Still postgresql11-tcl is a valid package in the PGDG repos(it is for a > > Tcl client library). It is trying to find postgresql11-tcl in the RHEL > > repo not the PGDG repo. Yet packages have bee

Re: plctl extension issue postgresql 11.2

, subscription-manager On Wed, Mar 27, 2019 at 9:53 PM Adrian Klaver wrote: > On 3/27/19 8:32 AM, Prakash Ramakrishnan wrote: > > Hi Adrian, > > > > Sorry for the late reply please find the below details, > > Again I am not a RH user so take the following with that

Re: plctl extension issue postgresql 11.2

-1PGDG.rhel7 @pgdg11* *postgresql11-llvmjit.x86_64 11.2-1PGDG.rhel7 @pgdg11* *postgresql11-server.x86_6411.2-1PGDG.rhel7 @pgdg11* On Wed, Mar 27, 2019 at 7:39 PM Adrian Klaver wrote: > On 3/27/19 2:46 AM, Prakash Ramakrishnan wrote: > > Hi Adrian, > >

Re: plctl extension issue postgresql 11.2

.x86_64 postgresql11-server(x86-64) = 11.2-2PGDG.rhel7 is needed by postgresql11-pltcl-11.2-2PGDG.rhel7.x86_64 [root@ brurhenaaa001 postgres]# [root@ brurhenaaa001 postgres]# On Tue, Mar 26, 2019 at 11:26 PM Adrian Klaver wrote: > On 3/26/19 10:43 AM, Prakash Ramakrishnan wr

Re: plctl extension issue postgresql 11.2

Nope I tried that's command and getting above error control file missing. On Tue, Mar 26, 2019, 22:53 Adrian Klaver wrote: > On 3/26/19 8:56 AM, Prakash Ramakrishnan wrote: > > Hi Team, > > > > We are getting below error in production server please do the needful.

Re: plctl extension issue postgresql 11.2

I did postgres 11.2 version using yum option this file only Missing and using rhel 7.5 version. On Tue, Mar 26, 2019, 23:07 Adrian Klaver wrote: > On 3/26/19 10:32 AM, Prakash Ramakrishnan wrote: > > Nope I tried that's command and getting above error control file missing. > &g

plctl extension issue postgresql 11.2

Hi Team, We are getting below error in production server please do the needful. ==> psql psql (11.2) Type "help" for help. > AIBE01PR=# create extension plctl; > ERROR: could not open extension control file > "/usr/pgsql-11/share/extension/plctl.control": No such file or directory RHEL-7.5 --