nyuuzyou/wikis huggingface dataset:
PGDay Ecuador 2014

= PGDay Ecuador 2014 =
Un PGDay es un día de charlas y talleres sobre PostgreSQL, en el que se muestran que cosas se están haciendo, que cosas se pueden hacer y que cosas se podrán hacer en futuras versiones.
Este es el cuarto de este tipo de eventos que realizamos en Ecuador.
== Patrocinadores ==
=== Platino ===
* File:Logo_2ndQ.gif‎ 
=== Oro ===
=== Plata ===
== Detalles ==
* Cuando: Martes 7 de octubre del 2014
* Donde: Universidad Tecnológica Equinoccial (UTE) - Av. Occidental y Av. Mariana de Jesús - Bloque T, 3er piso, entrando por el centro médico
* Horario: A partir de las 09h30
== Registro ==
El evento es gratuito, todos los usuarios de PostgreSQL y quienes están considerando su uso están invitados.
Aunque el registro no es obligatorio, quienes se registren aquí participarán en el sorteo de un cupo para el próximo curso de administración de PostgreSQL organizado por 2ndQuadrant.
== Agenda ==
Hora 	Charla 	Descripción 	Conferenciante 	Compañía
9:30 - 10:15 	PostgreSQL roadmap 	Conozca las características en las que se está trabajando para las siguientes versiones de PostgreSQL y descubra por que aun es el "gestor de base de datos, de código abierto, más avanzado del mundo" 	Jaime Casanova 	2ndQuadrant
10:20 - 11:05	Utilización de PostgreSQL como base de datos de sistemas de parqueo tarifado	PostgreSQL fue utilizado como motor de base de datos para el Sistema de Gestión y Control de Estacionamiento Rotativo y Tarifado - VIRTUALSAGA un sistema que permite controlar el parqueo tarifado de las ciudades a través de dispositivos móviles, impresoras térmicas y monitoreo y control en la central. PostgreSQL demostró su robustez, flexibilidad y seguridad en dicha solución.	Alcides Rivera 	VIRTUALSAMI CIA. LTDA.
11:10 - 11:55	Postgis base de datos espacial sobre postgres 	Fácil trabajo de Postgis (base de datos espacial sobre postgres) con sistemas de información geográfica open source y gratuitos como: gvSIG, KOsmo, QGIS, OpenJump para trabajar conjuntamente con servidor de mapas. 	Edwin Caillamara	Infolibre Cia. Ltda.
12:00 - 12:45	Linux HA y PostgreSql 9.3 	Breve introducción a los servicios de cluster en Postgresql y Pacemaker para un entorno de máxima disponibilidad 	Carlos Montes 	Micro Outsourcing
12:45 - 14:00	ALMUERZO 	ALMUERZO 	ALMUERZO 	ALMUERZO
14:05 - 14:50	Todo lo que quiso saber sobre PostgreSQL y temió preguntar 	Algunas dudas que han surgido continuamente y otras preguntas que escuche por ahí 	Jaime Casanova 	2ndQuadrant
14:55 - 15:40	Introducción a BDR 	Charla remota, en vivo, en la cual se presentará la nueva tecnología de replicación bi-direccional que 2ndQuadrant está agregando a PostgreSQL 	Emanuel Calvo 	2ndQuadrant
== Ubicación ==
 
Category:PostgreSQL Events
PGDay.EU, Paris 2009

