Re: [HACKERS] pg_receivexlog does not report flush position with --synchronous

Hi Simon and Michael, 2016-08-23 10:39 GMT+02:00 Simon Riggs : > > Agreed, but I'd move all the comments above the block. > That's fine with me. Thanks, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia - Director PostgreSQL Training, Services and Support gabriele.barto

[HACKERS] pg_receivexlog does not report flush position with --synchronous

position. I am not sure if it is a bug or not. I any case I guess we should probably improve the documentation - it's a bit late here so maybe I can try better tomorrow with a fresher mind. :) Thanks, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia - Director PostgreSQL Training

Re: [HACKERS] File based Incremental backup v8

Hi Robert, 2015-03-07 2:57 GMT+11:00 Robert Haas : > By the way, unless I'm missing something, this patch only seems to > include the code to construct an incremental backup, but no tools > whatsoever to do anything useful with it once you've got it. As stated previously, Marco is writing a too

Re: [HACKERS] File based Incremental backup v8

Hi Bruce, 2015-03-08 5:37 GMT+11:00 Bruce Momjian : > > Desirability -> Design -> Implement -> Test -> Review -> Commit > > This patch has continued in development without getting agreement on > its Desirability or Design, meaning we are going to continue going back > to those points until

Re: [HACKERS] File based Incremental backup v8

Hi Robert, 2015-03-06 3:10 GMT+11:00 Robert Haas : > But I agree with Fujii to the extent that I see little value in > committing this patch in the form proposed. Being smart enough to use > the LSN to identify changed blocks, but then sending the entirety of > every file anyway because you don'

Re: [HACKERS] [RFC] Incremental backup v3: incremental PoC

rward to continuing the review. Ciao, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia - Managing Director PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it 2015-01-13 17:21 GMT+01:00 Marco Nenciarini : > Il 13/01/15 12:53, Gabriele Bartoli

Re: [HACKERS] [RFC] Incremental backup v3: incremental PoC

Hi Marco, could you please send an updated version the patch against the current HEAD in order to facilitate reviewers? Thanks, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia - Managing Director PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it | www

Re: [HACKERS] [RFC] Incremental backup v2: add backup profile to base backup

Hello, 2014-10-06 17:51 GMT+02:00 Marco Nenciarini : > I agree that a full backup does not need to include a profile. > > I've added the option to require the profile even for a full backup, as > it can be useful for backup softwares. We could remove the option and > build the profile only during

Re: [HACKERS] Proposal: Incremental Backup

Hi Claudio, 2014-08-12 15:25 GMT+02:00 Claudio Freire : > Still not safe. Checksum collisions do happen, especially in big data sets. Can I ask you what you are currently using for backing up large data sets with Postgres? Thanks, Gabriele -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] Proposal: Incremental Backup

Hi Marco, > With the current full backup procedure they are backed up, so I think > that having them backed up with a rsync-like algorithm is what an user > would expect for an incremental backup. Exactly. I think a simple, flexible and robust method for file based incremental backup is all we ne

Re: [HACKERS] Proposal: Incremental Backup

Hi Claudio, I think there has been a misunderstanding. I agree with you (and I think also Marco) that LSN is definitely a component to consider in this process. We will come up with an alternate proposal which considers LSNS either today or tomorrow. ;) Thanks, Gabriele -- Gabriele Bartolini

Re: [HACKERS] Proposal: Incremental Backup

ly changes disaster recovery policies in a company. Or even 2 hours instead of 6. My 2 cents, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it 2014-08-01 19:05 GMT+02:00 Claudio Freire : > On Fri

Re: [HACKERS] [PATCH] Support for pg_stat_archiver view

_status directory. Or we can also > implement that by adding new counter field in pg_stat_archiver > structure, incrementing it whenever creating .ready file, and > decrementing it whenever changing .ready to .done. I would love to give it a shot at the next opportunity. Thanks, Gabriele

Re: [HACKERS] [PATCH] Relocation of tablespaces in pg_basebackup

and path at this stage) to a > tablespace name. This solution, even though not optimal, is a lot > better than my initial one where I used the OID directly. Try: SELECT spcname, oid, pg_tablespace_location(oid) FROM pg_tablespace Thanks, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia Postgr

Re: [HACKERS] [PATCH] Relocation of tablespaces in pg_basebackup

n the tablespace name) and over servers. > $ pg_basebackup -Xs -D backup/data -T /tmp/tblspc1:$(pwd)/backup/t1 -T > /tmp/tblspc2:$(pwd)/backup/t2 With the above example, it would become: $ pg_basebackup -Xs -D backup/data -T tblspc1:$(pwd)/backup/t1 -T tblspc2:$(pwd)/backup/t2 Thanks, Gabriele

