Re: Specific objects backup in PostgreSQL

2024-07-10 Thread nikhil kumar
Thank you everyone for your help On Thu, 11 Jul, 2024, 1:34 am Anthony Sotolongo, wrote: > Hi Nikhil, maybe you can apply some tricks playing with pg_dump -s and > pg_restore --list > > > check this link: https://stackoverflow.com/a/13758324/8308381 > > > Regards >

Specific objects backup in PostgreSQL

2024-07-10 Thread nikhil kumar
Dear Team, We received a request from client. They required all functions, stored procedures and triggers backup. can anyone please let me know. How to take backup only above objects. Thanks & Regards, Nikhil, PostgreSQL DBA.

Re: Need help on configuration SMTP

2024-06-12 Thread nikhil kumar
Thank you I’ll check it out. On Wed, 12 Jun 2024 at 5:55 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wednesday, June 12, 2024, nikhil kumar wrote: > >> >> Can anyone please help on SMTP configuration for send gmail. If any >> document please

Need help on configuration SMTP

2024-06-12 Thread nikhil kumar
Hi Team, Can anyone please help on SMTP configuration for send gmail. If any document please let me know. Thanks & Regards, Nikhil, Postgresql DBA, 8074430856.

Re: Postgresql initialize error

2024-06-11 Thread nikhil kumar
As I check we have OpenSSL package in that server but that file is not visible On Wed, 12 Jun 2024 at 1:35 AM, nikhil kumar wrote: > Thanks for your support. I’ll check it > > On Wed, 12 Jun 2024 at 1:34 AM, Muhammad Salahuddin Manzoor < > salahuddi...@bitnine.net> wro

Re: Postgresql initialize error

2024-06-11 Thread nikhil kumar
Find library > sudo find / -name libssl.so.1.1 > > Add in Library path > export LD_LIBRARY_PATH=/path/to/libssl:$LD_LIBRARY_PATH > > *Salahuddin (살라후딘**)* > > > > On Wed, 12 Jun 2024 at 00:59, nikhil kumar wrote: > >> Error ; ./ initdbs error while loadin

Re: Postgresql initialize error

2024-06-11 Thread nikhil kumar
Error ; ./ initdbs error while loading shared libraries: libssl.so.1.1: cannot open shared object file: No such file or directory On Wed, 12 Jun 2024 at 1:28 AM, nikhil kumar wrote: > Hi Team, > > I'm installing postgresql 14 version by using Rpm. However i'm getting &g

Postgresql initialize error

2024-06-11 Thread nikhil kumar
Hi Team, I'm installing postgresql 14 version by using Rpm. However i'm getting error while execute the database initialzation. Please check below error message Error; Hi Team, I'm installing postgresql 14 version by using Rpm. However i'm getting error while execute the database initialzation.