Thread: French govt says : "use PostgreSQL for your production databases"

Hi guys,

In sept. 2012, The French Prime Minister sent a letter to every gov.
agencies urging them to use Free Software. Of course, this document was
not very specific on which open source project were recommended.
Although PostgreSQL was already quoted directly with a sentence saying:

« Promote the migration from proprietary databases to free databases,
especially PostgreSQL. »

See the message below for more details
http://www.postgresql.org/message-id/505DA7CB.1070205@dalibo.info

Over the past 18 month we've seen that this letter had a great impact on
most of the public administration.

Last month, the French went one step further by issuing a "Free Software
Technical Platform" (Socle Logiciel Libre in French) which is basically
a big list of all the open source project that are recommended for every
specific usage an agency could have. Jenkins is recommended for CI,
LibreOffice for Spreadsheet, Bind for DNS, etc., etc., etc.

In the "production database" category, PostgreSQL is the one and only
recommendation. PostGIS is the recommendation for "GIS production
database". MariaDB is only recommended as a replacement for MySQL.

Here's the link to the complete list (it's in French but the list kinda
speaks for itself):
http://references.modernisation.gouv.fr/sites/default/files/SILL-2014-socle-interminist%C3%A9riel-logiciels-libres.pdf

More details here about the platform here (in French too)
http://references.modernisation.gouv.fr/socle-logiciels-libres

This is another great move from the French Gov toward free software in
general and PostgreSQL in particular. I don't know any other government
doing such a public effort to move from proprietary database (if you do
please share !) .

Anyway, what's not said directly in this Technical Platform is that some
gov. agencies are not only switching to PostgreSQL to reduce costs. They
fully embrace the open source philosophy and sometimes contribute to the
projects they use. Over the last months, at least 2 ministries have
contributed to two migration tools, namely :

-> An assessment/reporting feature for ora2pg 10.x in 2012
https://github.com/darold/ora2pg/blob/master/changelog#L306

-> A migration tool from SQL Server Database to PG in 2013
https://github.com/dalibo/sqlserver2pgsql


In a nutshell, we're in the middle of a nice and warm virtuous circle :)
I expect that more good news will come from France in the forthcoming
months and that other governments may follow this example !

If you need more details on the Free Software Technical Platform, please
let me know and I'll try to help as much as I can.

Regards,

--
damien clochard

damien clochard <damien@dalibo.info> writes:

> Hi guys,
>
> In sept. 2012, The French Prime Minister sent a letter to every gov.
> agencies urging them to use Free Software. Of course, this document was
> not very specific on which open source project were recommended.
> Although PostgreSQL was already quoted directly with a sentence saying:
>
> « Promote the migration from proprietary databases to free databases,
> especially PostgreSQL. »

Vive la France!

On 31/03/2014 12:09, hari.fuchs@gmail.com wrote:
> damien clochard <damien@dalibo.info> writes:
>
>> Hi guys,
>>
>> In sept. 2012, The French Prime Minister sent a letter to every gov.
>> agencies urging them to use Free Software. Of course, this document was
>> not very specific on which open source project were recommended.
>> Although PostgreSQL was already quoted directly with a sentence saying:
>>
>> « Promote the migration from proprietary databases to free databases,
>> especially PostgreSQL. »
>
> Vive la France!

Indeed - allez les bleus! (I'm a rugby fan).

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

On Mon, Mar 31, 2014 at 8:09 PM,  <hari.fuchs@gmail.com> wrote:
> damien clochard <damien@dalibo.info> writes:
>
>> Hi guys,
>>
>> In sept. 2012, The French Prime Minister sent a letter to every gov.
>> agencies urging them to use Free Software. Of course, this document was
>> not very specific on which open source project were recommended.
>> Although PostgreSQL was already quoted directly with a sentence saying:
>>
>> « Promote the migration from proprietary databases to free databases,
>> especially PostgreSQL. »
>
> Vive la France!
+1.
--
Michael

On 03/31/2014 05:47 AM, Michael Paquier wrote:
> On Mon, Mar 31, 2014 at 8:09 PM,  <hari.fuchs@gmail.com> wrote:
>> damien clochard <damien@dalibo.info> writes:
>>
>>> Hi guys,
>>>
>>> In sept. 2012, The French Prime Minister sent a letter to every gov.
>>> agencies urging them to use Free Software. Of course, this document was
>>> not very specific on which open source project were recommended.
>>> Although PostgreSQL was already quoted directly with a sentence saying:
>>>
>>> « Promote the migration from proprietary databases to free databases,
>>> especially PostgreSQL. »
>>
>> Vive la France!
> +1.
>

So, will pg.EU be back in France this year?  Maybe Marseilles?  ;-)

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

On Mon, Mar 31, 2014 at 07:12:35PM +0200, Magnus Hagander wrote:
> On Mon, Mar 31, 2014 at 7:06 PM, Josh Berkus <josh@agliodbs.com> wrote:
>
>     On 03/31/2014 05:47 AM, Michael Paquier wrote:
>     > On Mon, Mar 31, 2014 at 8:09 PM,  <hari.fuchs@gmail.com> wrote:
>     >> damien clochard <damien@dalibo.info> writes:
>     >>
>     >>> Hi guys,
>     >>>
>     >>> In sept. 2012, The French Prime Minister sent a letter to every gov.
>     >>> agencies urging them to use Free Software. Of course, this document was
>     >>> not very specific on which open source project were recommended.
>     >>> Although PostgreSQL was already quoted directly with a sentence saying:
>     >>>
>     >>>   Promote the migration from proprietary databases to free databases,
>     >>> especially PostgreSQL.
>     >>
>     >> Vive la France!
>     > +1.
>     >
>
>     So, will pg.EU be back in France this year?  Maybe Marseilles?  ;-)
>
>
> No, but pgday france is close to Marseilles :)

Yes, and I am attending PGDay France this year:

    http://www.pgday.fr/

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +