Re: When to release Cloudberry 2.0

Howdy, I would agree that completing the Cherry Pick work makes sense. JD - Founder - https://commandprompt.com/ - 24x7x365 Postgres since 1997 - Founder and Co-Chair - https://postgresconf.org/  - Founder - https://postgresql.us - United States PostgreSQL - Public speaker, published

Re: Don't Miss: CFPs for Upcoming Conferences [01/2025]

Postgres Conference (https://postgresconf.org) CFP is still open as well. Founder - https://commandprompt.com/ - 24x7x365 Postgres since 1997Founder and Co-Chair - https://postgresconf.org/ Founder - https://postgresql.us - United States PostgreSQLPublic speaker, published author, postgresql exp

Re: Suggestions for Conferences to Promote Apache Cloudberry

JD and Andrey! > > Best, > Dianjin Wang > > > On Mon, Jan 20, 2025 at 2:09 PM Andrey Borodin x4...@yandex-team.ru wrote: > > > Hi! > > > > > On 20 Jan 2025, at 08:18, Joshua D. Drake em...@joshuadrake.me wrote: > > > > > > Postgresconf.or

Re: Suggestions for Conferences to Promote Apache Cloudberry

Postgresconf.org Founder - https://commandprompt.com/ - 24x7x365 Postgres since 1997Founder and Co-Chair - https://postgresconf.org/ Founder - https://postgresql.us - United States PostgreSQLPublic speaker, published author, postgresql expert, and people believer.Host - More than a refresh: A p

Re: readability changes to postgres.sgml

On 8/19/19 10:36 PM, Erik Rijkers wrote: On 2019-08-20 07:05, Michael Paquier wrote: On Mon, Aug 19, 2019 at 04:00:13PM -0700, Joshua D. Drake wrote: New version attached with spelling errors fixed. I have gone through this patch, and I have a hard time understanding why these are

Re: readability changes to postgres.sgml

Team, New version attached with spelling errors fixed. -- Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc Postgres centered full stack support, consulting and development. Advocate: @amplifypostgres || Get help: https://commandprompt.com/ * Unless otherwise stated,

Re: readability changes to postgres.sgml

On 8/15/19 5:26 PM, Stephen Frost wrote: Specifically- Welcome to the PostgreSQL Tutorial. The -following few chapters are intended to give a simple introduction +tutorial is intended to give an introduction to PostgreSQL, relational database I disagree with removing 'sim

Re: readability changes to postgres.sgml

On 8/16/19 10:41 AM, Liudmila Mantrova wrote: For what it's worth, I think the proposed changes are all solid improvements. The text reads better with them, and that's what this is about -- not whether the removed little text-pieces were 'true' or not. If we want to make th

Re: readability changes to postgres.sgml

On 8/15/19 10:22 PM, Erik Rijkers wrote: On 2019-08-16 02:26, Stephen Frost wrote: Greetings, * Joshua D. Drake (j...@commandprompt.com) wrote: attached they seem to be simply removing words and removing content that is For what it's worth, I think the proposed changes are all

readability changes to postgres.sgml

attached Thanks, JD -- Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc Postgres centered full stack support, consulting and development. Advocate: @amplifypostgres || Get help: https://commandprompt.com/ * Unless otherwise stated, opinions are my own. * dif

Update and modernization to intro.sgml

Hey, I sent this to -hackers where it went one round but it probably makes more sense here. JD -- Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc Postgres centered full stack support, consulting and development. Advocate: @amplifypostgres || Get help: https://commandpro

Re: Cleanup of intro.sgml

Rev 2 attached. Added: SQL/JSON SQL/XML Fixed spelling mistakes Fixed a missing closing tag. -- Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc Postgres centered full stack support, consulting and development. Advocate: @amplifypostgres || Get help: https://commandp

Re: Cleanup of intro.sgml

On 8/5/19 1:13 PM, Chapman Flack wrote: On 8/5/19 3:20 PM, Joshua D. Drake wrote: intro.sgml today. Patch attached. Things I noticed quickly: broken up in to categoriess/in to/into/ Got it, I can make that change. Unstructured data via JSON(or XML ?) On this one, there is a lot

Cleanup of intro.sgml

-hackers, I went through and made some readability and modernization of the intro.sgml today. Patch attached. JD -- Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc Postgres centered full stack support, consulting and development. Advocate: @amplifypostgres || Get help: h

Re: Resolution 2018-07-11.mm.1: Arch Linux 32 as associated project

That's cool! +1 On 1/26/19 9:30 AM, Martin Michlmayr wrote: I'd like to propose this resolution for the February meeting. I initially posted this to the list last year and some people asked whether Arch Linux agrees and whether there's an agreement in place. We have a light-weight trademark agr

Re: Thread-unsafe coding in ecpg

On 1/21/19 12:05 PM, Tom Lane wrote: Andres Freund writes: Seems jacana might not have like this change? https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=jacana&dt=2019-01-21%2019%3A01%3A28 Hmm. So mingw doesn't provide access to _configthreadlocale(). That's unfortunate, at least if w

Re: House style for DocBook documentation?

On 1/21/19 10:11 AM, Chapman Flack wrote: On 01/21/19 12:07, Joshua D. Drake wrote: Who is really going to "print" our docs? If they do print the docs, they are likely not going to "type in" a long URL. QR code in footnote (ducks and runs). Funny, although I know why yo

Re: House style for DocBook documentation?

On 1/21/19 10:01 AM, Alvaro Herrera wrote: On 2019-Jan-21, Chapman Flack wrote: But the point's well taken that in /printed output/, that's of no use. Which is, in a sense, an inconsistency: in one format, you can follow the links, while in another, you're out of luck. Maybe a simpler transfor

Re: House style for DocBook documentation?

On 1/21/19 8:46 AM, Chapman Flack wrote: On 01/21/19 09:12, Alvaro Herrera wrote: (thinks to self half-seriously about an XSL transform for generating printed output that could preserve link-texted links, add raised numbers, and produce a numbered URLs section at the back) Well, if you have th

Re: Alter table column constraint

On 12/17/18 12:01 PM, Rich Shepard wrote: On Mon, 17 Dec 2018, Rich Shepard wrote: I want to alter a term in a column's constraint to allow only specified strings as attributes and have not found how to do this in the docs (using version 10 docs now). There is an alter table command that allow

Re: Statement-level rollback

On 12/7/18 12:50 PM, Alvaro Herrera wrote: On 2018-Dec-07, Robert Haas wrote: More generally, whether or not we should "keep something away from our users" really depends on how likely the upsides are to occur relative to the downsides. We don't try to keep users from running DELETE because th

Re: make install getting slower

On 12/4/18 12:31 PM, Andres Freund wrote: Hi, best of three of time make -s install INSTALL=/bin/true 9.3: 1.53s 9.4: 1.55s 9.5: 1.90s 9.6: 2.10s 10: 2.45s 11: 2.81s master: 2.99s Obviously a part of that can be explained by the tree getting bigger, but that can't be all of it. It also gets a

Re: simple division

On 12/4/18 12:29 PM, Martin Mueller wrote: I have asked this question before and apologize for not remembering it. How do you do simple division in postgres and get 10/4 with decimals? This involves cast and numeric in odd ways that are not well explained in the documentation. For instance,

Can you present on Postgres + Kafka?

Howdy, I am one of the organizers of Silicon Valley Postgres (and others) as well as PostgresConf, we are looking for speakers to present on integrating Kafka with Postgres. Do we have any community members in Silicon Valley and/or NYCish that would be interested in presenting on this topic?

Re: Is pg_restore in 10.6 working?

On 11/12/18 10:37 AM, David wrote: I can connect with psql either of these two ways: psql -U postgres or psql -h ip-172-31-62-127.ec2.internal -p 5432 -U postgres -W postgres (Yes, it's an AWS server) This pg_dump command works: pg_dump -U postgres -f predata.sql -F p -v  -d prod_data But a ma

Re: Connection limit doesn't work for superuser

On 11/7/18 10:49 AM, Robert Haas wrote: On Wed, Nov 7, 2018 at 1:14 PM Tom Lane wrote: I think that having superusers be immune to datconnlimit is actually the right thing; for one reason, because datconnlimit can be set by database owners, who should not be able to lock superusers out of their

Re: SCRAM question

On 10/30/18 10:51 AM, MichaelDBA wrote: I am using pgadmin4 version 3.4 with PG 11.0 and I get this error when I try to connect with scram authorization: User "myuser" does not have a valid SCRAM verifier. How do I get around this? And also how would I do this for psql? You need to update th

Re: replication_slots usability issue

On 10/30/18 10:52 AM, Andres Freund wrote: On 2018-10-30 11:51:09 +0900, Michael Paquier wrote: On Mon, Oct 29, 2018 at 12:13:04PM -0700, Andres Freund wrote: I don't think this quite is the problem. ISTM the issue is rather that StartupReplicationSlots() *needs* to check whether wal_level > mi

Re: replication_slots usability issue

On 10/29/18 11:26 AM, Andres Freund wrote: On October 29, 2018 1:31:56 PM EDT, "Joshua D. Drake" wrote: -Hackers, Working on 9.6 today (unsure if fixed in newer versions). Had an issue where the wal was 280G despite max_wal_size being 8G. Found out there were stale replication sl

replication_slots usability issue

-Hackers, Working on 9.6 today (unsure if fixed in newer versions). Had an issue where the wal was 280G despite max_wal_size being 8G. Found out there were stale replication slots from a recent base backup. I went to drop the replication slots and found that since the wal_level was set to mi

Re: Code of Conduct plan

On 09/17/2018 08:11 AM, Dmitri Maziuk wrote: On Sun, 16 Sep 2018 12:52:34 + Martin Mueller wrote: ... The overreach is dubious on both practical and theoretical grounds. "Stick to your knitting " or the KISS principle seem good advice in this context. Moderated mailing lists ain't been b

Re: Code of Conduct plan

On 09/17/2018 08:11 AM, Dmitri Maziuk wrote: On Sun, 16 Sep 2018 12:52:34 + Martin Mueller wrote: ... The overreach is dubious on both practical and theoretical grounds. "Stick to your knitting " or the KISS principle seem good advice in this context. Moderated mailing lists ain't been b

Re: Code of Conduct plan

On 09/14/2018 07:41 AM, James Keener wrote: > Community is people who joined it We're not a "community." I do not think you are going to get very many people on board with that argument. As anyone who knows me will attest I am one of the most contrarian members of this community but I still

Re: Code of Conduct plan

On 09/14/2018 07:41 AM, James Keener wrote: > Community is people who joined it We're not a "community." I do not think you are going to get very many people on board with that argument. As anyone who knows me will attest I am one of the most contrarian members of this community but I still

Re: Code of Conduct plan

On 09/14/2018 06:59 AM, Robert Eckhardt wrote: I really have to object to this addition: "This Code is meant to cover all interaction between community members, whether or not it takes place within postgresql.org infrastructure, so long as there is not another Code of Co

Re: Code of Conduct plan

On 09/14/2018 07:36 AM, Dave Page wrote: On Fri, Sep 14, 2018 at 3:21 PM, James Keener > wrote: Now, you may say that (2) would be rejected by the committee, but I would counter that it's still a stain on me and something that

Re: Code of Conduct plan

On 09/14/2018 07:51 AM, Dave Page wrote: If that business is publicly bringing the project into disrepute, or harassing other community members and they approach us about it, then it becomes our business. If it's unrelated to PostgreSQL, then it's your personal business and not som

Re: Code of Conduct plan

On 09/14/2018 07:51 AM, Dave Page wrote: If that business is publicly bringing the project into disrepute, or harassing other community members and they approach us about it, then it becomes our business. If it's unrelated to PostgreSQL, then it's your personal business and not som

Re: Code of Conduct plan

On 09/14/2018 07:36 AM, Dave Page wrote: On Fri, Sep 14, 2018 at 3:21 PM, James Keener > wrote: Now, you may say that (2) would be rejected by the committee, but I would counter that it's still a stain on me and something that

Re: Code of Conduct plan

On 09/14/2018 07:14 AM, Dave Page wrote: On Fri, Sep 14, 2018 at 3:08 PM, Joshua D. Drake <mailto:j...@commandprompt.com>> wrote: On 09/14/2018 01:31 AM, Chris Travers wrote: I apologize for the glacial slowness with which this has all been moving. The

Re: Code of Conduct plan

On 09/14/2018 07:14 AM, Dave Page wrote: On Fri, Sep 14, 2018 at 3:08 PM, Joshua D. Drake <mailto:j...@commandprompt.com>> wrote: On 09/14/2018 01:31 AM, Chris Travers wrote: I apologize for the glacial slowness with which this has all been moving. The

Re: Code of Conduct plan

On 09/14/2018 06:59 AM, Robert Eckhardt wrote: I really have to object to this addition: "This Code is meant to cover all interaction between community members, whether or not it takes place within postgresql.org infrastructure, so long as there is not another Code of Co

Re: Code of Conduct plan

On 09/14/2018 01:31 AM, Chris Travers wrote: I apologize for the glacial slowness with which this has all been moving. The core team has now agreed to some revisions to the draft CoC based on the comments in this thread; see https://wiki.postgresql.org/wiki/Code_of_Condu

Re: Code of Conduct plan

On 09/14/2018 01:31 AM, Chris Travers wrote: I apologize for the glacial slowness with which this has all been moving. The core team has now agreed to some revisions to the draft CoC based on the comments in this thread; see https://wiki.postgresql.org/wiki/Code_of_Condu

Re: Slow shutdowns sometimes on RDS Postgres

On 09/13/2018 03:04 PM, Chris Williams wrote: Hi, I'm using AWS RDS Postgres (9.6.6) and have run into very slow shutdowns (10+ minutes) a few times when making database modifications (e.g. reboot, changing instance size, etc.).  Other times, it shuts down quickly (1 minute or so).  I have no

Re: Multi-second pauses blocking even trivial activity

On 09/07/2018 11:12 AM, Andreas Kretschmer wrote: Intermittently (one or two times a week), all queries on that host are simultaneously blocked for extended periods (10s of seconds). The blocked queries are trivial & not related to locking - I'm seeing slowlogs of the form: please check if TH

Re: Barman versus pgBackRest

On 09/04/2018 08:55 AM, Ron wrote: On 09/04/2018 10:51 AM, David Steele wrote: [snip] This will work, but I don't think it's what Ron is getting at. To be clear, it is not possible to restore a database into an *existing* cluster using pgBackRest selective restore.  This is a limitation of Post

Re: increasing HA

On 09/04/2018 07:58 AM, Thomas Poty wrote: - using an automatick failover  I found PAF  Could you advice any others solutions to explore or share your experience? LinuxHA or Patroni are the most common we run into. JD-- Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc *

Re: Barman versus pgBackRest

On 09/04/2018 07:52 AM, Ron wrote: On 09/04/2018 09:24 AM, Joshua D. Drake wrote: On 09/04/2018 07:14 AM, Ron wrote: That was about barman, in the barman group.  This is asking about pgbackrest...  :) So: does pgbackrest have this ability which barman does not have? The "--db-in

Re: Barman versus pgBackRest

On 09/04/2018 07:14 AM, Ron wrote: That was about barman, in the barman group.  This is asking about pgbackrest...  :) So: does pgbackrest have this ability which barman does not have? The "--db-include" option seems to indicate that you can restore a single db, but does indicate whether or

