Hi Simon and Michael,
2016-08-23 10:39 GMT+02:00 Simon Riggs <si...@2ndquadrant.com>:
>
> 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, Servi
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, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
0001
Hi Bruce,
2015-03-08 5:37 GMT+11:00 Bruce Momjian br...@momjian.us:
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
Hi Robert,
2015-03-07 2:57 GMT+11:00 Robert Haas robertmh...@gmail.com:
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,
Hi Robert,
2015-03-06 3:10 GMT+11:00 Robert Haas robertmh...@gmail.com:
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
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 marco.nenciar...@2ndquadrant.it
:
Il 13/01/15 12:53, Gabriele Bartolini ha scritto:
Hi Marco,
could
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
Hello,
2014-10-06 17:51 GMT+02:00 Marco Nenciarini marco.nenciar...@2ndquadrant.it
:
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
Hi Claudio,
2014-08-12 15:25 GMT+02:00 Claudio Freire klaussfre...@gmail.com:
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
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
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
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 klaussfre...@gmail.com
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
--
Gabriele Bartolini - 2ndQuadrant Italia
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
PostgreSQL Training, Services and Support
-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
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL
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 list (pgsql-hackers
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
index 4ec6981
it.
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 your subscription:
http
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
--
Gabriele
/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
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
Foreign Keys with Arrays
TABLE
CREATE TABLE races (
race_id integer PRIMARY KEY,
title text,
race_day DATE,
...
final_positions integer[]
);
ALTER TABLE races ADD FOREIGN KEY (ELEMENT final_positions) REFERENCES
drivers;
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services
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 literal).
So: Array ELEMENT Foreign Key
+1 for me
And it can be also interchanged with Array element Foreign Key.
--
Gabriele
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
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 mailing list
and it is 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
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...@2ndquadrant.it | www.2ndQuadrant.it
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
() 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
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.patch.bz2
=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 your
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 Support
gabriele.bartol
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
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 Training, Services and Support
gabriele.bartol...@2ndquadrant.it
, 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@postgresql.org)
To make changes to your
,
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 const char
|-|-|
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 Support
is the action
that makes more sense anyway).
I believe that, before we proceed with one implementation or another, it
is important we discuss this sort of things and agree on a possible
long-term path (so that we can organise intermediate deliverables).
Thanks,
Gabriele
--
Gabriele
:
* Gabriele Bartolini gabriele.bartol...@2ndquadrant.it
* Marco Nenciarini marco.nenciar...@2ndquadrant.it
Cheers,
Gabriele (and Marco)
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it | www.2ndQuadrant.it
*** a/doc/src/sgml
:
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
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 Bartolini
that it 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
attachment: smooth
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 Training, Services
).
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/commands
/src/sgml/Makefile
doc/src/sgml/filelist.sgml
doc/src/sgml/postgres.sgml
doc/src/sgml/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
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 Support
gabriele.bartol
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-hackers mailing
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 and Support
to hearing from you, and seeing you in Rome in December!
Gabriele Bartolini
Italian PostgreSQL Users Group (ITPUG), President
be 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
-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-hackers mailing
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 kevin.gritt...@wicourts.gov
ha
, 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 changes to your
53 matches
Mail list logo