Re: Basebackup fails without useful error message

2024-09-29 Thread Muhammad Usman Khan
Hi, You can enable verbose to get more detail about what is happening during backup pg_basebackup -h your_host -U your_user -D /mnt/base_backup/dir/ -v Also examine recent postgres logs Verify backup directory permissions On Sun, 29 Sept 2024 at 19:49, Koen De Groote wrote: > Having run a baseba

Re: Failing GSSAPI TCP when connecting to server

2024-09-29 Thread Tom Lane
Ron Johnson writes: > On Sun, Sep 29, 2024 at 2:00 PM Peter wrote: >> My application is trying to connect the database server, and meanwhile >> tries to talk to the KDC server for a service ticket. >> A configuration problem on the machine(s) can be ruled out, > Famous last words. The TCP trac

Re: Failing GSSAPI TCP when connecting to server

2024-09-29 Thread Ron Johnson
On Sun, Sep 29, 2024 at 2:00 PM Peter wrote: > My application is trying to connect the database server, and meanwhile > tries to talk to the KDC server for a service ticket. > Earlier these TCP connections did run like this, and were successful: > > [snip] > > A configuration problem on the mach

Failing GSSAPI TCP when connecting to server

2024-09-29 Thread Peter
My application is trying to connect the database server, and meanwhile tries to talk to the KDC server for a service ticket. Earlier these TCP connections did run like this, and were successful: 13:57:53.788797 IP6 clientIPv6.54143 > serverIPv6.88: Flags [S], seq 4189109662, win 65535, options [

Re: Basebackup fails without useful error message

2024-09-29 Thread Adrian Klaver
On 9/29/24 08:57, Koen De Groote wrote: > What is the complete command you are using? The full command is: pg_basebackup -h localhost -p 5432 -U basebackup_user -D /mnt/base_backup/dir -Ft -z -P So output Format as tar, gzipped, and with progress being printed. > Have you looked at the Po

Re: Basebackup fails without useful error message

2024-09-29 Thread Koen De Groote
> What is the complete command you are using? The full command is: pg_basebackup -h localhost -p 5432 -U basebackup_user -D /mnt/base_backup/dir -Ft -z -P So output Format as tar, gzipped, and with progress being printed. > Have you looked at the Postgres log? > Is --verbose being used? This

Re: Basebackup fails without useful error message

2024-09-29 Thread Adrian Klaver
On 9/29/24 07:48, Koen De Groote wrote: Having run a basebackup, I'm getting this output at the very end: pg_basebackup: child process exited with error 1 pg_basebackup: removing contents of data directory "/mnt/base_backup/dir/" What is the complete command you are using? Is there a way to

Basebackup fails without useful error message

2024-09-29 Thread Koen De Groote
Having run a basebackup, I'm getting this output at the very end: pg_basebackup: child process exited with error 1 pg_basebackup: removing contents of data directory "/mnt/base_backup/dir/" Is there a way to get more information as to what exactly happened? I'd like to look into fixing this or d

Re: Logical Replication Delay

2024-09-29 Thread GF
Hi Ram, 29 set 2024, 12:29 Ramakrishna m : *We are planning to set up logical replication from a standby to another > server. When the primary goes down, there is no issue as the standby > becomes the primary and the logical slots are already present. However, > when the standby goes down, these

Re: Logical Replication Delay

2024-09-29 Thread Ramakrishna m
Hi Justin and Greg, Thank you for your input and recommendations. We understand your point regarding separating the tables into different publications and subscriptions. However, due to certain business constraints, we are unable to implement this approach at the moment. *We are planning to set u