Re: i am getting issue as FATAL: password authentication failed for user ' postgres' tried

2020-06-18 Thread o1bigtenor
On Wed, Jun 17, 2020 at 9:14 PM prachi surangalikar wrote: > > hello team, > i have tried every thing but still i could not find the solution to this > problem. > i made changes in the pg_hba.conf file also , please help me to solve this > problem. As a noob to programming and under the ho

Re: Application Level Encryption

2020-07-05 Thread o1bigtenor
On Sun, Jul 5, 2020 at 1:22 AM Zahir Lalani wrote: > Hello > > > > Does anyone have any serious experience of implementing app level > encryption with strong key management? > > > > If so would like to arrange an offline chat please > Others might be interested as well. Might be useful to have s

Re: SSL between Primary and Seconday PostgreSQL DBs

2020-09-03 Thread o1bigtenor
On Thu, Sep 3, 2020 at 5:54 AM Susan Joseph wrote: > > OK, I understand I was just hoping someone could confirm that my settings are > correct. > I didn't come across an error so everything seems to be working I just can't > verify that SSL is working. > Are there any commands you can run to ver

Re: Accounting for between table correlation

2021-01-15 Thread o1bigtenor
On Fri, Jan 15, 2021 at 9:29 AM Atul Kumar wrote: > > Hi Alexander, > > As per Ron, you are not supposed to ask your questions here. > > As According to him, we should keep on doing research on internet rather than > asking for support directly even you have done enough research and until > unle

Re: pgBackRest for a 50 TB database

2023-08-27 Thread o1bigtenor
On Sun, Aug 27, 2023 at 10:57 AM Abhishek Bhola wrote: > > Hi > > I am trying to use pgBackRest for all my Postgres servers. I have tested it > on a sample database and it works fine. But my concern is for some of the > bigger DB clusters, the largest one being 50TB and growing by about 200-300G

Re: Regarding use case of epoch to generate nanoseconds precision

2024-05-22 Thread o1bigtenor
On Wed, May 22, 2024 at 4:21 AM Durgamahesh Manne wrote: > Hi > > Postgres supports only upto microseconds (6 decimal precision). > How do we generate timestamp with nanoseconds as rds postgres not > supported timestamp9 extension ? > Is there a way to generate timestamp with nanoseconds precisio

2FA - - - was Re: Password complexity/history - credcheck?

2024-06-24 Thread o1bigtenor
On Sun, Jun 23, 2024 at 10:10 AM Greg Sabino Mullane wrote: > On Sun, Jun 23, 2024 at 5:30 AM Martin Goodson > wrote: > >> I believe that our security team is getting most of this from our >> auditors, who seem convinced that minimal complexity, password history >> etc are the way to go despite

Re: How to validate restore of backup?

2024-08-22 Thread o1bigtenor
On Thu, Aug 22, 2024 at 6:24 AM Ron Johnson wrote: > That's great on small databases. Not so practical when they're big. > > So - - - - what is the recommended procedure for 'large' databases? (Might be useful to have a definition for what a large database is as well.) Regards

Re: How to validate restore of backup?

2024-08-22 Thread o1bigtenor
On Thu, Aug 22, 2024 at 8:03 AM Ron Johnson wrote: > On Thu, Aug 22, 2024 at 8:49 AM o1bigtenor wrote: > >> >> >> On Thu, Aug 22, 2024 at 6:24 AM Ron Johnson >> wrote: >> >>> That's great on small databases. Not so practical when they&

Re: PostgreSQL reference coffee mug

2021-08-07 Thread o1bigtenor
On Sat, Aug 7, 2021 at 2:48 PM Jehan-Guillaume de Rorthais wrote: > On Sat, 7 Aug 2021 20:44:41 +0200 > Matthias Apitz wrote: > > > El día sábado, agosto 07, 2021 a las 08:06:14p. m. +0200, Karsten Hilbert > > escribió: > > > > > Am Fri, Aug 06, 2021 at 08:09:03PM +0200 schrieb Matthias Apitz: >

Re: Postgresql + containerization possible use case

2021-12-10 Thread o1bigtenor
On Fri, Dec 10, 2021 at 3:24 AM Achilleas Mantzios < ach...@matrix.gatewaynet.com> wrote: > Hi > we are running some 140 remote servers (in the 7 seas via satellite > connections), and in each one of them we run: > - jboss > - postgresql > - uucp (not as a daemon) > - gpsd > - samba > - and possib

Re: Postgresql + containerization possible use case

2021-12-10 Thread o1bigtenor
On Fri, Dec 10, 2021 at 6:02 AM Achilleas Mantzios < ach...@matrix.gatewaynet.com> wrote: > On 10/12/21 1:24 μ.μ., o1bigtenor wrote: > > > > On Fri, Dec 10, 2021 at 3:24 AM Achilleas Mantzios < > ach...@matrix.gatewaynet.com> wrote: > >> Hi >> we are r

Re: Can we get the CTID value

2022-01-20 Thread o1bigtenor
On Wed, Jan 19, 2022 at 1:39 PM Garfield Lewis wrote: > > Hi, > > > > I am creating a new type and would like to know if it was possible to access > the CTID for the row affected by the INPUT and RECEIVE functions of the new > type? Actually, would it be possible from the OUTPUT and SEND functio

Re: Corruption of few tables

2025-02-25 Thread o1bigtenor
On Tue, Feb 25, 2025 at 6:03 AM sivapostg...@yahoo.com wrote: > > Hello, > > Using PostgreSQL 11.11, compiled by Visual C++ build 1914, 64-bit with > Powerbuilder > > Recently, in one of our customers' places, we got an error while saving a > record from our custom-built application using Power