Re: Upgrade/Downgrade

On 08/23/2018 04:47 AM, Achilleas Mantzios wrote: On 23/08/2018 14:30, Sonam Sharma wrote: No, I didn't. The version is not compatible with application, so need to downgrade it Have you tried to tweak postgresql.conf ? What do you mean is not compatible? What's the problem? My guess would be

Re: Can Pg somehow recognize/honor linux groups to control user access ?

On 08/22/2018 08:56 AM, David Gauthier wrote: Hi: The title says it all.  I need to be control who can gain access to a DB based on a linux user group.  I can set up a generic role and password, but also want to prevent users who are not in a specific linux group from accessing the DB.  For c

Re: Windows vs C99 (was Re: C99 compliance for src/port/snprintf.c)

On 08/21/2018 11:06 AM, Andrew Dunstan wrote: XP at least is essentially a dead platform for us. My animals are not able to build anything after release 10. I wouldn't think XP should even be on our list anymore. Microsoft hasn't supported it in 4 years. JD -- Command Prompt, Inc. || ht

Re: vPgSql

On 08/17/2018 05:45 AM, Dmitry Igrishin wrote: Hey Vlad пт, 17 авг. 2018 г. в 15:31, Vlad Alexeenkov : Maybe will be useful for someone Very simple Postgres SQL client vPgSql: https://vsdev.ru Looking nice! Thank you. But I unable to start it on Ubuntu, because there is no bash(1) in /usr/bin