PGDay.EU 2009, a collaboration between PostgreSQL Europe and PostgreSQLFR was held in Paris, France on November 6-7.
== November 6, 2009 ==
=== English track ===
==== 12:00 - 12:50 ====
==== 13:50 - 14:40 Scaling PostgreSQL Under Fire (Gavin M. Roy) (partial video) ====
==== 15:10 - 16:00 Performance Enhancements in PostgreSQL 8.4 (MagnusHagander) ====
==== 16:10 - 17:00 ====
=== French track ===
==== 11:00 - 11:50 ====
==== 12:00 - 12:50 ====
==== 13:50 - 14:40 ====
==== 15:10 - 16:00 ====
==== 16:10 - 17:00 phpPgAdmin: présentation, développement et futur du projet (Jehan-Guillaume (ioguix) de Rorthais)====
== November 7, 2009 ==
=== English track (DBA/General) ===
==== 10:00 - 10:50 Japan PostgreSQL Users Group (Junichi Tado, Hiroshi Saito, Toshiyuki Ishikawa & Kaori Inaba) ====
=== English track (Developer) ===
==== 9:00 - 9:50 ====
==== 10:00 - 10-50 ====
==== 11:20 - 12:10 ====
==== 13:10 - 14:00 Introducing portalBase - agile database development with PostgreSQL ====
==== 14:10 - 15:00 ====
=== French track ===
==== 09:00 - 09:50 MVCC et PostgreSQL (Guillaume Lelarge)====
==== 10:00 - 10:50 ====
==== 11:20 - 12:10 Clustering : la nouvelle donne (Stéphane Giron et Gilles Rayrat) ()====
==== 13:10 - 14:00 Indexation d'une base documentaire pour le quotidien Libération (Gaël Le Mignot, Pilot Systems) ====
==== 14:10 - 15:00 ====
=== Lightning talks ===
==== #1 Elephant, Snake and Window - 6 years experience with PostgreSQL on Windows (Harald Armin Massa)] (video) ====
==== #4 On Lightning Talks (David Fetter) (video) ====
==== #5 New features of PGCluster (Atsushi Mitani) ====
==== #6 PostgreSQL's biggest problem (By Gavin M. Roy, but presented by Greg and Dave in his absence, with no knowledge of the intended talk content)! ====
==== #7 pg51g in five – a toolkit for data diffs (Michael Nacos) (video) ====
==== #8 The Open Source Observatory and Repository (Ismael Olea) ====
==== #9 (video) ====
=== Closing session ===
==== Closing session (Dave Page and Guillaume Smet)====
Category:PostgreSQL Events
PGDay Europe 2010 BoF sessions

Birds-of-a-feather (BoF) sessions during PGDay Europe 2010.
This is an informal activity. Pls. feel free to comment and leave a note below if there is interest.
-- Yours, Sfkeller 14:34, 30 November 2010 (UTC)
== Organisation ==
Date/Time Raster (Updated by Sfkeller 16:15, 30 November 2010 (UTC)):
* Slot 1: Monday (Dec 6th): 17:30-18:30, Location: tba. 
* Slot 2: Tuesday (Dec 7th): 17:15-18:00, Location: tba.
Location:
* tba. Default is meeting point in the hotel lobby.
== Proposals ==
* Postgres replication
* Postgres for the cloud
* Postgres and full text search
* Postgres and On-line Analytical Processing (OLAP)
* Postgres and NoSQL: Concepts and implementations (Column DBs, no schema DBs with hstore, EAV 'schema' issues, distributed databases )
== Scheduled ==
=== Benchmarking PostgreSQL and other DBMS ===
* Moderator/anchorman: Sfkeller 14:34, 30 November 2010 (UTC)
* Time/Location: See Slot 2 above.
* Topics:
** Benchmark suites: Using and enhancing the 'HSR Texas Spatial Database Benchmark ' () 
** (pls. add your topic above)
* Weblinks: List of database benchmarks, (others?)
* Participants:
** Sfkeller 14:34, 30 November 2010 (UTC)
** (pls. add yourself above)
=== Tuning PostgreSQL ===
* Moderator/anchorman: tbd.
* Time/Location: tbd.
* Topics:
** Configuration helpers: pgtune tool, (others?)
** Performance issues: datatypes hstore and tsvector
** Helping others: Postgres vs. MySQL on Mediawiki; Postgres on OpenStreetMap (= EAV 'schema')
** (pls. add your topic above)
* Weblinks: Tuning Your PostgreSQL Server, (others?)
* Participants:
** Sfkeller 14:41, 30 November 2010 (UTC)
** (pls. add yourself above)
Others tba., probably given 'enough' participants have left a note here and given there is a moderator/anchorman.
Category:PostgreSQL Events
Category:PostgreSQL Europe
PGDay Europe 2010 Talks

