Re: [DOCS] Documentation and explanatory diagrams
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Bruce Momjian wrote: > Rafael Martinez wrote: >> -BEGIN PGP SIGNED MESSAGE- >> Hash: SHA1 >> >> Bruce Momjian wrote: >> [...] >>> OK, DIA sounds like it meets the requirements, and it would be good to >>> get some images into our documentation. I wonder if it could import >>> some of my xfig diagrams; if so, I could probably keep the images you >>> took from me updated in CVS. >>> >> Where can I get these xfig diagrams? I can play with them and see how it >> works to import/convert them. > > I would have to email them to you; here is one for testing: > > http://momjian.us/expire/mvcc.fig > I have been playing with this file and DIA-0.96.1 on Linux and this is the result: * Importing/converting from xfig to dia format worked with almost no problems. * DIA complained that it could not find 'Latex font 16' and that it would use 'sans' instead. An explanation about this could be what they explain in this url: http://projects.gnome.org/dia/fonts.html * The diagram was imported automatically with the right layout but without the red color in the boxes. This was fixed without problems manually. After converting this file to DIA I have generated several other formats from it. Here are they: http://folk.uio.no/rafael/pgsql_diagrams/ * png, jpeg and eps are generated with the right layout, color and font size. * xfig is generated with the right layout and color but the font size is too big * svg has big problems with the font size under google chrome and is 'almost' right under firefox. - -- Rafael Martinez, Center for Information Technology Services University of Oslo, Norway PGP Public Key: http://folk.uio.no/rafael/ -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkvVRmUACgkQBhuKQurGihREXwCdHzYcLsSw4CKnk/TT/Qh4ruAH 5MkAn1DU0UKs04YaFJaYznTxAursM64i =0ed1 -END PGP SIGNATURE- -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
Re: [DOCS] Documentation and explanatory diagrams
Rafael Martinez wrote: > I have been playing with this file and DIA-0.96.1 on Linux and this is > the result: > > * Importing/converting from xfig to dia format worked with almost no > problems. > > * DIA complained that it could not find 'Latex font 16' and that it > would use 'sans' instead. An explanation about this could be what they > explain in this url: http://projects.gnome.org/dia/fonts.html > > * The diagram was imported automatically with the right layout but > without the red color in the boxes. This was fixed without problems > manually. > > After converting this file to DIA I have generated several other formats > from it. Here are they: http://folk.uio.no/rafael/pgsql_diagrams/ > > * png, jpeg and eps are generated with the right layout, color and font > size. > > * xfig is generated with the right layout and color but the font size is > too big > > * svg has big problems with the font size under google chrome and is > 'almost' right under firefox. Looks good. I have created a tarball of all my xfig figures: http://momjian.us/expire/xfig.tgz While they are licensed as Creative Commons Attribution, you can consider them BSD-licensed for inclusion into our Postgres docs. Let me know what else I can do to help. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
[DOCS] pgpool with master/slave
I have added the attached documentation patch to explain how master/slave can be combined with pgpool to avoid the problems with non-deterministic functions. You can read more details here: http://momjian.us/main/blogs/pgblog/2010.html#April_26_2010_2 -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com Index: doc/src/sgml/high-availability.sgml === RCS file: /cvsroot/pgsql/doc/src/sgml/high-availability.sgml,v retrieving revision 1.62 diff -c -c -r1.62 high-availability.sgml *** doc/src/sgml/high-availability.sgml 21 Apr 2010 03:32:53 - 1.62 --- doc/src/sgml/high-availability.sgml 26 Apr 2010 18:06:37 - *** *** 199,205 SQL queries are broadcast (and not actual modified rows). If this is unacceptable, either the middleware or the application must query such values from a single server and then use those ! values in write queries. Also, care must be taken that all transactions either commit or abort on all servers, perhaps using two-phase commit ( and . --- 199,209 SQL queries are broadcast (and not actual modified rows). If this is unacceptable, either the middleware or the application must query such values from a single server and then use those ! values in write queries. Another option is to use this replication ! option with a traditional master-slave setup, i.e. data modification ! queries are sent only to the master and are propogated to the ! slaves via master-slave replication, not by the replication ! middleware. Care must also be taken that all transactions either commit or abort on all servers, perhaps using two-phase commit ( and . -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