Re: Difference between "autovacuum_naptime" and "autovacuum_vacuum_cost_delay"?

On 08/16/2018 06:10 PM, Raghavendra Rao J S V wrote: Hi All, I have gone through several documents but I am still have confusion related to "autovacuum_naptime" and "autovacuum_vacuum_cost_delay". Could you clarify me with an example. When Auto vacuum worker process will start? Autovacuum

Re: moving data to from ms sql server via SSIS

On 08/15/2018 11:03 AM, cosmin ioan wrote: hi folks, we're trying to phase out MS SQL Server and we're trying to understand the easiest way to move data from MS SQL Server to postgres, via SSIS, say via ODBC, OleDB or .Net drivers, and basically create new tables & move data, into the target p

Re: using graph model with PostgreSQL

On 08/15/2018 07:09 AM, 김세훈 wrote: Hi there, currently I'm using PostgreSQL with PostGIS extension to handle geospatial data. In my project I need to apply some graph algorithms like MST for some network of GPS coordinates. I know there is some way of using Neo4j with PostgreSQL but is the

Re: pg_basebackup failed to read a file

On 08/14/2018 09:14 AM, Tom Lane wrote: Mike Cardwell writes: It'd be nice to have a more coherent theory about what needs to be copied or not, and not fail on files that could simply be ignored. Up to now we've resisted having any centrally defined knowledge of what can be inside a PG data di

Re: Online enabling of checksums

On 08/01/2018 09:20 AM, Alvaro Herrera wrote: my problem is that I think the "restart" approach is just using the entirely wrong hammer to solve the problem at hand. At the very least it's very problematic in respect to replicas, which need to know about the setting too, and can have similar p

Re: Online enabling of checksums

On 07/31/2018 12:45 PM, Bruce Momjian wrote: Hi!, Thanks for reviewing, I’ve updated the patch with the above mentioned incorrect linkends as well as fixed the comments you made in a previous review. The CF-builder-bot is red, but it’s because it’s trying to apply the already committed patch

Re: Call for Papers - PGConf.ASIA 2018

On 07/29/2018 05:59 PM, Tatsuo Ishii wrote: Hi PostgreSQL lovers, The call for papers for PGConf.ASIA 2018 will be closed on 31st July, 2018 (Japan time), that is 15:00 31st July 2018 UTC. I am looking forward to receiving your great proposals and seeing you in Akihabara (yes, like last year, t

Re: Deprecating, and scheduling removal of, pg_dump's tar format.

On 07/27/2018 10:05 AM, Andres Freund wrote: Yeah. I don't mind removing really marginal features to ease maintenance, but I'm not sure that this one is all that marginal or that we'd save that much maintenance by eliminating it. My point is more that it forces users to make choices whenever

Re: Deprecating, and scheduling removal of, pg_dump's tar format.

On 07/26/2018 07:41 PM, Christophe Pettus wrote: On Jul 26, 2018, at 19:35, Peter Geoghegan wrote: Why, specifically, would it make them unhappy? Forensic and archive backups in .tar format (which I know of users doing) would require a two-step restore process on newer versions. I am a +1 f

Re: How can i install contrib modules in pg11 via source

On 07/24/2018 12:08 PM, Adrian Klaver wrote: On 07/24/2018 12:00 PM, Márcio Antônio Sepp wrote: Hi all, How can i install contrib modules in pg11. I’m using FreeBSD 11.2. In specific i need to install hstore for test purpose. To confirm you are building from source correct? If so I can tell

Re: How can we submit code patches that implement our (pending) patents?

On 07/23/2018 12:06 PM, Bruce Momjian wrote: So, is it FUD? The core needs paid-for legal advice, not speculation. I'm quite certain that a software license can make a patent grant to the satisfaction of many open source communities, and almost certainly to the satisfaction of the PG community.

Re: User documentation vs Official Docs

On 07/20/2018 05:31 PM, Adrian Klaver wrote: On 07/20/2018 04:48 PM, Joshua D. Drake wrote: On 07/20/2018 03:59 PM, Alvaro Herrera wrote: I don't see why we need this thread to continue.  This sounds like somebody looking for a solution when they don't yet know what the

Re: User documentation vs Official Docs

On 07/20/2018 04:56 PM, Stephen Frost wrote: +1. I'd personally like to see improvements to the tutorials, and patches could certainly be submitted or specific ideas discussed over on -docs. A few ideas around that would be: - Setting up async replication - Setting up sync replication, with q

Re: User documentation vs Official Docs

On 07/20/2018 03:59 PM, Alvaro Herrera wrote: I don't see why we need this thread to continue. This sounds like somebody looking for a solution when they don't yet know what the problem is. Unfortunately, you don't understand the problem which is why this thread is happening on -general and

Re: User documentation vs Official Docs

On 07/20/2018 10:38 AM, George Neuner wrote: As libraries allow users/citizens to request books be purchased at no cost to the user/citizen, the argument that someone cannot afford a book is now a moot point. This thread is getting off topic. The tl;dr; of this particular subthread is that w

Re: Have an encrypted pgpass file

On 07/18/2018 04:25 PM, Tom Lane wrote: Alvaro Herrera writes: Seems to me that passing %-specifiers to the command would make it more useful (%u for "user", "host" etc) -- your command could refuse to give you a password for the superuser account for instance but grant one for a read-only user

Re: User documentation vs Official Docs

On 07/16/2018 05:08 PM, Alvaro Herrera wrote: Sounds like wiki pages could solve need this pretty conveniently. If and when the content is mature enough and migrates to the tutorial main documentation pages, the wiki pages can be replaced with redirects to those. Anyone who writes a lot is go

Re: User documentation vs Official Docs

On 07/16/2018 04:56 PM, Joshua D. Drake wrote: 3) Some combination of the editorial board/peer reviewers/other volunteers would periodically go over existing documentation to remove/update stale content. I did it! s/did/dig -- Command Prompt, Inc. || http://the.postgres.company

Re: User documentation vs Official Docs

On 07/16/2018 04:33 PM, Adrian Klaver wrote: First, my assumption is that this project would be done within the .Org infrastructure and if the community thinks that we should just use DocBook that is certainly an option (although adhering to something like Docbook Simple may be best). All t

Re: User documentation vs Official Docs

On 07/16/2018 03:37 PM, David G. Johnston wrote: On Mon, Jul 16, 2018 at 3:19 PM, Joshua D. Drake <mailto:j...@commandprompt.com>>wrote: On 07/16/2018 03:14 PM, David G. Johnston wrote: What does the community think about a community run, community organized, su

Re: User documentation vs Official Docs

On 07/16/2018 03:14 PM, David G. Johnston wrote: What does the community think about a community run, community organized, sub project for USER documentation? This type of documentation would be things like, "10 steps to configure replication", "Dumb simple Postgres backups",  "5

Re: User documentation vs Official Docs

On 07/16/2018 03:07 PM, Tim Cross wrote: I think encouraging user developed docs is a great idea. However, I'm not sure how your proposal really addresses the issue. How would your proposal deal with the "but let's be honest, writing a blog/article/howto in a wiki is a pain in the butt" issue?

Re: User documentation vs Official Docs

On 07/16/2018 02:54 PM, Vick Khera wrote: On Mon, Jul 16, 2018 at 5:44 PM, Joshua D. Drake <mailto:j...@commandprompt.com>> wrote: On 07/16/2018 02:22 PM, Joshua D. Drake wrote: On 07/16/2018 01:59 PM, Stephen Frost wrote: We have a place for this to g