PGDay.EU 2010 was held in Stuttgart, Germany on December 6th - 8th.
== Monday, December 6, 2010 ==
=== Berlin 1+2 ===
==== 9:45 - 10:45 Keynote: Back To The Future of Open Source (Simon Phipps)====
==== 11:10 - 12:00 Play chess against PostgreSQL (and get beaten) (Gianni Ciolli) ====
==== 12:10 - 13:00 Rapid Upgrades With Pg_Upgrade (Bruce Momjian) ====
==== 14:00 - 14:50 ====
==== 15:20 - 16:10 Managing PostgreSQL Replication (Simon Riggs) ====
==== 16:20 - 17:10 Data-driven cache invalidation (Magnus Hagander) ====
=== Berlin 3 ===
==== 11:10 - 12:00 ====
==== 12:10 - 13:00 ====
==== 14:00 - 14:50 ====
==== 15:20 - 16:10 ====
==== 16:20 - 17:10 (Andreas Scherbaum) ====
=== Glasgow ===
==== 11:10 - 12:00 ====
==== 12:10 - 13:00 ====
==== 15:20 - 16:10 ====
==== 16:20 - 17:10 PostgreSQL Clustering with RedHat Cluster Suite (Devrim Gündüz)====
=== Tara ===
==== 14:00 - 14:50 ====
==== 15:20 - 16:10 (Daniele Varrazzo) ====
== Tuesday, December 7, 2010 ==
=== Berlin 1+2 ===
==== 10:25 - 11:10 How a large organisation moved its critical application toward PostgreSQL (Philippe Beaudoin) ====
==== 11:35 - 12:20 (Jonathan S. Katz) ====
==== 14:10 - 15:00 (Heikki Linnakangas) ====
==== 15:30 - 16:30 (Ed Boyajian) ====
=== Berlin 3 ===
==== 09:00 - 09:50 (Christian Schwartze) ====
==== 10:25 - 11:10 (Stefan Kaltenbrunner) ====
==== 11:35 - 12:20 (Andreas Scherbaum) ====
==== 14:10 - 15:00 (Björn Häuser)====
=== Glasgow ===
==== 10:25 - 11:10 PL/Perl new features in 9.0 (Tim Bunce) ====
==== 13:10 - 14:00 (Vincent Picavet) ====
==== 14:10 - 15:00 PgFincore and the OS Page Cache (Is my table in memory ?) (Cedric Villemain) ====
=== Tara ===
==== 09:30 - 10:15 Embedded SQL für PostgreSQL (Michael Meskes) ====
==== 10:25 - 11:10 Why your PostgreSQL 9.0 cluster needs pgpool-II (Jean-Paul Argudo) ====
==== 14:10 - 15:00 (Dimitri Fontaine) ====
Category:PostgreSQL Events
Category:PostgreSQL Europe
PGDay FOSDEM 2013

= PGDay FOSDEM 2013 =
This is the first PgDay we hold in Belgium. FOSDEM PGDay 2013 will be held on Feb 1st in Brussels, Belgium, at the Radisson Blu Royal hotel. As an extension to the regular PostgreSQL devroom at FOSDEM, it will cover topics for PostgreSQL users, developers and contributors, and anybody else interested in PostgreSQL
== Details ==
* Date: Feb 01st, 2013 9am-5pm
* Venue:: Radisson Blu Royal Hotel
* Coordinator:: PostgreSQL Europe contact@pgconf.eu
* Website:: http://fosdem2013.pgconf.eu/
== Talks / Slides ==
Uploaded slides are here.
== Registration ==
Attendance is €50, and registration is required: http://fosdem2013.pgconf.eu/registration/ (limited seats)
== Schedule ==
Schedule will be published at: http://fosdem2013.pgconf.eu/schedule/
== Location and Venue ==
http://fosdem2013.pgconf.eu/venue/
Address: 
http://www.radissonblu.com/royalhotel-brussels/location
== Dinner ==
We are organizing a dinner after the event on Friday 1st, 2013 at Hard Rock Cafe Brussels. We have limited (30) number of seats, so please add your name to this list before going there.
If you are bringing someone to the event, make sure you enter your name *twice* (or more) on the list, so the attendee count matches!
Attendees:
# Devrim Gündüz
# Magnus Hagander
# Andreas Scherbaum
# Andreas Scherbaum +1
# Jean-Paul Argudo
# Patryk Kordylewski
# Patryk Kordylewski +1
# Dimitri Fontaine
# Julien Rouhaud
# Dave Page
# Marc Cousin
# Stéphane Schildknecht
# Jehan-Guillaume de Rorthais
# Guillaume Lelarge
# Markus Winand
# Stefan Kaltenbrunner
# Ronan Dunklau
# Gilles Darold
# Vik Fearing
# Vik Fearing +1
# Robert Ivens
# Tomas Vondra
# Greg Stark
# Heikki Linnakangas
# Michael Banck
# Christoph Berg
# Douglas Fraser
# Christophe Pettus
# Craıg Kerstıens
# Emanuel Calvo - I take the last! :P
== Dinner on Saturday ==
On Saturday we have a reservation at L'Altro Mondo (Italian restaurant), it's a 5 minutes walk from the hotel. The address is: Rue Gretry 46, 1000 Bruxelles. http://www.altromondo.be/
We have limited (30) number of seats, so please add your name to this list before going there. The reservation is for 7pm, we meet at 6:45pm in the Radisson Blu lobby.
If you are bringing someone to the event, make sure you enter your name *twice* (or more) on the list, so the attendee count matches!
Attendees:
# Andreas Scherbaum
# Andrea Scherbaum
# Pascal Scherbaum
# Peter Geoghegan
# Dimitri Fontaine
# Mario Ohnewald
# Patryk Kordylewski
# Magnus Hagander
# Jean-Paul Argudo
# Julien Rouhaud
# Dave Page
# Marc Cousin
# Stéphane Schildknecht
# Jehan-Guillaume de Rorthais
# Guillaume Lelarge
# Stefan Kaltenbrunner
# Gilles Darold
# Greg Stark
# Tomas Vondra
# Robert Ivens
# Johannes Graën
# Christoph Berg
# Vik Fearing
# Vik Fearing +1
# Emanuel Calvo
# Heikki Linnakangas
# Heikki Linnakangas+1
# Heikki Linnakangas+2
# Heikki Linnakangas+3
# Heikki Linnakangas+4
Category:PostgreSQL Events
PG Day France 2018

