Re: backup manifests

e try pg_validatebackup against  a valid backup_manifest file but data directory path is WRONG [centos@tushar-ldap-docker bin]$ ./pg_basebackup -D bk --manifest-checksums=sha224 [centos@tushar-ldap-docker bin]$ cp bk/backup_manifest /tmp/. [centos@tushar-ldap-docker bin]$ ./pg_validateback

Re: backup manifests

On 3/3/20 4:04 PM, tushar wrote: Thanks Robert.  After applying all the 5 patches (v8-00*) against PG v13 (commit id -afb5465e0cfce7637066eaaaeecab30b0f23fbe3) , There is a scenario where pg_validatebackup is not throwing an error if some file deleted from pg_wal/ folder and  but later at

Re: backup manifests

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: backup manifests

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 = 28d082921650d0ae881de8ceb122c8d2af5f449f51ecfb446827f7f49f9

Re: backup manifests

t" is present on disk but not in the manifest but if i remove 'PG_13_202002271 ' directory then there is no error [centos@tushar-ldap-docker bin]$ ./pg_validatebackup data pg_validatebackup: * manifest_checksum = 77ddacb4e7e02e2b880792a19a3adf09266dd88553dd15cfd0c22caee7d9cc0

Re: [Proposal] Global temporary tables

<- row should get removed.  n ---  1 (1 row) -- regards,tushar EnterpriseDB https://www.enterprisedb.com/ The Enterprise PostgreSQL Company

Re: backup manifests

Hi, There is one scenario  where  i somehow able to run pg_validatebackup successfully but when i tried to start the server , it is failing Steps to reproduce - --create 2 base backup directory [centos@tushar-ldap-docker bin]$ ./pg_basebackup -D db1 [centos@tushar-ldap-docker bin

Re: backup manifests

There is one small observation if we use slash (/) with option -i then not getting the desired result Steps to reproduce - == [centos@tushar-ldap-docker bin]$ ./pg_basebackup -D test [centos@tushar-ldap-docker bin]$ touch test/*pg_notify*/dummy_file --working [centos@tushar-ldap

Re: [Proposal] Global temporary tables

I cannot find "max_active_gtt"  GUC . I think you are referring to  "max_active_global_temporary_table" here ? also , would be great  if we can make this error message  user friendly like  - "max connection reached"  rather than memory error -- regards,tushar En

Re: [Proposal] Global temporary tables

e table foo(); CREATE TABLE postgres=# alter table foo set (on_commit_delete_rows='true'); ALTER TABLE postgres=# -- regards,tushar EnterpriseDB https://www.enterprisedb.com/ The Enterprise PostgreSQL Company

Re: [Proposal] Global temporary tables

ly display 'create view' look like we are skipping it ? -- regards,tushar EnterpriseDB https://www.enterprisedb.com/ The Enterprise PostgreSQL Company

Re: backup manifests

d) with option --manifest-checksums,will lead to  this  below error [centos@tushar-ldap-docker bin]$ ./pg_basebackup -R -p 9045 --manifest-checksums=SHA224 -D dc1 pg_basebackup: error: could not initiate base backup: ERROR: syntax error pg_basebackup: removing data directory "dc1" [cent

Re: [pg_rewind] cp: cannot stat ‘pg_wal/RECOVERYHISTORY’: No such file or directory

Hi, Is anyone able to reproduce this one ? Any pointer to solve this would be helpful. regards, On 05/27/2019 07:27 PM, tushar wrote: Hi, I am getting this below error - after performing pg_rewind when i try to start new slave ( which earlier was my master) against PGv12 Beta1. &quo

Re: [pg_rewind] cp: cannot stat ‘pg_wal/RECOVERYHISTORY’: No such file or directory

pa. Thanks for pointing out. -- regards,tushar EnterpriseDB https://www.enterprisedb.com/ The Enterprise PostgreSQL Company

Re: Minimal logical decoding on standbys

rather than removed automatically. Lets user's  delete the slot themself rather than automatically removed  as a surprise. -- regards,tushar EnterpriseDB https://www.enterprisedb.com/ The Enterprise PostgreSQL Company

Re: Minimal logical decoding on standbys

n]$ .)Restart both master and standby ( ./pg_ctl -D master restart -l logsM -c) and (./pg_ctl -D standby restart -l logsS -c ) .)Check the pg_wal directory size of STANDBY [centos@mail-arts bin]$ du -sch standby/pg_wal/ 127M    standby/pg_wal/ 127M    total [centos@mail-arts bin]$ and if

pg_rewind is failing on PG v12 BETA/PG HEAD

0/3003538 on timeline 1 pg_rewind: rewinding from last common checkpoint at 0/260 on timeline 1 pg_rewind: Done! -- regards,tushar EnterpriseDB https://www.enterprisedb.com/ The Enterprise PostgreSQL Company

Re: Minimal logical decoding on standbys

time it is creating new files after firing get_changes function I'm not sure what you mean by this. Are you saying that pg_logical_slot_get_changes() causes WAL to be written? No, when i said - created new WAL files , i meant -after each pg_bench run NOT after executing  get_changes. --

-D option of pg_resetwal is only works with absolute path

Working - [centos@localhost bin]$ ./pg_resetwal -D /home/centos/pg11_22may/postgresql/edbpsql/bin/data Write-ahead log reset Is this something expected  in v11 ? -- regards,tushar EnterpriseDB https://www.enterprisedb.com/ The Enterprise PostgreSQL Company

Re: New committers announced at PGCon 2018

d/c64c5f8b0908062031k3ff48428j824a> 9a46f2818...@mail.gmail.com <mailto:9a46f2818...@mail.gmail.com> Tomas Vondra 11 years, 2007-01-25 https://www.postgresql.org/message-id/20070125155424.gg64...@nasby.net <https://www.postgresql.org/message-id/20070125155424.gg64...@nas

After dropping the rule - Not able to insert / server crash (one time ONLY)

no crash but again rows not inserted  en1 -    1 (1 row) This is not a regression, i am able to see such behavior in v9.6 as well. -- regards,tushar EnterpriseDB https://www.enterprisedb.com/ The Enterprise PostgreSQL Company

<    1   2