Re: User documentation vs Official Docs

On 07/16/2018 02:22 PM, Joshua D. Drake wrote: On 07/16/2018 01:59 PM, Stephen Frost wrote: We have a place for this to go, in the official docs, already split out by version, and it starts here: https://www.postgresql.org/docs/10/static/tutorial-start.html Adding more to that certainly

Re: User documentation vs Official Docs

On 07/16/2018 01:59 PM, Stephen Frost wrote: We have a place for this to go, in the official docs, already split out by version, and it starts here: https://www.postgresql.org/docs/10/static/tutorial-start.html Adding more to that certainly sounds good to me. I didn't know that existed. I wi

Re: User documentation vs Official Docs

On 07/16/2018 01:39 PM, Adrian Klaver wrote: Not sure this is much different from the Wiki unless: The wiki is certainly "a place" that can be used for this but the wiki takes a lot of effort to find things on it, manage it etc... Who is going to?: 1) Run/maintain it. Well this is a co

User documentation vs Official Docs

-general. Over the last year as I have visited many meetups and interacted with people at conferences etc... There are three prevailing issues that continue to come up in contributing to the community. This email is about one of them. Where is the "user" documentation? The official documentat

Re: Call for Votes - 2018 SPI board elections

On 07/13/2018 11:19 AM, Martin Michlmayr wrote: * Hilmar Lapp [2018-07-13 13:47]: The ballot explains how the votes will be counted (ScottishSTV) but not what does and what does not constitute a valid ballot submission. Presumably it is some combination of the letters standing for the candidate

