Re: backup manifests

2020-03-04 Thread tushar
Hi, Another observation , if i change the ownership of a file which is under global/ directory i.e [root@tushar-ldap-docker global]# chown enterprisedb 2396 and run the pg_validatebackup command, i am getting this message - [centos@tushar-ldap-docker bin]$ ./pg_validatebackup

Re: Identifying user-created objects

2020-03-04 Thread Fujii Masao
On 2020/03/04 18:36, Masahiko Sawada wrote: On Wed, 4 Mar 2020 at 18:02, Fujii Masao wrote: On 2020/03/04 17:05, Masahiko Sawada wrote: On Wed, 4 Mar 2020 at 16:43, Fujii Masao wrote: On 2020/02/05 20:26, Masahiko Sawada wrote: Hi, User can create database objects such as

Re: Identifying user-created objects

2020-03-04 Thread Masahiko Sawada
On Wed, 4 Mar 2020 at 18:57, Fujii Masao wrote: > > > > On 2020/03/04 18:36, Masahiko Sawada wrote: > > On Wed, 4 Mar 2020 at 18:02, Fujii Masao > > wrote: > >> > >> > >> > >> On 2020/03/04 17:05, Masahiko Sawada wrote: > >>> On Wed, 4 Mar 2020 at 16:43, Fujii Masao > >>> wrote: > >

Re: PG_COLOR not mentioned in docs of vacuumlo, oid2name and pgbench

2020-03-04 Thread Fabien COELHO
Bonjour Michaël, All the tools mentioned in $subject have been switched recently to use the central logging infrastructure, which means that they have gained coloring output. However we (mostly I) forgot to update the docs. Attached is a patch to fix this issue. Please let me know if there

Re: Re: [HACKERS] make async slave to wait for lsn to be replayed

2020-03-04 Thread Fujii Masao
On Tue, Mar 13, 2018 at 10:06 PM David Steele wrote: > > Hi Ivan, > > On 3/6/18 9:25 PM, Michael Paquier wrote: > > On Tue, Mar 06, 2018 at 02:24:24PM +0300, Ivan Kartyshov wrote: > >> Hello, I now is preparing the patch over syntax that Simon offered. And in > >> few day I will update the patch.

Re: Identifying user-created objects

2020-03-04 Thread Masahiko Sawada
On Wed, 4 Mar 2020 at 18:02, Fujii Masao wrote: > > > > On 2020/03/04 17:05, Masahiko Sawada wrote: > > On Wed, 4 Mar 2020 at 16:43, Fujii Masao > > wrote: > >> > >> > >> > >> On 2020/02/05 20:26, Masahiko Sawada wrote: > >>> Hi, > >>> > >>> User can create database objects such as functions

Re: Minor issues in .pgpass

2020-03-04 Thread Fujii Masao
On 2020/03/03 22:07, Hamid Akhtar wrote: On Tue, Mar 3, 2020 at 5:38 PM Hamid Akhtar mailto:hamid.akh...@gmail.com>> wrote: On Mon, Mar 2, 2020 at 6:07 PM Fujii Masao mailto:masao.fu...@oss.nttdata.com>> wrote: On 2020/02/29 0:46, Hamid Akhtar wrote: > The following

Re: logical replication empty transactions

2020-03-04 Thread Amit Kapila
On Wed, Mar 4, 2020 at 11:16 AM Dilip Kumar wrote: > > On Wed, Mar 4, 2020 at 10:50 AM Amit Kapila wrote: > > > > On Wed, Mar 4, 2020 at 9:52 AM Dilip Kumar wrote: > > > > > > > > > IMHO, the threshold should be based on the commit LSN. Our main > > > reason we want to send empty transactions

Re: backup manifests

2020-03-04 Thread tushar
Another scenario, in which if we modify Manifest-Checksum" value from backup_manifest file , we are not getting an error [centos@tushar-ldap-docker bin]$ ./pg_validatebackup data/ pg_validatebackup: * manifest_checksum = 28d082921650d0ae881de8ceb122c8d2af5f449f51ecfb446827f7f49f91f65d

Re: logical replication empty transactions

2020-03-04 Thread Dilip Kumar
On Wed, Mar 4, 2020 at 3:47 PM Amit Kapila wrote: > > On Wed, Mar 4, 2020 at 11:16 AM Dilip Kumar wrote: > > > > On Wed, Mar 4, 2020 at 10:50 AM Amit Kapila wrote: > > > > > > On Wed, Mar 4, 2020 at 9:52 AM Dilip Kumar wrote: > > > > > > > > > > > > IMHO, the threshold should be based on the

<    1   2