== Schedule ==
The schedule is available at the following website: http://pgday.fr/programme. 
== Talks: Tuesday, June 26, 2018 ==
* Retour d'expérience : 6 ans d'utilisation de PostgreSQL en production sur Autolib - Sébastien DIEMER
* Pachydermes et gros serpents - Olivier COURTIN
* Soyez efficace, utilisez psql ! - Lætitia AVROT
* La parallélisation au service de l'optimisation - Aurélien MORLE
* La base de données qui valait 2 milliards d'objets astronomiques - Grégory MANTELET
* Récupérez vos données : pgBackRest ! - Sébastien LARDIERE
* Et PAF, ça bascule! - Stefan FERCOT
* Les futures fonctionnalités de PostgreSQL 11 - Jean-Christophe ARNU
PgDayManual

We don't have detailed guidelines laid out, but there have been a few email posts from those of us who have run PgDays. 
The Italian group has most of their info linked from: http://wiki.itpug.org/PgDay
UK PUG ran a one-day conference recently: http://www.postgresql.org.uk/
PDXPUG wasn't as good about posting their notes :(
I think the basic outline is: 
# Pick a day and location 
#* Universities are good places: talk to student groups or professors who you know and can sponsor you (free space!)
#* try other government locations like Libraries and public meeting spaces (sometimes free!)
#* talk to a local company that can help you (and maybe they can sponsor too)
# Ask 1-2 other people to help you organize and set up a mailing list to keep track of what you're doing
#* These don't have to be technical people! Anyone wiling to help and you know will be reliable :)
#* Getting non-technical volunteers to help can really be good because they will see things from different perspectives, and can get the added benefit of meeting a bunch of geeks that can help them with business and technical problems :)
#* Mailing list helps you keep track of things
#* Also create a mailing list for attendees to subscribe to so that you can give them information about last minute changes
# Recruit speakers -- send out a message to pgsql-general, pgsql-advocacy and your local mailing list asking for speakers
# Set up a web page 
#* You're welcome to use http://pugs.postgresql.org and set up unique pages -- talk to me if you need help
#* You can also set up your own website!
# Ask local companies if they will sponsor your conference
#* Sponsored items can include: breakfast (coffee, pastries, tea), lunch (this is expensive though - we usually do not provide this), posters, tshirts
#* Remember that you don't really NEED sponsors though, you can just ask people to have breakfast before they arrive, and everyone can go out to lunch together. 
#* I also have potlucks sometimes - where everyone brings food and drink to share
# Choose your speakers, and announce your PgDay to mailing lists!
# Plan out your day
#* Round up supplies - projector, computer, dry erase markers, paper, business cards, nametags, markers for nametags
#* Make sure you have nametags (can just be "Hello my name is..." stickers)
#* Be sure to bring markers even if you print out nametags ahead of time 
#* If you're not providing breakfast or lunch, make lists of places that people can go and have that printed out
#* Arrange for a place at your conference site to greet people and give them nametags when they arrive
#* Make a list of speakers and have a printed version for all attendees
# Ask for 1-2 volunteers to help keep the conference running smoothly 
# Remind everyone 2 weeks, 1 week, and the day of your conference that it is happening!
# Have a great time :)
Category:Advocacy
PGDay NYC 2013 Talks