Re: Resolution 2018-07-11.mm.1: Arch Linux 32 as associated project

On 07/12/2018 11:14 AM, Martin Michlmayr wrote: * Julien Cristau [2018-07-12 19:14]: I'd like to propose the following resolution for the August meeting: Resolution 2018-07-11.mm.1: Arch Linux 32 as associated project WHEREAS 1. Arch Linux 32 is a substantial and significant Free Software pr

Re: patch to allow disable of WAL recycling

On 07/10/2018 01:15 PM, Jerry Jelinek wrote: Thanks to everyone who took the time to look at the patch and send me feedback.  I'm happy to work on improving the documentation of this new tunable to clarify when it should be used and the implications. I'm trying to understand more specifically w

Re: shared-memory based stats collector

On 07/06/2018 12:34 PM, Robert Haas wrote: On Fri, Jul 6, 2018 at 3:02 PM, Joshua D. Drake wrote: Will stats, if we move toward the suggested changes be "less" accurate than they are now? We already know that stats are generally not accurate but they are close enough. If we move t

Re: shared-memory based stats collector

On 07/06/2018 11:57 AM, Andres Freund wrote: On 2018-07-06 14:49:53 -0400, Robert Haas wrote: I think we also have to ask ourselves in general whether snapshots of this data are worth what they cost. I don't think anyone would doubt that a consistent snapshot of the data is better than an incon

Re: "interesting" issue with restore from a pg_dump with a database-wide search_path

On 07/06/2018 11:27 AM, Larry Rosenman wrote: when I pg_dump -Fc the database and then try to restore it after a create database, I get errors. To get a clean restare I need to do: Knowing the errors would be helpful. jD --- \set DB `echo ${DB}` CREATE SCHEMA IF NOT EXISTS postgis; CREATE

Re: I'd like to discuss scaleout at PGCon

