On Sun, Aug 21, 2011 at 2:05 AM, AI Rumman <rummandba@xxxxxxxxx> wrote: > Hi, > > I want to learn how to apply patch in Postgresql? > Recently, I got the docs > http://archives.postgresql.org/pgsql-hackers/2011-08/msg00581.php. > I want to apply the patch. > > Any guideline please? Applying the patch requires that you have the source tree downloaded and can build from there. If you've installed from a package, then you'll need to run the pg_config command that comes with your package. It's often part of the -dev or -devel package. That command will tell you all the switches used to build your package. It's often much better to test this patch on a non-production machine, so go to another machine and get the latest postgresql package that matches your major version. I.e. if you're running 8.3.5 in production you'll want to download 8.3.15. Untar it and then cd into the src directory and apply the patch something like: patch -p0 < patchfile and see if it applies. If it complains about the file not being in the right dir or something hollar back and we'll see about getting you patched up. After that, in the main postgresql directory run configure ./configure --switchsettingsfrompg_config_go_here make sudo make install Note that if this is a bit too confusing, you might wanna find someone more familiar with unix and patching and what not, as it's not a simple obvious process for first time users. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general