= PGDay NYC 2013 Talks =
== Friday March 22nd, 2013 ==
=== Liberty Hall C ===
* CTEs: Past, Present and Future (David Fetter)
* Understanding the Postgres Lock Manager (Bruce Momjian)
* Embracing the Web with JSON and PLV8 (Will Leinweber)
* Schema Evolutions at Gilt Groupe (Michael Bryzek)
* A Postgres-XC Distributed Key-Value Store (Mason Sharp)
* What's new in PostgreSQL 9.3 (Magnus Hagander)
=== Liberty Hall A ===
* Postgres Plus Cloud Database (Dave Page)
* Toward real-time log analysis (Peter Eisentraut)
Category:PostgreSQL Events
PgDay Paris 2015

==Schedule==
Schedule is available at the following website: https://www.postgresql.eu/events/schedule/pgdayparis2015/
== Talks: Wednesday, March 11th, 2015 ==
* Cas d'usage industriel de PostgreSQL dans le groupe ADEO, Raphaël Capliez et Sergueï Smirnov
* J'ai fait danser un troupeau d'éléphants, Stéphane Schildknecht et Patrick Francelle
* A look at the Elephants trunk - PostgreSQL 9.5, Magnus Hagander
* ToroDB: a new, open-source, document-oriented, JSON database, built on Postgres, Álvaro Hernández
* Performances et fonctionnalités dans les développements Web avec Postgres, Grégoire HUBERT
* , Petr Jelinek
* PostGIS, le spatial pour PostgreSQL, Vincent Mora
* PostgreSQL, the world's most advanced database, Simon Riggs
PgDay Paris 2016

== Schedule ==
The schedule is available at the following website: https://www.postgresql.eu/events/schedule/pgdayparis2016/
== Talks: Thursday, March 31, 2016 ==
* Historique des Bases de Données, au regard des exigences actuelles -- Sébastien Lardière
* PostgreSQL Backups the modern way -- Magnus Hagander
* Survivre à une migration de données de MySQL vers Postgres -- Grégoire HUBERT
* Quels outils de supervision pour PostgreSQL ? -- Damien Clochard
* 10 Things, an Oracle DBA should care about when moving to PostgreSQL -- Ilya Kosmodemiansky
* Tout sur les index -- Cédric Villemain
* PostGeol: une (future) extension PostgreSQL pour les géologues, dans le cadre de GeolLLibre -- Pierre Chevalier
PgDay Paris 2017

== Schedule ==
The schedule is available at the following website: http://2017.pgday.paris/schedule/
== Talks: Thursday, March 23, 2017 ==
* A PostgreSQL DBAs Toolbelt for 2017, Kaarel Moppel
* Corruption War Stories, Christophe Pettus
* Can't imagine what a newbie can do with PostgreSQL on Linux in a month, Sylvie Aune
* Measuring and Reducing PostgreSQL Transaction Latency (slides, handout), Fabien Coelho
* A look at the Elephants trunk - PostgreSQL 10, Magnus Hagander
* Infrastructure Monitoring with Postgres, Steven Simpson
* MLS PostgreSQL - Implementing Multi-level Security in PostgreSQL with RLS and SELinux, Joe Conway
* Replication & Recovery in PostgreSQL 10.0, Simon Riggs
PgDaySanJose2009Video

= Videos for pgDay San Jose 2009 =
pgDay San Jose was on July 19, 2009. Here are video recordings of the talks. Video recording and editing were generously donated by Chanticleer Films.
* pgday-sjc-09-easier.mov (251.1MB)
* pgday-sjc-09-migrator.mov (156.2MB)
* pgday-sjc-09-monitoring.mov (288.8MB)
* pgday-sjc-09-gearman.mov (257.2MB)
* pgday-sjc-09-lightning.mov (195.1MB)
* pgday-sjc-09-petabytes.mov (213.7MB)
* pgday-sjc-09-pitfalls.mov (195.6MB)
* pgday-sjc-09-postgis.mov (241.7MB)
Category:PostgreSQL Events
PgDay Santiago 2019

