sure. In
oracle extra space omit but in Postgres it would not.
Sent from Outlook for iOS<https://aka.ms/o0ukef>
From: shashidhar Reddy
Sent: Monday, November 25, 2024 2:14:37 PM
To: ajit wangkhem
Cc: pgsql-general
Subject: Re: Unique key constraint Issue
H
Put wal log in the restore directory and check during start postgresql
consumed or not. If consumed then no issue. Instead of risk free create
recovery.conf or standby.signal and put restore_command in that above file
and see whether consumed or not. If consumed its ok.
On Mon, Nov 25, 2024 at 11:
Output should be consistent across servers below query o/p
SELECT conname, pg_get_constraintdef(oid)
FROM pg_constraint
WHERE conrelid = 'your table name'::regclass AND contype = 'u';
(different datatype combine in UK is not an issue). This issue may not
happen in asynchronous, log shipping or s
