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
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 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
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 |
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
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
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