pgBackRest for a 50 TB database

2023-08-27 Thread Abhishek Bhola
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-300GB a day. I plan to mount NAS storage on my DB server to store my bac

Re: pgBackRest for a 50 TB database

2023-08-27 Thread Stephen Frost
Greetings, * Abhishek Bhola (abhishek.bh...@japannext.co.jp) wrote: > 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-

Re: pgBackRest for a 50 TB database

2023-08-27 Thread Abhishek Bhola
Hi Stephen Thank you for the prompt response. Hearing it from you makes me more confident about rolling it to PROD. I will have a discussion with the network team once about and hear what they have to say and make an estimate accordingly. If you happen to know anyone using it with that size and h

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: ident auth does not works as usual

2023-08-27 Thread David G. Johnston
On Sunday, August 27, 2023, pan snowave wrote: > Hi > > "Show your psql command that is failing." > > [root@~ pg]# /usr/local/pgsql/bin/psql -p5432 -d db1 -h127.0.0.1 > psql: error: connection to server at "127.0.0.1", port 5432 failed: FATAL: > Ident authentication failed for user "root"