Re: User documentation vs Official Docs

> On Jul 16, 2018, at 8:08 PM, Alvaro Herrera wrote: > > On 2018-Jul-16, Joshua D. Drake wrote: > >> Think of this (if we can figure out how to pull this off): User on >> StackOverflow says, "How do I do X", someone answers with a direct >> link to a recipe on PostgreSQL.Org that tells them exa

How to create logical replication slot with NOEXPORT_SNAPSHOT in jdbc

Hello Everybody. We are trying to use logical decoding for detecting database changes. However, when we create a replication slot, the data processing pauses if there are still transactions running from before the slot creation. If I understand correctly, the slot is waiting for creating a consiste

Re: User documentation vs Official Docs

On Mon, 16 Jul 2018 at 20:14, Joshua D. Drake wrote: > > 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 c

Re: PG backup check

On Mon, Jul 16, 2018 at 8:35 PM, Ravi Krishna wrote: > Not sure I am following this. Did Google release this because PG backups > are not 100% reliable or the data corruption can occur due to hardware > failure. > > http://www.eweek.com/cloud/google-releases-open-source- > tool-that-checks-postg

PG backup check

Not sure I am following this. Did Google release this because PG backups are not 100% reliable or the data corruption can occur due to hardware failure. http://www.eweek.com/cloud/google-releases-open-source-tool-that-checks-postgres-backup-integrity?utm_medium=email&utm_campaign=EWK_NL_EP_201807

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 2018-Jul-16, Joshua D. Drake wrote: > Think of this (if we can figure out how to pull this off): User on > StackOverflow says, "How do I do X", someone answers with a direct > link to a recipe on PostgreSQL.Org that tells them exactly how to do X > (with caveats of course). There isn't much mo

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/ || @cmd

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 >wrote: On 07/16/2018 03:14 PM, David G. Johnston wrote: What does the community think about a community run, community organized, sub project fo

Re: User documentation vs Official Docs

On 07/16/2018 03:18 PM, Joshua D. Drake wrote: 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/articl

Re: User documentation vs Official Docs

On Mon, Jul 16, 2018 at 3:19 PM, Joshua D. Drake wrote: > 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 config

Re: Do we need yet another IDE (SQL development assistant) for PostgreSQL?

Dmitry Igrishin writes: > пн, 16 июл. 2018 г. в 1:14, Tim Cross : > >> >> Your idea to make it integrate with user's preferred editor is a good >> idea as editors are like opinions and certain anatomical parts - >> everyone has one! Finding an appropriate API to do this will be a >> challenge.

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: Query to monitor index bloat

On 07/16/2018 11:50 PM, Alessandro Aste wrote: > Thanks much, I'll check that out.  I see the queries are 3 years old so I'm > wondering if they still work for 9.6.x or 10 AFAIK they work. You can try yourself by comparing bloated table/index size before and after vacuum full or reindex ;) sig

Re: User documentation vs Official Docs

On Mon, Jul 16, 2018 at 1:32 PM, Joshua D. Drake wrote: > -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

Re: User documentation vs Official Docs

Joshua D. Drake writes: > -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" d

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 > 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 go, in the offic

Re: User documentation vs Official Docs

On Mon, Jul 16, 2018 at 5:44 PM, Joshua D. Drake 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 go, in the official docs, already split out >>> by version, and it starts here: >>> >>> https://www.pos

Re: Query to monitor index bloat

Thanks much, I'll check that out. I see the queries are 3 years old so I'm wondering if they still work for 9.6.x or 10 Il lun 16 lug 2018, 17:44 Adrien NAYRAT ha scritto: > On 07/16/2018 05:16 PM, Alessandro Aste wrote: > > Hello, I am trying to put togheter a query to monitor the index bloat

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 sound

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:48 PM, Joshua D. Drake wrote: 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 goin

Re: User documentation vs Official Docs

Greetings, * Benjamin Scherrey (scher...@proteus-tech.com) wrote: > One thing I recall very fondly about the early days of the Lamp stack was > that the official documentation of PHP and MySQL was augmented with user > created practical examples. It was still reference documentation organized > by

Re: User documentation vs Official Docs

"Joshua D. Drake" writes: > 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... You haven't exactly explained

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

Re: User documentation vs Official Docs

On Tue, Jul 17, 2018, 3:33 AM Joshua D. Drake wrote: > -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 the

Re: User documentation vs Official Docs

