On Tue, Oct 24, 2023, 9:02 PM Ron wrote:
> On 10/24/23 19:29, Brad White wrote:
> > I have the replication server set up and the streaming is working.
> > The latest data show up, as desired.
> >
> > 3 minor issues.
> >
>
> > 2) I have the connection string set for the replication server to
> con
On 10/24/23 19:29, Brad White wrote:
I have the replication server set up and the streaming is working.
The latest data show up, as desired.
3 minor issues.
1) I also have the WAL files being copied to a common location from the
primary server with
archive_command = 'copy %p
"DISKST
I have the replication server set up and the streaming is working.
The latest data show up, as desired.
3 minor issues.
1) I also have the WAL files being copied to a common location from the
primary server with
archive_command = 'copy %p
"DISKSTATION\\AccessData\\Prod\\WALfiles\\%f"'
Em 24/10/2023 17:31, Tom Lane escreveu:
> Carlos Alves writes:
>
>> I need some help to understand why a transaction wiht a row delete
>> aquire a AccessExclusiveLock and a row update a ExclusiveLock.
>
> UPDATE can use the weaker lock type if it's not modifying any
> column that is part of a
Carlos Alves writes:
> I need some help to understand why a transaction wiht a row delete
> aquire a AccessExclusiveLock and a row update a ExclusiveLock.
UPDATE can use the weaker lock type if it's not modifying any
column that is part of a unique index. This is to allow concurrency
with forei
On 10/24/23 13:31, Brad White wrote:
On Tue, Oct 24, 2023 at 8:56 AM Ron wrote:
On 10/24/23 08:14, b55white wrote:
Is all that stuff with slots necessary since the backup will automatically
create a temporary slot for replication?
I want a permanent slot so that replication auto
> On Oct 24, 2023, at 11:31, Brad White wrote:
> Are you saying that once I get streaming replication set up, it quits working
> when I reboot the servers once a week?
Not unless the downtime is sufficiently long that the replica can't find the
WAL information it needs. You can avoid this w
On Tue, Oct 24, 2023 at 8:56 AM Ron wrote:
> On 10/24/23 08:14, b55white wrote:
>
> Is all that stuff with slots necessary since the backup will automatically
> create a temporary slot for replication?
>
>
> I want a permanent slot so that replication automatically resumes if the
> secondary mus
After much searching, I eventually discovered that there's a firmware
update for my Samsung Firecuda NVMe drives:
https://www.seagate.com/support/downloads/
Also Seagate:
https://www.dell.com/en-us/shop/workstations-isv-certified/sr/workstations/linux?appliedRefinements=39332
Not sure about the
Em 24/10/2023 13:27, Carlos Alves escreveu:
> Hi!
>
> I need some help to understand why a transaction wiht a row delete aquire a
> AccessExclusiveLock and a row update a ExclusiveLock.
>
> To ilustrate, a made this scenario:
>
> create table tblock
>
> (
>
> id int primary key,
>
> v
Hi!
I need some help to understand why a transaction wiht a row delete
aquire a AccessExclusiveLock and a row update a ExclusiveLock.
To ilustrate, a made this scenario:
create table tblock
(
id int primary key,
value text
);
insert into tblock values (1, 'somevalue');
First s
On 10/24/23 08:14, b55white wrote:
On Oct 23, 2023 at 8:30 PM, Ron wrote:
On 10/23/23 18:16, Brad White wrote:
> I'm stumped.
>
> Using this command to set up the slave and replication on PG v 15:
> "C:\Program Files\PostgreSQL\15\bin\pg_basebackup" -h 192.168.1.126 -U
> pgrep_user -p 5433 -D
On Monday, October 23, 2023, Brad White wrote:
> I'm stumped.
>
> Using this command to set up the slave and replication on PG v 15:
>
>
You must, by some means:
Have PostgreSQL binaries installed on the machine that is to become the
replica.
Have the output of pg_basebackup present on the repli
>
> On Oct 23, 2023 at 8:30 PM, Ronwrote:
>
>
> On 10/23/23 18:16, Brad White wrote:
> > I'm stumped.
> >
> > Using this command to set up the slave and replication on PG v 15:
> > "C:\Program Files\PostgreSQL\15\bin\pg_basebackup" -h 192.168.1.126 -U
> > pgrep_user -p 5433 -D
Greg Stark said on Mon, 23 Oct 2023 04:05:28 -0400
>The main disadvantage of Slides is that as a WYSIWYG style editor
>you're designing each slide individually. If you later decide you want
>to use a smaller font or slide the main body up a bit or whatever you
>have to go back through all your sl
15 matches
Mail list logo