Re: [HACKERS] [PATCH] Support for pg_stat_archiver view

ink it is a possibility, given that the client code that is aware of the events lies in pgarch.c. Ciao, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it -- Sent via pgsql-hackers mailing

Re: [HACKERS] [PATCH] Support for pg_stat_archiver view

* time of the last failed attempt Thanks for your inputs. Ciao, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml

Re: [HACKERS] [PATCH] Support for pg_stat_archiver view

, that was just a quick > one-over) Thanks for that. It already means a lot if you agree too it is worth it. Ciao, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it -- Sent via pgsql-hackers

[HACKERS] [PATCH] Support for pg_stat_archiver view

ion to the pg_stat_archiver view, including the number of failed attempts of archival and the WAL and timestamp of the latest failure. However, before proceeding, I'd like to get some feedback on this small patch as well as advice on possible regression tests to be added. Thank you. Cheers, Gabriele

[HACKERS] Italian PGDay 2012, Call for papers is now open

/call-for-papers/international-call-for-papers/ For any kind of information, do not hesitate to contact the organising committee via email at pgday2...@itpug.org. Thank you. Cheers, Gabriele Gabriele Bartolini Italian PostgreSQL Users Group (ITPUG), President -- Sent via pgsql-hackers mailing

Re: [HACKERS] [PATCH] Support for foreign keys with arrays

Il 30/07/12 19:16, Gabriele Bartolini ha scritto: And it can be also interchanged with "Array element Foreign Key". As promised, we have sent a patch for the "Array ELEMENT foreign key" support. We are discontinuing this thread here and continue discussing the former

Re: [HACKERS] [PATCH] Support for foreign keys with arrays

Il 30/07/12 19:11, Alvaro Herrera ha scritto: I was going to say the same, except I had ELEMENT as a capitalized word in my mind (and in the docs it'd be within ). So: "Array ELEMENT Foreign Key" +1 for me And it can be also interchanged with "Array element Foreign

Re: [HACKERS] [PATCH] Support for foreign keys with arrays

text, race_day DATE, ... final_positions integer[], FOREIGN KEY (ELEMENT final_positions) REFERENCES drivers ); Example 3: with ALTER TABLE CREATE TABLE races ( race_id integer PRIMARY KEY, title text, race_day DATE, ... final_positions integer[] ); ALTER TABLE r

Re: [HACKERS] Patch pg_is_in_backup()

oceed with the review. Thank you, Marco This body part will be downloaded on demand. -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it

Re: [HACKERS] [PATCH] Support for foreign keys with arrays

y accepted terminology and syntax for this feature. I hope this sounds like a reasonable plan. Thank you. Cheers, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it -- Sent via pgsql-hackers ma

Re: [HACKERS] Patch pg_is_in_backup()

handled (with an exception) by the server. Cool. I spotted though some formatting issues, in particular indentation and multi-line comments. Some rows are longer than 80 chars. Please resubmit with these cosmetic changes and it is fine with me. Thank you. Cheers, Gabriele -- Gabriele

Re: [HACKERS] Patch pg_is_in_backup()

looks like we need a new version that can apply with current HEAD. If you can do that, I am happy to assist with the review. Have a good weekend. Thank you, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadran

Re: [HACKERS] [PATCH] Support for foreign keys with arrays

tion). The same concept applies for SET NULL (the whole array is set to NULL) and EACH SET NULL (referencing elements are set to NULL). Thank you. Cheers, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it

Re: [HACKERS] [PATCH] Support for foreign keys with arrays

() and fixes a few typos in the documentation. Thank you, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it EACH-foreign-key.v4b.patch.bz2 Description: BZip2 compressed data -- Sent via pgsql

Re: [HACKERS] [PATCH] Support for foreign keys with arrays

very small modification/change to major 3 version of the patch), which passes all tests. Cheers, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it EACH-foreign-key-constraints-aka-foreign-key-arrays.v3b

Re: [HACKERS] Dry-run mode for pg_archivecleanup

iff;h=b2e431a4db81a735d1474c4d1565a20b835878c9 Beautiful! :) Thank you very much. Ciao, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to

Re: [HACKERS] [PATCH] Support for foreign keys with arrays

same syntax, from 9.3. To complete the ARRAY -> EACH transition, I would suggest names like CASCADE EACH/SET EACH NULL. Sounds perfect. Marco will go through all your comments and will send version 3 shortly. Thank you, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL

Re: [HACKERS] Dry-run mode for pg_archivecleanup

put this in the todo list however. Let me know what you think. Cheers, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To