Joshua D. Drake schrieb am 16.07.2018 um 22:32: -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

Re: User documentation vs Official Docs

On 07/16/2018 01:32 PM, Joshua D. Drake wrote: -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 th

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: Query to monitor index bloat

On 07/16/2018 05:16 PM, Alessandro Aste wrote: Hello,  I am trying to put togheter a query to monitor the index bloat for a database I maintain. Is there a "SQL" way to obtain  bloated index ? I googled around but I found nothing working. I'm currently running 9.6 but I'm looking for something

Query to monitor index bloat

Hello, I am trying to put togheter a query to monitor the index bloat for a database I maintain. Is there a "SQL" way to obtain bloated index ? I googled around but I found nothing working. I'm currently running 9.6 but I'm looking for something compatible with version 10 too. Thank you very mu

Re: Do we need yet another IDE (SQL development assistant) for PostgreSQL?

Ah thanks, I stand corected! :) Tim Clarke On 16/07/18 15:04, Josef Šimánek wrote: > It is licensed under MIT - https://github.com/Microsoft/vscode. > > 2018-07-16 13:09 GMT+02:00 Tim Clarke : >> -1 for VSC not being open source >> >> Tim Clarke >> >>

Re: Do we need yet another IDE (SQL development assistant) for PostgreSQL?

It is licensed under MIT - https://github.com/Microsoft/vscode. 2018-07-16 13:09 GMT+02:00 Tim Clarke : > -1 for VSC not being open source > > Tim Clarke > > > On 16/07/18 11:47, Dmitry Igrishin wrote: >> >> >> пн, 16 июл. 2018 г. в 13:41, Tim Clarke >> >

RE: Do we need yet another IDE (SQL development assistant) for PostgreSQL?

VS Code is open source (MIT License). You may be thinking of Visual Studo, the closed source IDE - the two are not the same Met vriendlijke groet, REDstack BV Chris Coutinho Onderzoeker/Data analist -Original Message- From: Tim Clarke [mailto:tim.cla...@minerva-analytics.info] Sent: ma

Re: Do we need yet another IDE (SQL development assistant) for PostgreSQL?

-1 for VSC not being open source Tim Clarke On 16/07/18 11:47, Dmitry Igrishin wrote: > > > пн, 16 июл. 2018 г. в 13:41, Tim Clarke > >: > > +1 for not re-inventing the wheel - building on Netbeans or the > Eclipse > project would save you h

Re: Do we need yet another IDE (SQL development assistant) for PostgreSQL?

2018-07-16 15:22 GMT+02:00 Dmitry Igrishin : > > > пн, 16 июл. 2018 г. в 16:00, Pavel Stehule : > >> >> >> 2018-07-16 14:28 GMT+02:00 Dmitry Igrishin : >> >>> >>> >>> пн, 16 июл. 2018 г. в 15:01, Pavel Stehule : >>> 2018-07-16 13:52 GMT+02:00 Dmitry Igrishin : > > >

Re: Do we need yet another IDE (SQL development assistant) for PostgreSQL?

пн, 16 июл. 2018 г. в 16:00, Pavel Stehule : > > > 2018-07-16 14:28 GMT+02:00 Dmitry Igrishin : > >> >> >> пн, 16 июл. 2018 г. в 15:01, Pavel Stehule : >> >>> >>> >>> 2018-07-16 13:52 GMT+02:00 Dmitry Igrishin : >>> пн, 16 июл. 2018 г. в 14:26, : > We – and the majority of

Re: Do we need yet another IDE (SQL development assistant) for PostgreSQL?

2018-07-16 14:28 GMT+02:00 Dmitry Igrishin : > > > пн, 16 июл. 2018 г. в 15:01, Pavel Stehule : > >> >> >> 2018-07-16 13:52 GMT+02:00 Dmitry Igrishin : >> >>> >>> >>> пн, 16 июл. 2018 г. в 14:26, : >>> We – and the majority of our customers - are mainly focused on Windows. We use pgadmin

Re: Do we need yet another IDE (SQL development assistant) for PostgreSQL?

пн, 16 июл. 2018 г. в 15:01, Pavel Stehule : > > > 2018-07-16 13:52 GMT+02:00 Dmitry Igrishin : > >> >> >> пн, 16 июл. 2018 г. в 14:26, : >> >>> We – and the majority of our customers - are mainly focused on Windows. >>> We use pgadmin iii and our own assistants. pgadmin iv ist still too slow on >