On 06/22/2018 11:28 AM, Merlin Moncure wrote: Key features from my perspective: *) fdw in parallel. how do i do it today? ghetto implemented parallel queries with asynchronous dblink *) column store Although not in core, we do have this as an extension through Citus don't we? JD -- Comma

Re: What does Natvie Posgres mean?

On 06/12/2018 10:53 AM, bto...@computer.org wrote: When someone, e.g., as appeared in a recent and some older pgsql-jobs messages, says "Native Postgres", what do you suppose that means? Does it mean something different than just "PostgreSQL"? Is the word "Native" just noise, or does it actua

Re: Service pgpool

On 06/07/2018 11:16 AM, Jean Claude wrote: Hi all, below my problem about daemon : Jun 07 14:06:45 vm02 systemd[1]: Failed to start SYSV: Starts and stops the pgpool daemon. Jun 07 14:06:45 vm02 systemd[1]: Unit pgpool-II-10.service entered failed state. Jun 07 14:06:45 vm02 systemd[1]: pgpo

Re: Code of Conduct plan

On 06/06/2018 11:22 AM, Tom Lane wrote: I wrote: Yeah, somebody else made a similar point upthread. I guess we felt that the proper procedure was obvious given the structure, but maybe not. I could support adding text to clarify this, perhaps along the line of Hmm ... actually, there's anothe

Re: libpq compression

On 06/06/2018 10:20 AM, Konstantin Knizhnik wrote: Well, psql really allows to specify complete connection string with -d options (although it is not mentioned in help). But still I think that it is inconvenient to require user to write complete connection string to be able to specify compressi

Re: Code of Conduct plan

On 06/05/2018 08:55 PM, Tom Lane wrote: Adrian Klaver writes: On 06/05/2018 04:41 PM, Tom Lane wrote: I'm getting a little tired of people raising hypothetical harms and ignoring the real harms that we're hoping to fix. Yes, this is an experiment and it may not work, but we can't find out wit

Re: Code of Conduct plan

On 06/05/2018 04:41 PM, Tom Lane wrote: Benjamin Scherrey writes: On Wed, Jun 6, 2018 at 2:12 AM, Christophe Pettus wrote: Not at all. The need for a CoC is not theoretical. Real people, recently, have left the community due to harassment, and there was no system within the community to rep

Re: Code of Conduct plan

On 06/05/2018 12:12 PM, Christophe Pettus wrote: On Jun 5, 2018, at 12:06, Benjamin Scherrey wrote: Doesn't that 20 years of results pretty clearly demonstrate that this community does not gain an advantage for adopting a CoC? Not at all. The need for a CoC is not theoretical. Real people

Re: Code of Conduct plan

On 06/05/2018 10:44 AM, James Keener wrote: Your example is flawed because: Multi-Partner has nothing to do with sexuality unless you want to make the argument that your belief is that a relationship should be between one person and another and in this argument a man and a w

Re: Code of Conduct plan

On 06/05/2018 10:26 AM, Chris Travers wrote: Let's role play. I'll be a homophobic person. You've just submitted a proposal suggesting that we change master-master replication to be multi-partner replication. I've told you I don't like the wording because of it's implication of

Re: Code of Conduct plan

On 06/05/2018 09:32 AM, Tom Lane wrote: James Keener writes: I don't participate too much here, but I've never see a group implement a code of conduct go well. Yeah, personally I'm a bit worried about this too. The proposed CoC does contain provisions to try to prevent misusing it, but wheth

Re: Code of Conduct plan

On 06/05/2018 08:41 AM, Lutz Horn wrote: Am 05.06.2018 17:26 schrieb Joshua D. Drake: As one of the people that interacts with external members of the community more than most, I can tell you that a CoC is something the wider community wants. I have sat in feedback meetings with hundreds of

Re: Code of Conduct plan

On 06/05/2018 08:19 AM, Lutz Horn wrote: Am 05.06.2018 17:03 schrieb Chris Travers: On to the code of conduct committee: This needs to be explicitly international and ideally people from very different cultures.  This is the best protection against one small group within one country deciding to

  1   2   3   4   5   6   7   8   9   10   >