[Bug 48896] Please install Postgresql on Tool-labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=48896 Alexandros Kosiaris changed: What|Removed |Added Status|ASSIGNED|RESOLVED Resolution|--- |FIXED --- Comment #15 from Alexandros Kosiaris --- Indeed it can. Closing it. Thanks Silke -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 48896] Please install Postgresql on Tool-labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=48896 --- Comment #14 from Silke Meyer (WMDE) --- So, can this ticket be closed? -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 48896] Please install Postgresql on Tool-labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=48896 Nemo changed: What|Removed |Added CC||federicol...@tiscali.it Blocks||58791 -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 48896] Please install Postgresql on Tool-labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=48896 Alexandros Kosiaris changed: What|Removed |Added CC||akosia...@wikimedia.org --- Comment #13 from Alexandros Kosiaris --- PostgreSQL master/server databases are good and ready to go labsdb1004 is the master, labsdb1005 is the slave. Streaming asynchronous replication is setup between them, as configured by the puppet module. Some minor manual steps to get the architecture fully working will be documented in the puppet module. PostGIS is scheduled to be enabled soon. OSM syncing from planet.osm still needs some work and will be ready ASAP. -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 48896] Please install Postgresql on Tool-labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=48896 silke.me...@wikimedia.de changed: What|Removed |Added Priority|Normal |High --- Comment #12 from silke.me...@wikimedia.de --- Postgresql might be also needed to keep the toolserver wiki somewhere in Tool Labs (see #60220). Giving high priority for after the migration to equiad. -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 48896] Please install Postgresql on Tool-labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=48896 Merlijn van Deen changed: What|Removed |Added Blocks||58797 -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 48896] Please install Postgresql on Tool-labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=48896 --- Comment #11 from kolossos --- Thanks for the info. -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 48896] Please install Postgresql on Tool-labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=48896 --- Comment #10 from Marc A. Pelletier --- The hardware has been set aside for it in eqiad (the datacenter labs is moving to). Since we are moving all of labs, it didn't seem reasonable to set it up for a month and then have to migrate it, so the postgresql instance will be available in the new location (we are gunning for early Feb). -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 48896] Please install Postgresql on Tool-labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=48896 --- Comment #9 from kolossos --- Is there an schedule for it? I read something about Postgresql-server for Labs in the WMF engineering report of November. -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 48896] Please install Postgresql on Tool-labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=48896 --- Comment #8 from kolossos --- One tool which is waiting for it is Wikipedia coordinates [1], which is with 6 Mio. entries relatively small but often used. This tool is independent from OSM and was the reason for me to open this ticket, because it seems to be an easy task. Other tools like WIWOSM, Addtags, ... need off course the full OSM database. Existing OSM tools can be found here [2] (by using the search function). If the database in WMF production is now running I hope we can get OSM database in Labs really soon. Greetings [1]https://de.wikipedia.org/wiki/Wikipedia:WikiProjekt_Georeferenzierung/Wikipedia-World/en [2]https://www.mediawiki.org/wiki/Wikimedia_Labs/Tool_Labs/List_of_Toolserver_Tools -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 48896] Please install Postgresql on Tool-labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=48896 --- Comment #7 from silke.me...@wikimedia.de --- This is for the part of OSM that is going to move to the Wikimedia Labs. -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 48896] Please install Postgresql on Tool-labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=48896 --- Comment #6 from Andre Klapper --- Silke: Do you know tools which are waiting for this (Postgres on Tool labs)? -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 48896] Please install Postgresql on Tool-labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=48896 Sumana Harihareswara changed: What|Removed |Added Priority|Unprioritized |Normal CC||silke.me...@wikimedia.de, ||suma...@wikimedia.org --- Comment #5 from Sumana Harihareswara --- Silke, what tools are waiting on this? -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 48896] Please install Postgresql on Tool-labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=48896 Andre Klapper changed: What|Removed |Added CC||benap...@gmail.com, ||t...@tim-landscheidt.de Component|[Other] |tools Product|Tools |Wikimedia Labs --- Comment #4 from Andre Klapper --- [moving from "Tools" to "WM Labs > tools"] -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 48896] Please install Postgresql on Tool-labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=48896 --- Comment #3 from kolossos --- Nice things possible with psql would be: *Have PostGIS to play with Wikipedia-coordinates or other geospatial data as mention before. *pgsql has a nice key-values store (hstore) *pgsql starts to support JSON[1]. This is perhaps a really nice way to make data from WikiDATA accessible. [1]http://www.postgresql.org/docs/9.3/static/functions-json.html -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 48896] Please install Postgresql on Tool-labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=48896 Marc A. Pelletier changed: What|Removed |Added Status|NEW |ASSIGNED --- Comment #2 from Marc A. Pelletier --- We are currently working on setting up a Mysql DB on physical servers for Labs' use; given that there are also nice things that can be done with a working pgsql in general (testing mw against it comes to mind), I think this should be provided as a general service. The current mysql DB plan calls for a master/slave setup, it'd be easy to set up a postgres server on those same servers as well -- switching roles so that performance is distributed. -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 48896] Please install Postgresql on Tool-labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=48896 Marc A. Pelletier changed: What|Removed |Added CC||aude.w...@gmail.com --- Comment #1 from Marc A. Pelletier --- *** Bug 51885 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
[Bug 48896] Please install Postgresql on Tool-labs
https://bugzilla.wikimedia.org/show_bug.cgi?id=48896 kolossos changed: What|Removed |Added Assignee|wikibugs-l@lists.wikimedia. |m...@uberbox.org |org | -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. ___ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l