pgDay Santiago 2019 took place in Santiago, Chile, in 2019-10-29.
== Talks ==
Time 	Speaker 	Title (Link to slides)
09:30 - 10:05	Alberto Abudinen 	
10:10 - 10:45	Álvaro Herrera 	
11:10 - 11:45	José Venegas 	
11:50 - 12:25	Jaime Casanova 	
12:30 - 13:05	Jared López 	
14:05 - 14:40	Rodrigo Fuentealba	PostgreSQL y Data Science
14:45 - 15:20	Francis Santiago 	StackGres: Cloud-Native PostgreSQL en Kubernetes
15:25 - 16:00	Boriss Mejías 	Entendiendo MVCC y VACUUM
16:05 - 16:40	Anthony Sotolongo 	
Category:PostgreSQL Events
PGDay SCALE12x

= PGDay SCALE12x (2014) Talks =
* Federated PostgreSQL (Jim Mlodgenski)
* JSON in PostgreSQL (Christoph Pettus)
* PostgreSQL (System) Administration (Stephen Frost)
* Autovacuum and You (Gabrielle Roth)
* PostgreSQL 9.3 Replication in 10 Minutes (Josh Berkus)
* Optimizing EMC Storage for Postgres:: Is FAST slowing you down? (Oscar Herrera)
Category:PostgreSQL Events
Pgdba2000-01

=PostgresQL DBA免费培训 第一期 杭州站=
为了帮助用户更快掌握PostgreSQL的使用和管理，PostgreSQL中国用户会发起免费的DBA培训项目，每个季度选一个周末在北京、广州、杭州举行免费的DBA培训。
培训材料下载
*主办：PostgreSQL中国用户会(www.cnpug.org)
*网址: http://wiki.postgresql.org/wiki/Pgdba2000-01
*时间：杭州5月5日-5月6日
*报名截止: 杭州(5月3日)
*费用：杭州：免费
*地点：杭州(杭州市紫荆花路2号联合大厦B座11楼 苏堤培训室)
*报名方法：
 发送邮箱Email： cnpug2012@gmail.com 
 邮件标题Title： PG2000 第一期 + 杭州 + 姓名
 邮件内容Subject：
 姓名 Name：
 单位 Company：
 职务 Title：
 座机 Phone： 注：请填写单位电话
 手机 Mobile： 注：便以短信联系
*讲师：德哥(周正中)
*课程大纲：
 Day1 9:00-17:00
 PostgresQL 核心架构基础(Process/Storage/Momery等) 
 PostgresQL 安装及文件结构 
 PostgresQL 配置基础 
 PostgresQL 数据库逻辑结构(Database/Schema/Tablespace等) 
 PostgresQL 数据备份及恢复 
 PostgresQL 数据库权限及安全管理 
 Day2 9:00 – 17:00
 PostgresQL 基于时间点的数据恢复(Point-in Time Recovery) 
 PostgresQL 运行时维护管理(MVCC/Vacuum/Reindex等) 
 PostgresQL 存储过程及调试(pg/plsql，pgAdminIII Debuger)
 PostgresQL 监控排错基础
 PostgreSQL优化培训
 以下内容只进行简要概念介绍(Day2)：
 数据库集群概论
 PostgresQL Hot-Standby and Stream Replication简介
 PostgresQL 高可用性集群架构简介
 PostgresQL PGPool 读写分离架构简介
 PostgresQL 集中管理及性能优化基础
* 联系人
 德哥(周正中) digoal [at] 126.com 
 Galy 李元佳(galylee [at] gmail.com) 13710389225 新浪微博@李元佳Postgres
 QQ群： 3336901
 
* 鸣谢
 斯凯网络
Category:PostgreSQL Events
Category:Chinese
Pgdoc