Re: [HACKERS] Dry-run mode for pg_archivecleanup

own? Here is my final version which embeds comments from Josh. I have also added debug information to be printed in case '-d' is given. I will update the CommitFest website. Thanks, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Supp

Re: [HACKERS] Dry-run mode for pg_archivecleanup

reasons for the stdout channel, then I will send v2. Thanks again! Ciao, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresq

[HACKERS] Dry-run mode for pg_archivecleanup

t. Thanks, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it *** a/contrib/pg_archivecleanup/pg_archivecleanup.c --- b/contrib/pg_archivecleanup/pg_archivecleanup.c *** *** 36,41

Re: [HACKERS] [PATCH] Support for foreign keys with arrays

ent | NO ACTION |-|-| RESTRICT |-|-| --- - - If that's fine with you guys, Marco and I will refactor the development based on these assumptions. Thanks, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Supp

Re: [HACKERS] [PATCH] Support for foreign keys with arrays

so that we can organise intermediate deliverables). Thanks, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] [PATCH] Support for foreign keys with arrays

s AUTHORS: * Gabriele Bartolini * Marco Nenciarini Cheers, Gabriele (and Marco) -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it *** a/doc/src/sgml/ddl.sgml --- b/doc/src/sgml/ddl.sgml *** *

[HACKERS] Italian PGDay 2011, Call for papers is now open

ent here: http://2011.pgday.it/sites/default/files/PGDay2011-CFP-EN_0.pdf We look forward to hearing from you, and seeing you in Prato in November! Gabriele Bartolini Italian PostgreSQL Users Group (ITPUG), President

[HACKERS] Dry Run mode for pg_archivecleanup

Hi guys, I have added the '-n' option to pg_archivecleanup which performs a dry-run and outputs the names of the files to be removed to stdout (making possible to pass the list via pipe to another process). Please find attached the small patch. Thanks, Gabriele -- Gabriele

Re: [HACKERS] Proposed patch: Smooth replication during VACUUM FULL

mostly works (see attached graph), but there are some unresolved spikes that will require further work in 9.2. Cheers, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it <> -- Sent via

Re: [HACKERS] Proposed patch: Smooth replication during VACUUM FULL

me. You can easily spot in the graphs the point where VACUUM FULL terminates, then it is just a matter of flushing the WAL delay for replication. Anyway, I hope I can give you more detailed information tomorrow. Thanks. Cheers, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Tr

[HACKERS] Proposed patch: Smooth replication during VACUUM FULL

nates). The test result is consistent with the expected behaviour of cost-based vacuum delay. -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it diff --git a/src/backend/commands/cluster.c b/src/backend/com

Re: [DOCS] [HACKERS] Uppercase SGML entity declarations

Il 04/04/11 22:26, Robert Haas ha scritto: I think you still need to update Solution.pm to match. Here it is, including change of 3 'Id' attributes (I made them lowercase). Thanks, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services a

Re: [DOCS] [HACKERS] Uppercase SGML entity declarations

d compatibility with SGML is kept, I thought changing this at source level would be something to propose and submit. Ciao, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it -- Sent via pgsql-hacke

Re: [HACKERS] Uppercase SGML entity declarations

e SGML compatibility of the original documentation intact. Also I was trying to make the ENTITY declarations consistent throughout the documents. I hope I gave you a more clear explanation. Cheers, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Supp

[HACKERS] Uppercase SGML entity declarations

l/ref/allfiles.sgml doc/src/sgml/standalone-install.sgml Thanks. Cheers, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it diff --git a/doc/src/sgml/Makefile b/doc/src/sgml/Makefile index 30

[HACKERS] Italian PGDay 2010, Call for papers

ook forward to hearing from you, and seeing you in Rome in December! Gabriele Bartolini Italian PostgreSQL Users Group (ITPUG), President

Re: [HACKERS] psycopg2 license changed

good if we could update our wiki as well in order to include this resource too. Ciao, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] Confusion over Python drivers

on in the open-source community, and I will be very happy to try and explain the situation to him. I will keep you posted. Ciao, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it -- Sent via pgsql-

Re: [HACKERS] MySQL-ism help patch for psql

I would personally emulate \d and take the chance for showing a funny warning, something like: "hey, it's not MySql!" or similar. I am sure we will Finder something appropriate. :) Inviato da iPhone Il giorno 20/gen/2010, alle ore 16.30, "Kevin Grittner" > ha scritto: Dimitri Fontaine wr

Re: [HACKERS] Mentors needed urgently for SoC & PostgreSQL Student Internships

). :( However, thanks again for keeping us informed. Ciao, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make