Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS

2021-04-05 Thread aditya desai
Thanks Amine and Justin. I will check and try this. Regards, Aditya. On Sun, Apr 4, 2021 at 10:49 PM Justin Pryzby wrote: > On Sun, Apr 04, 2021 at 04:12:14PM +0530, aditya desai wrote: > > Hi, > > We have few select queries during which we see SHARED LOCKS and EXCLUSIVE > > LOCKS on tables. Ca

PosgtgreSQL hot standby reading WAL from muli-attached volume?

2021-04-05 Thread Gunther Schadow
Hi, I wonder can we set up a hot standby in such a way that we don't need any log streaming nor shipping, where instead every hot standby just mounts the same disk in read-only mode which the master uses to write his WAL files? Even without a clustered file system, e.g., a UFS on FreeBSD, on