DBA文档集
=联系信息=
如需要修改本页，请注册帐号，注册地址
Postgres交流QQ群：191516183
=参考书籍=
*【Joshua Drake】Practical PostgreSQL(online)
*【Gregory Smith】PostgreSQL 9.0 High Performance
*【Simon Riggs】PostgreSQL 9 Admin Cookbook
*【Neil Matthew】Beginning Databases with PostgreSQL: From Novice to Professional
=综合=
*Mastering PostgreSQL Administration
=安装=
*Detailed installation guides
*PostgreSQL 安装和简单使用
=备份=
=监控=
*pg_statsinfo：More useful statistics information for DBAs
=调优=
*PostgreSQL Performance Pitfalls
=升级=
*Rapid Upgrades With Pg_Upgrade
=集群=
*The Magic of Hot Streaming Replication
=系统迁移=
*Best practices with Ora2Pg
=案例=
* Using PostgreSQL for Flight Planning
* Running PostgreSQL in enterprise level telco systems
=其他=
==PostGIS==
* Part 1: Getting Started With PostGIS: An almost Idiot's Guide
==Partitioning==
*PostgreSQL Partitioning
Category:Chinese
Pg dump improvements

== Background ==
Currently only pg_dumpall emits database and roles attributes, such as CREATE ROLE, ALTER ROLE, ALTER DATABASE SET and ALTER ROLE SET commands.
We would like to have a pg_dump solution that can generate in one step all the necessary pieces of information needed when restoring or cloning a database (schema, data, privileges, users and alter database/role data). A discussion has been started again via pgsql-hackers@postgresql.org and this page attempts to summarize what has been discussed there.
== Proposal ==
Some of the suggestions to handle this are:
* a) Implement and use CREATE ROLE IF NOT EXISTS and just throw a warning or handle the "role already exists" error message gracefully.
* b) Use a new option i.e. --reuse-roles-in-conflict to behave like suggestion a). If this option is not used, pg_restore will stop with a fatal error when a role already exist.
* c) Use a new option i.e. --on-roles-error-stop to stop with a fatal error when a role already exist. If this option is not used pg_restore will behave like suggestion a).
* d) Use a new option i.e. --rename-roles-in-conflict to rename the roles that already exists. If this option is not used, pg_restore will stop with a fatal error when a role already exist.
== Some links ==
* http://www.postgresql.org/message-id/5280E2AE.8070106@usit.uio.no
* http://www.postgresql.org/message-id/4864F001.50909@archonet.com
* http://www.postgresql.org/message-id/11646.1272814212@sss.pgh.pa.us
Pg envent cn

== 中国PostgreSQL用户会活动 ==
 
活动名 	网页 	日期 	城市 	地点 	联系人
11月成都活动 	cn chengdu 11 	11月26日 	成都 	武侯区十二北街江水居茶楼 	虚构 284466130@qq.com
11月上海活动 	cn shanghai 11	11月27日 	上海 	南京东路步行街558号7楼咖啡厅（世纪广场） 	我行我素 27420716@qq.com
 
活动名 	网页 	日期 	城市 	地点 	联系人
北京用户会活动 	北京用户会活动 	2011年11月5日 	北京 	瑞格咖啡 海淀区知春路盈都大厦c座107 	永收 louis@easyea.com
杭州用户会10月活动 	杭州活动连接 	2011年10月29日 	杭州 	紫荆花路2号联合大厦B座11楼 	德哥
广州用户会10月活动 	ppt 相片 	2011年10月30日 	广州 	贝塔咖啡厅 	泥鳅
2011全国用户大会 	全国用户大会连接 	2011年7月15日 	广州 	暨南大学 	Galy
Category:PostgreSQL Events
Category:Advocacy
Pg envent cn oct beijing

=2011年11月5日Postgresql北京用户交流会=
#时 间:2011年11月5日 周六 1:30-5:30
#地 点: 瑞格咖啡‎ 北京市海淀区知春路盈都大厦c座107
#费 用: AA 
#报名方式: louis@easyea.com (邮件内容注明 姓名、公司、联系方式、人数)
#联 系 人: 逯永收 QQ：28401579
#备 注： 活动不提供发票
#主 题: 北京及附近地区PostgreSQL用户互相认识交流的聚会, 彼此交流各自PG的使用情况, 促进PostgreSQL技术社区在中国地区的发展
#活动流程:
时间 	编号 	主题 	演讲人 	演讲资料下载
1:30 -2:00	1 	签到 	无 	无
2:00 - 	2 	PostgreSQL的backup机制 	萧少聪 	
 	3 	如何在Spring+Struts+Hibernate环境中进行PG开发的Quick Start 	秦红胜 	
 	4 	PostgreSQL那些人和事儿- Michael Stonebraker 	孙鹏 	
 	5 	内核分析的环境搭建及Postmaster解析 	孙鹏 	
 	6 	聚餐活动 	全体 	
Category:Chinese