Dear SMEs
I have finally decided to move forward after great hospitality in Version
9.2.24 :-)
First i attempted to upgrade from 9.2.24 to 10.7, but its failed with
following error during Check Mode.
could not load library "$libdir/hstore": ERROR: could not access file
"$libdir/hstore": No such
indir=$NEWCLUSTER/bin --old-datadir=$OLDCLUSTER/bin/data
> --new-datadir=$NEWCLUSTER/bin/data
>
> Note: old server should be in running state and new server should not be
> in running state.
>
> Thanks and Regards
> Mahendra
>
> On Thu, 28 Feb 2019 at 23:44, Perumal R
Thank you very much Sergei,
Yes, i want to get rid of old extension, Could you please share the query
to find extension which is using pg_reorg.
Regards,
On Thu, Feb 28, 2019 at 10:27 AM Sergei Kornilov wrote:
> Hello
>
> pgsql-hackers seems wrong list for such question.
>
> > could not loa
here is the data,
postgres=# \c template1
You are now connected to database "template1" as user "postgres".
template1=# \dx
List of installed extensions
Name | Version | Schema | Description
-+-++--
plpgsql |
Hi Sergei and Team
Could you share your observation further.
Perumal Raju
On Thu, Feb 28, 2019, 11:21 AM Perumal Raj wrote:
> here is the data,
>
> postgres=# \c template1
> You are now connected to database "template1" as user "postgres".
> templat
Hi Team,
I have cascade level streaming replication & WAL Apply setup .
*Primary -> Secondary 1 -> Secondary 2,Secondary 3*
*WAL Archive -> Secondary 4*
I am expanding setup by adding another Replica from *Primary -> Secondary 5*
for logical streaming.
Do I need to install and configure pglogic
Hi Community
I am trying to upgrade PostgreSQL (RHEL 7) from version 13.7 to 15.6 using
pglogical.
My Standby(destination) machine has following rpms,
*postgresql13-pglogical-3.7.16-1.el7.x86_64pglogical_15-2.4.3-1.rhel7.x86_64*
And Primary(Source) has ,
*postgresql13-pglogical-3.7.16-1.el7.x
at 8:09 AM Perumal Raj wrote:
> Thanks Hou zj
>
> I will capture log message and share it with you,
>
> temporary column marked as 'false' every where , But synced column marked
> as 'false' in Primary whereas it was 'true' in both Direct STANDBYs
>
Hi Community,
I have installed postgres version 17.5 with following setup,
*Primary *
-- Secondary A
-- Secondary B
-- Secondary C
*Config:*
wal_level = 'logical'
max_wal_senders = '10'
max_replication_slots = '10'
wal_keep_size = '512MB'
hot_standby = 'on'
sync_re
On Fri, Jun 13, 2025 at 9:46 PM Amit Kapila wrote:
> On Fri, Jun 13, 2025 at 10:52 PM Perumal Raj wrote:
> >
> > Thanks for explanation Shveta!
> >
> >
> > As Summary in this original thread,
> >
> > Prerequisites for Setting Up a Logica
Hi Team,
I am looking to upgrade pg17 with near zero downtime using logical
replication(master <-> master) . The current pglogical2 ( open) has some
limitation with 'REPLICA IDENTITY FULL' tables.
Do we have any plan to make pglogical3 open source in near future? 😊 or
is there better way to ach
L: Last completed transaction
was at log time 2025-06-13 06:33:31.675341+00.
*Until the synchronization is complete, the slot type is marked as
temporary=true, as you mentioned.*
is there any manual way to advance *"**restart_lsn"* of logical
replication slot ? This is to ensure slot sy
ta
-+--+--
0/7B001AA0 | 1218 | BEGIN 1218
0/7B00B9D0 | 1218 | table public.customers_1: TRUNCATE: (no-flags)
0/7B00BB70 | 1218 | COMMIT 1218
Thanks Shveta, Zhijie Hou
Please correct me if needed.
On Fri, Jun 13, 2025 at 2:51 AM
13 matches
Mail list logo
