Re: Pgsql 16 to 14 using builtin logical

2024-10-26 Thread Asad Ali
I missed to mentioned in the last. On Sat, Oct 26, 2024, 10:51 PM Adrian Klaver wrote: > On 10/26/24 10:06, Asad Ali wrote: > > > > In the typical upgrade scenario, replication flows from the lower > > (older) version to the higher (newer) version. Here, the source is the &

Re: Pgsql 16 to 14 using builtin logical

2024-10-26 Thread Asad Ali
(PostgreSQL 14) is possible but unconventional and not usually done for upgrades. Best Regards, Asad Ali On Sat, Oct 26, 2024, 9:10 PM Adrian Klaver wrote: > On 10/25/24 23:02, Asad Ali wrote: > > Hi Durgamahesh, > > > > Yes, you can replicate a PostgreSQL 16 database t

Re: Pgsql 16 to 14 using builtin logical

2024-10-25 Thread Asad Ali
Hi Durgamahesh, Yes, you can replicate a PostgreSQL 16 database to PostgreSQL 14 using built-in logical replication. PostgreSQL's built-in logical replication allows for replicating data between different versions of PostgreSQL, provided the source version is higher than or equal to the target ver

Re: Support for dates before 4713 BC

2024-10-16 Thread Asad Ali
ns or operations on your custom dates (BC/AD), you can create user-defined functions in PostgreSQL for adding, subtracting, or comparing dates. Best Regards, Asad Ali On Thu, Oct 17, 2024 at 5:36 AM Tom Lane wrote: > David Rowley writes: > > It's by no means a trivial thing to do, bu

Re: Backup

2024-10-16 Thread Asad Ali
p space. Use monitoring tools to track the performance of your backups. This will help you identify any potential bottlenecks and optimize the backup process. I hope this helps you create smaller and quicker backups for your PostgreSQL database. Let me know if you have any questions or need further

Re: Customize psql prompt to show current_role

2024-09-23 Thread Asad Ali
lly or include it in your .psqlrc file for automatic loading with each session. I hope this helps! Best regards, Asad Ali On Mon, Sep 23, 2024 at 2:31 PM Dominique Devienne wrote: > Hi. I've successfully customized my psql PROMPT1, > using %n for session_user, but I'd like to see &g