On 1/18/23 17:09, Hilbert, Karin wrote:
I manage some PostgreSQL clusters on Linux. We have a Primary & two
Standby servers & for Production, there is also a DR server. We use
repmgr for our HA solution & the Standbys are cloned from the Primary
using the *repmgr standby clone* command.
My
Erik Wienhold writes:
> On 19/01/2023 01:23 CET Ian Lawrence Barwick wrote:
>> This is incorrect; with streaming replication all changes applied on the
>> primary
>> are applied on the standby.
> Thanks. I was thinking about logical replication.
It's not entirely clear whether the OP is talkin
> On 19/01/2023 01:23 CET Ian Lawrence Barwick wrote:
>
> 2023年1月19日(木) 8:50 Erik Wienhold :
> >
> > > On 19/01/2023 00:09 CET Hilbert, Karin wrote:
> > >
> > > I manage some PostgreSQL clusters on Linux. We have a Primary & two
> > > Standby
> > > servers & for Production, there is also a DR se
2023年1月19日(木) 8:50 Erik Wienhold :
>
> > On 19/01/2023 00:09 CET Hilbert, Karin wrote:
> >
> > I manage some PostgreSQL clusters on Linux. We have a Primary & two Standby
> > servers & for Production, there is also a DR server. We use repmgr for our
> > HA
> > solution & the Standbys are cloned f
> On 19/01/2023 00:09 CET Hilbert, Karin wrote:
>
> I manage some PostgreSQL clusters on Linux. We have a Primary & two Standby
> servers & for Production, there is also a DR server. We use repmgr for our HA
> solution & the Standbys are cloned from the Primary using the repmgr standby
> clone com
I manage some PostgreSQL clusters on Linux. We have a Primary & two Standby
servers & for Production, there is also a DR server. We use repmgr for our HA
solution & the Standbys are cloned from the Primary using the repmgr standby
clone command.
My manager asked for a report of all the user d
On 1/18/23 13:15, Gavan Schneider wrote:
On 19 Jan 2023, at 6:47, Peter wrote:
Now I want to grab some part of the data, on a certain condition
(let's say all records belonging to user 'Bob', if there is a "user"
table somewhere at the tree-bottom), and move it to another database
with the very
On 19 Jan 2023, at 6:47, Peter wrote:
> Now I want to grab some part of the data, on a certain condition
> (let's say all records belonging to user 'Bob', if there is a "user"
> table somewhere at the tree-bottom), and move it to another database
> with the very same layout - which is already popu
On Wed, Jan 18, 2023 at 9:03 PM Jeremy Smith wrote:
>> How to do this with two tables connected via one foreign key, that is
>> explained a dozen times in Stackoverflow. But what if the tree is 50
>> tables and 120 foreign key columns?
>> It can be done. But probably not manually.
>>
>> So, as thi
>
>
> How to do this with two tables connected via one foreign key, that is
> explained a dozen times in Stackoverflow. But what if the tree is 50
> tables and 120 foreign key columns?
> It can be done. But probably not manually.
>
> So, as this seems a very usual use-case for normalized data, is t
Hi,
imagine I have a database containing normalized data: a whole bunch
of tables all related via foreign keys (i.e. the thing one should
usually have ;) ).
So there is a dependency graph: all records relate to others in
some tree-like fashion (has-many, belongs-to, etc.)
Now I want to grab so
> On 18/01/2023 18:03 CET Dirschel, Steve
> wrote:
>
> The plan changes:
>
> Sort (cost=9382.94..9382.97 rows=12 width=169)
> Sort Key: lmq1.priority DESC, lmq1.request_time
> -> Bitmap Heap Scan on lm_queue lmq1 (cost=4572.59..9382.73 rows=12 width=169)
> Recheck Cond: ((client_name)::text = 'WL
> On 18/01/2023 18:56 CET Tom Lane wrote:
>
> "Dirschel, Steve" writes:
> > Filter: ... (alternatives: SubPlan 1 or hashed SubPlan 2) ...
> > SubPlan 1
> >-> Index Scan using ix_lm_cc on lm_queue lmq2
> > (cost=0.40..177.93 rows=1 width=0)
> > Ind
"Dirschel, Steve" writes:
> Filter: ... (alternatives: SubPlan 1 or hashed SubPlan 2) ...
> SubPlan 1
>-> Index Scan using ix_lm_cc on lm_queue lmq2 (cost=0.40..177.93
> rows=1 width=0)
> Index Cond: ((collection_name)::text =
> (lmq1.collection_n
On 1/18/23 10:54, Rob Sargent wrote:
On 1/18/23 09:38, HECTOR INGERTO wrote:
I wanted to understand the underlying issue.
I use ZFS snapshots instead of a “correct” backup because with only two
machines it allows me to have backups in the main machine and in the
secondary too that acts as ho
Table definition:
Table "load.lm_queue"
Column | Type | Collation | Nullable
| Default
++---+--+-
guid
On 1/18/23 09:38, HECTOR INGERTO wrote:
I wanted to understand the underlying issue.
I use ZFS snapshots instead of a “correct” backup because with only
two machines it allows me to have backups in the main machine and in
the secondary too that acts as hotspare at the same time.
To accompli
I wanted to understand the underlying issue.
I use ZFS snapshots instead of a “correct” backup because with only two
machines it allows me to have backups in the main machine and in the secondary
too that acts as hotspare at the same time.
To accomplish the same I would need 3 nodes. The main,
On Tue, 2023-01-17 at 15:22 +, HECTOR INGERTO wrote:
> > Another case: a transaction COMMITs, and a slightly later transaction reads
> > the data
> > and sets a hint bit. If the snapshot of the file system with the data
> > directory in it
> > is slightly later than the snapshot of the file
19 matches
Mail list logo