Le blog de Jean David TECHER, un Réunionnais à Saint-Priest/Lyon

Sent by Steve Singer on Slony's mailing-list

The Slony-I team is pleased to announce the release of Slony-I 2.1.1 a bug fix release for the 2.1 stream. and Slony-I 1.2.23 a bug fix release in the 1.2 stream.

Slony 2.1.1

• Bug #260 :: Fixed issue when with FAILOVER command when the failed node has multiple sets.
• Bug #246 :: Include path order changes
• Bug #161 :: fix memory overrun in EXECUTE SCRIPT parser
• Bug #247 :: slony_logshipper to handle TRUNCATE commands
• Bug #249 :: Add parentheses to txid_current() in function for TRUNCATE logging
• slonik_drop_table and slonik_drop_sequence no longer attempt to return -1 on an error (invalid as a slonik exit code in 2.1)
• Bug #244 :: The CREATE SET command now requires a set id to be specified.
• Bug #255 :: Fix serialization conflict issues when using PostgreSQL 9.1.
• Bug #256 :: set_conf_option() has an extra elevel parameter on PG 9.2
• Bug #259 :: Fix TRUNCATE logging so it works with mixed case slony clusters.

1. http://www.slony.info/downloads/2.1/source/slony1-2.1.1.tar.bz2
2. http://www.slony.info/downloads/2.1/source/slony1-2.1.1-docs.tar.bz2

Slony 1.2.23

• Bug #195 - make slon_quote_* functions immutable
• Bug #209 - dollar quoting doesn't work on PG 7.4
• Bug #224 - PKEYEDTABLES misspelled in altperl script
• Bug #236 - fix misformatting of log string for timestamp
• Bug #239 - Fix FAILOVER on PG 9.0 by not querying pg_listener

1. http://www.slony.info/downloads/1.2/source/slony1-1.2.23.tar.bz2
2. http://www.slony.info/downloads/1.2/source/slony1-1.2.23-docs.tar.bz2

Unless additional maintainers from the community step up 1.2.23 is likely to be the last 1.2.x release.

Here are a few instructions for a personal use of FFmpeg before trying to compil FFmpeg yourself. The static binary was compiled with all the usual libraries.

1. Download

• Download the file from mediafire.com: http://www.mediafire.com/?lrttgjj4uclqhrx
• Uncompress

  tar cvjf ffmpeg-0.10-linux_static-x86.tar.bz2

• Check that it is a static binary

2. Examples for differents filters

2.1 Convert WMV to MP4 (x264/AAC+) with frei0r perspective effect

We will conver the video file jana_fotel.wmv to jana_fotel.mp4

./ffmpeg -i jana_fotel.wmv -vf "frei0r=perspective:0.2/0.2:0.8/0.2" -acodec libaacplus -ac 2 -ar 44100 -ab 64k -vcodec libx264 -crf 22  -threads 0 -b:v 550k -qmin 10 -qmax 30 -threads 0 jana_fotel.mp4

Now we extract two images taken at "00:02:14" from the two videos:

• ./ffmpeg -i jana_fotel.wmv  -an -ss "00:02:14" -r 1 -vframes 1  -f mjpeg -s 400x300 jana_fotel_wmv.jpeg

  
  Extracted image from original video (jana_fotel.wmv) at 00:02:14

• ./ffmpeg -i jana_fotel.mp4  -an -ss "00:02:14" -r 1 -vframes 1  -f mjpeg -s 400x300  jana_fotel_mp4.jpeg

  
  Extracted image from converted video (jana_fotel.mp4) with frei0r perspective effect at 00:02:14

I love this effect!

2.2 Delogo filter

1. We extracted an original image at 00:00:06

   ./ffmpeg  -i  jana_fotel.wmv  -an -ss "00:00:06"  -r 1 -vframes 1  -f mjpeg -y extracted_image_with_logo.jpeg
   convert extracted_image_with_logo.jpeg -resize 400x300 extracted_image_with_logo.jpeg

   Here is the image
2. Do the same but without logo

   ./ffmpeg  -i  jana_fotel.wmv -vf "delogo=572:555:202:39:0" -an -ss "00:00:06"  -r 1 -vframes 1  -f mjpeg -y extracted_image_without_logo.jpeg
   convert extracted_image_without_logo.jpeg -resize 400x300 extracted_image_without_logo.jpeg

   Here is the image

2.3 Adding subtitles (libass)

The final result will be something like

1. We use the following file - subtitle.ass - for the subtitles

   [Script Info]
   Title: Default Subtitle
   ScriptType: v4.00+
   WrapStyle: 0
   PlayResX: 640
   PlayResY: 480
   ScaledBorderAndShadow: yes
   Video Aspect Ratio: 0
   Video Zoom: 6
   Video Position: 0
   Last Style Storage: Default
   
   [V4+ Styles]
   Format: Name, Fontname, Fontsize, PrimaryColour, SecondaryColour, OutlineColour, BackColour, Bold, Italic, Underline, StrikeOut, ScaleX, ScaleY, Spacing, Angle, BorderStyle, Outline, Shadow, Alignment, MarginL, MarginR, MarginV, Encoding
   Style: Default,Nimbus Sans L,35,&H00FFFFFF,&H000000FF,&H00000000,&H00000000,0,0,0,0,100,100,0,0,1,2,1,2,10,10,10,1
   
   [Events]
   Format: Layer, Start, End, Style, Name, MarginL, MarginR, MarginV, Effect, Text
   Dialogue: 0,0:00:00.00,0:00:02.00,Default,,0000,0000,0000,,JANA DEFI IS THE MOST BEAUTIFULL MODEL ON THE WEB
   Dialogue: 0,0:00:02.00,0:00:04.00,Default,,0000,0000,0000,,Jana Defi is the best model\N for my FFmpeg's test
   Dialogue: 0,0:00:04.00,0:00:06.00,Default,,0000,0000,0000,,Jana I hope you come back... 
   Dialogue: 0,0:00:06.00,0:00:10.00,Default,,0000,0000,0000,,Something is missing\N...FFmpeg tests are different without U 
   

2. We add the subtitle to the video using libASS

   ./ffmpeg -i jana_fotel.wmv -vf "ass=subtitle.ass"  -t "00:00:10" -sameq -y -s 400x300 jana_fotel_2.wmv

 /root/ffmpeg -i jana_fotel.wmv -vcodec libx264 -vpre hq -crf 26 -threads 0 -acodec libaacplus -ac 2 -ar 44100 -ab 64k -s svga -y jana_fotel.mp4

wget -q -U Firefox http://www.venus360.com/gallery/jordan-carver-59/Jordan-Carver-Mistress.jpg
seq -w 2 20 |xargs -i wget -q -U Firefox http://www.venus360.com/gallery/jordan-carver-59/Jordan-Carver-Mistress_{}.jpg
zip Jordan-Carver-Mistress.zip Jordan-Carver-Mistress*
rm -vf Jordan-Carver-Mistress*jpg

Projet PS3 Media Server à regarder de près http://www.ps3mediaserver.org/forum/viewtopic.php?f=3&t=12110#p57416