{"groups": [{"id": 2, "name": "User lists", "sort": 10}, {"id": 1, "name": "Developer lists", "sort": 20}, {"id": 4, "name": "Regional lists", "sort": 30}, {"id": 8, "name": "Associations", "sort": 35}, {"id": 6, "name": "User groups", "sort": 40}, {"id": 5, "name": "Project lists", "sort": 50}, {"id": 7, "name": "Inactive lists", "sort": 1000}], "lists": [{"id": 56, "name": "Adelaide, AU", "groupid": 7, "active": false, "shortdesc": "Adelaide, AU", "description": "Adelaide, Australia"}, {"id": 57, "name": "Am\u00e9rica Central", "groupid": 7, "active": false, "shortdesc": "Am\u00e9rica Central", "description": "Am\u00e9rica Central"}, {"id": 58, "name": "Arizona, US", "groupid": 7, "active": false, "shortdesc": "Arizona, US", "description": "Arizona, US"}, {"id": 59, "name": "Atlanta, GA, US", "groupid": 7, "active": false, "shortdesc": "Atlanta, GA, US", "description": "Atlanta, Georgia, USA"}, {"id": 62, "name": "Baltimore/DC, US", "groupid": 7, "active": false, "shortdesc": "Baltimore/DC, US", "description": "Baltimore/Washington DC, USA"}, {"id": 61, "name": "Boston, MA, US", "groupid": 7, "active": false, "shortdesc": "Boston, MA, US", "description": "Boston, Massachusetts, USA"}, {"id": 60, "name": "Buenos Aires, AR", "groupid": 7, "active": false, "shortdesc": "Buenos Aires, AR", "description": "Buenos Aires, Argentina"}, {"id": 63, "name": "Denver, CO, US", "groupid": 7, "active": false, "shortdesc": "Denver, CO, US", "description": "Denver, Colorado, US"}, {"id": 81, "name": "Dutch", "groupid": 7, "active": false, "shortdesc": "Dutch", "description": "Dutch PostgreSQL Community"}, {"id": 66, "name": "Gauteng, ZA", "groupid": 7, "active": false, "shortdesc": "Gauteng, ZA", "description": "Johannesburg and Pretoria, South Africa"}, {"id": 64, "name": "Hyderabad, India", "groupid": 7, "active": false, "shortdesc": "Hyderabad, India", "description": "Hyderabad, India"}, {"id": 65, "name": "Ireland", "groupid": 7, "active": false, "shortdesc": "Ireland", "description": "Ireland"}, {"id": 67, "name": "Melbourne, AU", "groupid": 7, "active": false, "shortdesc": "Melbourne, AU", "description": "Melbourne, Australia"}, {"id": 74, "name": "Milwaukee, US", "groupid": 7, "active": false, "shortdesc": "Milwaukee, US", "description": "Milwaukee, Wisconsin, USA"}, {"id": 68, "name": "Montr\u00e9al, CA", "groupid": 7, "active": false, "shortdesc": "Montr\u00e9al, CA", "description": "Montr\u00e9al, Qu\u00e9bec, Canada"}, {"id": 69, "name": "Mumbai, IN", "groupid": 7, "active": false, "shortdesc": "Mumbai, IN", "description": "Mumbai, India"}, {"id": 70, "name": "Norway", "groupid": 7, "active": false, "shortdesc": "Norway", "description": "Norway"}, {"id": 71, "name": "Ohio, US", "groupid": 7, "active": false, "shortdesc": "Ohio, US", "description": "Ohio, USA"}, {"id": 72, "name": "Oklahoma, US", "groupid": 7, "active": false, "shortdesc": "Oklahoma, US", "description": "Oklahoma, USA"}, {"id": 73, "name": "Persian", "groupid": 7, "active": false, "shortdesc": "Persian", "description": "Persian PostgreSQL Community"}, {"id": 89, "name": "RGNPUG", "groupid": 7, "active": false, "shortdesc": "RGNPUG", "description": "RGNPUG"}, {"id": 90, "name": "San Diego, US", "groupid": 7, "active": false, "shortdesc": "San Diego, US", "description": "San Diego, US"}, {"id": 92, "name": "San Francisco, CA, US", "groupid": 7, "active": false, "shortdesc": "San Francisco, CA, US", "description": "San Francisco, California, USA"}, {"id": 91, "name": "South East Asia", "groupid": 7, "active": false, "shortdesc": "South East Asia", "description": "South East Asia"}, {"id": 94, "name": "Stockholm, Sweden", "groupid": 7, "active": false, "shortdesc": "Stockholm, Sweden", "description": "Stockholm, Sweden"}, {"id": 93, "name": "Suncoast, FL, US", "groupid": 7, "active": false, "shortdesc": "Suncoast, FL, US", "description": "Suncoast, Florida, USA"}, {"id": 95, "name": "Sydney, AU", "groupid": 7, "active": false, "shortdesc": "Sydney, AU", "description": "Sydney, Australia"}, {"id": 96, "name": "Toronto, CA", "groupid": 7, "active": false, "shortdesc": "Toronto, CA", "description": "Toronto, Canada"}, {"id": 97, "name": "Triangle, NC, US", "groupid": 7, "active": false, "shortdesc": "Triangle, NC, US", "description": "Research Triangle, North Carolina, USA"}, {"id": 98, "name": "Venezuela", "groupid": 7, "active": false, "shortdesc": "Venezuela", "description": "Venezuela"}, {"id": 35, "name": "arpug", "groupid": 6, "active": true, "shortdesc": "arpug", "description": "Argentina"}, {"id": 36, "name": "austinpug", "groupid": 6, "active": true, "shortdesc": "austinpug", "description": "Austin, Texas, USA"}, {"id": 12, "name": "buildfarm-members", "groupid": 1, "active": true, "shortdesc": "buildfarm-members", "description": "Discussion list for buildfarm animal caretakers"}, {"id": 37, "name": "ecpug", "groupid": 6, "active": true, "shortdesc": "ecpug", "description": "Ecuador"}, {"id": 38, "name": "karlsruhe-de-pug", "groupid": 6, "active": true, "shortdesc": "karlsruhe-de-pug", "description": "Karlsruhe, Germany"}, {"id": 39, "name": "lapug", "groupid": 6, "active": true, "shortdesc": "lapug", "description": "Los Angeles, USA"}, {"id": 40, "name": "pdxpug", "groupid": 6, "active": true, "shortdesc": "pdxpug", "description": "Portland, USA"}, {"id": 42, "name": "pgadmin-hackers", "groupid": 5, "active": true, "shortdesc": "pgadmin-hackers", "description": "pgAdmin development and patches."}, {"id": 43, "name": "pgadmin-support", "groupid": 5, "active": true, "shortdesc": "pgadmin-support", "description": "pgAdmin support questions."}, {"id": 33, "name": "pgeu-general", "groupid": 8, "active": true, "shortdesc": "pgeu-general", "description": "European PostgreSQL Community"}, {"id": 44, "name": "pgpool-buildfarm", "groupid": 5, "active": true, "shortdesc": "pgpool-buildfarm", "description": "Pgpool buildfarm results."}, {"id": 45, "name": "pgpool-committers", "groupid": 5, "active": true, "shortdesc": "pgpool-committers", "description": "Pgpool commit messages."}, {"id": 46, "name": "pgpool-general", "groupid": 5, "active": true, "shortdesc": "pgpool-general", "description": "General discussion of pgpool."}, {"id": 47, "name": "pgpool-hackers", "groupid": 5, "active": true, "shortdesc": "pgpool-hackers", "description": "Hackers discussion of pgpool."}, {"id": 2, "name": "pgsql-admin", "groupid": 2, "active": true, "shortdesc": "pgsql-admin", "description": "PostgreSQL administration (excludes pgAdmin application support, which can be found on the pgadmin-support list)"}, {"id": 3, "name": "pgsql-advocacy", "groupid": 2, "active": true, "shortdesc": "pgsql-advocacy", "description": "Coordinates people working on promoting PostgreSQL, organizing user groups, and dealing with PostgreSQL marketing and PR. Also a good place to ask for presentations and flyers if you need them."}, {"id": 4, "name": "pgsql-announce", "groupid": 2, "active": true, "shortdesc": "pgsql-announce", "description": "Announcement list pertaining to PostgreSQL and various third party software."}, {"id": 75, "name": "pgsql-benchmarks", "groupid": 7, "active": false, "shortdesc": "pgsql-benchmarks", "description": "Discussion of PostgreSQL and benchmarks."}, {"id": 13, "name": "pgsql-bugs", "groupid": 1, "active": true, "shortdesc": "pgsql-bugs", "description": "If you find a bug, please use thebug reporting form."}, {"id": 76, "name": "pgsql-chat", "groupid": 7, "active": false, "shortdesc": "pgsql-chat", "description": "General chit-chat."}, {"id": 77, "name": "pgsql-cluster-hackers", "groupid": 7, "active": false, "shortdesc": "pgsql-cluster-hackers", "description": "Discussion of adding replication and clustering features to PostgreSQL, both inside the database and via integration with additional software."}, {"id": 14, "name": "pgsql-committers", "groupid": 1, "active": true, "shortdesc": "pgsql-committers", "description": "Notification of git commits are sent to this list. Do not post here!"}, {"id": 78, "name": "pgsql-cygwin", "groupid": 7, "active": false, "shortdesc": "pgsql-cygwin", "description": "Former discussion of running, compiling, installing PostgreSQL under Windows, using cygwin."}, {"id": 21, "name": "pgsql-de-allgemein", "groupid": 4, "active": true, "shortdesc": "pgsql-de-allgemein", "description": "German PostgreSQL Community"}, {"id": 15, "name": "pgsql-docs", "groupid": 1, "active": true, "shortdesc": "pgsql-docs", "description": "Discussion regarding PostgreSQL documentation."}, {"id": 22, "name": "pgsql-es-ayuda", "groupid": 4, "active": true, "shortdesc": "pgsql-es-ayuda", "description": "En esta lista se discuten los temas t\u00e9cnicos de PostgreSQL en espa\u00f1ol. Los t\u00f3picos de fomento y promoci\u00f3n deben discutirse en la lista pgsql-es-fomento."}, {"id": 23, "name": "pgsql-es-fomento", "groupid": 4, "active": true, "shortdesc": "pgsql-es-fomento", "description": "En esta lista se discuten los t\u00f3picos de fomento y promoci\u00f3n de PostgreSQL en espa\u00f1ol. Los temas t\u00e9cnicos deben ser tratados en la lista pgsql-es-ayuda."}, {"id": 24, "name": "pgsql-es-trabajos", "groupid": 4, "active": true, "shortdesc": "pgsql-es-trabajos", "description": "Anuncios de puestos de trabajo en castellano"}, {"id": 25, "name": "pgsql-fr-generale", "groupid": 4, "active": true, "shortdesc": "pgsql-fr-generale", "description": "French PostgreSQL Community"}, {"id": 5, "name": "pgsql-general", "groupid": 2, "active": true, "shortdesc": "pgsql-general", "description": "General discussion area for users. Apart from compile, acceptance test, and bug problems, most new users will probably only be interested in this mailing list (unless they want to contribute to development or documentation). All non-bug related questions regarding PostgreSQL's version of SQL, and all installation related questions that do not involve bugs or failed compiles, should be restricted to this area. Please note that many of the developers monitor this area."}, {"id": 16, "name": "pgsql-gui-dev", "groupid": 1, "active": true, "shortdesc": "pgsql-gui-dev", "description": "Development of GUI tools for use with PostgreSQL"}, {"id": 17, "name": "pgsql-hackers", "groupid": 1, "active": true, "shortdesc": "pgsql-hackers", "description": "The PostgreSQL developers team lives here. Discussion of current development issues, problems and bugs, and proposed new features. If your question cannot be answered by people in the other lists, and it is likely that only a developer will know the answer, you may re-post your question in this list. You must try elsewhere first!"}, {"id": 79, "name": "pgsql-hackers-pitr", "groupid": 7, "active": false, "shortdesc": "pgsql-hackers-pitr", "description": "Former discussion related to the implementation of the PITR feature."}, {"id": 80, "name": "pgsql-hackers-win32", "groupid": 7, "active": false, "shortdesc": "pgsql-hackers-win32", "description": "Former discussion of issues relating to the native Win32 port of PostgreSQL. Current win32 development issues should be raised on -hackers."}, {"id": 26, "name": "pgsql-in-general", "groupid": 4, "active": true, "shortdesc": "pgsql-in-general", "description": "Indian PostgreSQL Community"}, {"id": 6, "name": "pgsql-interfaces", "groupid": 2, "active": true, "shortdesc": "pgsql-interfaces", "description": "Discussion of PostgreSQL interfaces, except JDBC and ODBC."}, {"id": 27, "name": "pgsql-it-generale", "groupid": 4, "active": true, "shortdesc": "pgsql-it-generale", "description": "Italian Developer Community General Discussions"}, {"id": 28, "name": "pgsql-iw-general", "groupid": 4, "active": true, "shortdesc": "pgsql-iw-general", "description": "Hebrew PostgreSQL Community"}, {"id": 48, "name": "pgsql-jdbc", "groupid": 5, "active": true, "shortdesc": "pgsql-jdbc", "description": "Discussion of PostgreSQL's Java interface, JDBC."}, {"id": 49, "name": "pgsql-jdbc-commits", "groupid": 5, "active": true, "shortdesc": "pgsql-jdbc-commits", "description": "JDBC driver commit messages"}, {"id": 7, "name": "pgsql-jobs", "groupid": 2, "active": true, "shortdesc": "pgsql-jobs", "description": "Posting of PostgreSQL related jobs."}, {"id": 8, "name": "pgsql-novice", "groupid": 2, "active": true, "shortdesc": "pgsql-novice", "description": "No question is too simple for this list."}, {"id": 50, "name": "pgsql-odbc", "groupid": 5, "active": true, "shortdesc": "pgsql-odbc", "description": "Discussion of PostgreSQL's ODBC interface."}, {"id": 82, "name": "pgsql-patches", "groupid": 7, "active": false, "shortdesc": "pgsql-patches", "description": "Obsolete list for posting patches to the PostgreSQL source code.  Those must now be sent to pgsql-hackers."}, {"id": 18, "name": "pgsql-perffarm", "groupid": 1, "active": true, "shortdesc": "pgsql-perffarm", "description": "pgsql-perffarm"}, {"id": 9, "name": "pgsql-performance", "groupid": 2, "active": true, "shortdesc": "pgsql-performance", "description": "Discussion of PostgreSQL's performance issues.  Please seeGuide to reporting problemsandSlow Query Questionsfor some tips on how to write your performance question."}, {"id": 83, "name": "pgsql-php", "groupid": 7, "active": false, "shortdesc": "pgsql-php", "description": "Using PostgreSQL with PHP."}, {"id": 51, "name": "pgsql-pkg-debian", "groupid": 5, "active": true, "shortdesc": "pgsql-pkg-debian", "description": "Discussion of Debian packaging"}, {"id": 84, "name": "pgsql-pkg-docker", "groupid": 7, "active": false, "shortdesc": "pgsql-pkg-docker", "description": "Official PostgreSQL images for Docker on DockerHub"}, {"id": 52, "name": "pgsql-pkg-yum", "groupid": 5, "active": true, "shortdesc": "pgsql-pkg-yum", "description": "YUM packaging"}, {"id": 85, "name": "pgsql-ports", "groupid": 7, "active": false, "shortdesc": "pgsql-ports", "description": "Former discussion about porting to and compiling PostgreSQL on various different platforms.  Current discussion should be carried out on pgsql-hackers."}, {"id": 29, "name": "pgsql-pt-geral", "groupid": 4, "active": true, "shortdesc": "pgsql-pt-geral", "description": "Lista de discuss\u00e3o por email no idioma Portugu\u00eas (Brasil/Portugal)"}, {"id": 86, "name": "pgsql-rrreviewers", "groupid": 7, "active": false, "shortdesc": "pgsql-rrreviewers", "description": "This mailing list supports Round Robin Review during commitfests by allowing the CommitFest Mom to assign random patches to a list of volunteer reviewers. Discussion of the contents of the patches takes place on pgsql-hackers and NOT here, so only sign up for this list if you're volunteering to be assigned a patch!"}, {"id": 30, "name": "pgsql-ru-general", "groupid": 4, "active": true, "shortdesc": "pgsql-ru-general", "description": "Russian PostgreSQL Community"}, {"id": 10, "name": "pgsql-sql", "groupid": 2, "active": true, "shortdesc": "pgsql-sql", "description": "Discussion for users on SQL related matters."}, {"id": 87, "name": "pgsql-students", "groupid": 7, "active": false, "shortdesc": "pgsql-students", "description": "Google's Summer of Code students"}, {"id": 88, "name": "pgsql-testers", "groupid": 7, "active": false, "shortdesc": "pgsql-testers", "description": "For active testers of PostgreSQL Alphas and Betas to report test results."}, {"id": 31, "name": "pgsql-tr-genel", "groupid": 4, "active": true, "shortdesc": "pgsql-tr-genel", "description": "Turkish PostgreSQL Community"}, {"id": 19, "name": "pgsql-translators", "groupid": 1, "active": true, "shortdesc": "pgsql-translators", "description": "Translation announcements, coordination and discussions"}, {"id": 11, "name": "pgsql-women", "groupid": 2, "active": true, "shortdesc": "pgsql-women", "description": "Discussion about how to increase the number of women in the PostgreSQL international community.  All genders welcome."}, {"id": 20, "name": "pgsql-www", "groupid": 1, "active": true, "shortdesc": "pgsql-www", "description": "Discussion of development and coordination of the PostgreSQL websites."}, {"id": 32, "name": "pgsql-zh-general", "groupid": 4, "active": true, "shortdesc": "pgsql-zh-general", "description": "Chinese PostgreSQL Community"}, {"id": 34, "name": "pgus-general", "groupid": 8, "active": true, "shortdesc": "pgus-general", "description": "US PostgreSQL Community"}, {"id": 53, "name": "pljava-dev", "groupid": 5, "active": true, "shortdesc": "pljava-dev", "description": "PL/Java development"}, {"id": 54, "name": "psycopg", "groupid": 5, "active": true, "shortdesc": "psycopg", "description": "Discussion about the Python interface Psycopg"}, {"id": 41, "name": "seapug", "groupid": 6, "active": true, "shortdesc": "seapug", "description": "Seattle, USA"}, {"id": 55, "name": "wal-g", "groupid": 5, "active": true, "shortdesc": "wal-g", "description": "Discussion about the WAL-G  backup tool"}]}