Re: Do we need yet another IDE (SQL development assistant) for PostgreSQL?

2018-07-16 13:52 GMT+02:00 Dmitry Igrishin : > > > пн, 16 июл. 2018 г. в 14:26, : > >> We – and the majority of our customers - are mainly focused on Windows. >> We use pgadmin iii and our own assistants. pgadmin iv ist still too slow on >> Windows compared to pgadmin iii. That is one reason why w

Re: Do we need yet another IDE (SQL development assistant) for PostgreSQL?

пн, 16 июл. 2018 г. в 14:26, : > We – and the majority of our customers - are mainly focused on Windows. We > use pgadmin iii and our own assistants. pgadmin iv ist still too slow on > Windows compared to pgadmin iii. That is one reason why we still use > PostgreSQL 9.6. > For performance reasons

AW: Do we need yet another IDE (SQL development assistant) for PostgreSQL?

We – and the majority of our customers - are mainly focused on Windows. We use pgadmin iii and our own assistants. pgadmin iv ist still too slow on Windows compared to pgadmin iii. That is one reason why we still use PostgreSQL 9.6. That said, one requirement on a commercial tool for us wou

Re: Do we need yet another IDE (SQL development assistant) for PostgreSQL?

Tim Clarke schrieb am 16.07.2018 um 11:52: > +1 for not re-inventing the wheel - building on Netbeans or the Eclipse > project would save you heaps of time and effort and provide > cross-platform out of the box. I use Eclipse all the time. The NetBeans platform (and Eclipse as well) is based on Ja

Re: Do we need yet another IDE (SQL development assistant) for PostgreSQL?

пн, 16 июл. 2018 г. в 13:41, Tim Clarke : > +1 for not re-inventing the wheel - building on Netbeans or the Eclipse > project would save you heaps of time and effort and provide > cross-platform out of the box. I use Eclipse all the time. > I agree and don't want to waste my time for reinventing t

Re: Do we need yet another IDE (SQL development assistant) for PostgreSQL?

+1 for not re-inventing the wheel - building on Netbeans or the Eclipse project would save you heaps of time and effort and provide cross-platform out of the box. I use Eclipse all the time. Tim Clarke On 15/07/18 20:41, Chuck Davis wrote: > If you decide to proceed on this project there's no ne

Re: Building a notification system.

On 15 July 2018 at 23:25, Anto Aravinth wrote: > > > On Mon, Jul 16, 2018 at 8:02 AM, Christopher Browne > wrote: > >> On Sun, Jul 15, 2018, 5:30 AM Anto Aravinth, >> wrote: >> >>> Hello Everyone, >>> >>> >>> I'm playing around with postgresql with SO datasets. In the process, I >>> have dumped

Re: Do we need yet another IDE (SQL development assistant) for PostgreSQL?

Il 16.07.2018 11:41, Albrecht Dreß ha scritto: Am 16.07.18 00:14 schrieb(en) Tim Cross: Thank you for the point. I'm the C++ programmer and I'm author of the C++ client library for PostgreSQL - Pgfe and I'm going to use it in this project. But I'm not sure about the cross-platform GUI toolkit.

Re: Do we need yet another IDE (SQL development assistant) for PostgreSQL?

пн, 16 июл. 2018 г. в 12:41, Albrecht Dreß : > Am 16.07.18 00:14 schrieb(en) Tim Cross: > >> Thank you for the point. I'm the C++ programmer and I'm author of the > C++ client library for PostgreSQL - Pgfe and I'm going to use it in this > project. But I'm not sure about the cross-platform GUI too

Re: Do we need yet another IDE (SQL development assistant) for PostgreSQL?

Am 16.07.18 00:14 schrieb(en) Tim Cross: Thank you for the point. I'm the C++ programmer and I'm author of the C++ client library for PostgreSQL - Pgfe and I'm going to use it in this project. But I'm not sure about the cross-platform GUI toolkit. The cross-platform GUI toolkit will be the ch

Re: Do we need yet another IDE (SQL development assistant) for PostgreSQL?

пн, 16 июл. 2018 г. в 2:15, Christophe Pettus : > > > On Jul 15, 2018, at 16:06, Dmitry Igrishin wrote: > > > > The cross-platform GUI toolkit will be the challenge. > > This is why I've consider GUI for the Windows only. And if I'll not find > an adequate GUI > > toolkit (at reasonable price and