Find dangling membership roles in pg_dumpall

2023-04-26 Thread Andreas 'ads' Scherbaum
ch. Regards -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact, Germany - PostgreSQL Project diff --git a/src/bin/pg_dump/pg_dumpall.c b/src/bin/pg_dump/pg_dumpall.c index 71a131986

Re: generate_series for timestamptz and time zone problem

2023-03-03 Thread Andreas 'ads' Scherbaum
the date the country switches to standard time). Minor nitpick: the texts use both "time zone" and "timezone". Regards, -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact, Germany - PostgreSQL Project

Re: Make ON_ERROR_STOP stop on shell script failure

2023-02-16 Thread Andreas 'ads' Scherbaum
On 16/02/2023 20:33, Andreas 'ads' Scherbaum wrote: On 23/11/2022 00:16, Matheus Alcantara wrote: --- Original Message --- On Tuesday, November 22nd, 2022 at 20:10, bt22nakamorit wrote: There was a mistake in the error message for \! so I updated the patch. Best, Tatsuhiro

Re: Make ON_ERROR_STOP stop on shell script failure

2023-02-16 Thread Andreas 'ads' Scherbaum
that it failed to be applied into the master cleanly. Could you please rebase it? Was also looking into this patch. Tatsuhiro: can you please send a rebased version? Thanks -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board

Re: GSoC 2021 Proposal Document

2021-04-19 Thread Andreas 'ads' Scherbaum
il.com This discusses a number of suggested changes, and might be useful for your proposal. Regards, -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact, Germany - PostgreSQL Project

Re: [PATCH] Improvements to "Getting started" tutorial for Google Code-in task

2018-11-06 Thread Andreas 'ads' Scherbaum
The following review has been posted through the commitfest application: make installcheck-world: not tested Implements feature: not tested Spec compliant: not tested Documentation:not tested This is a documentation update, no code changes. The initial idea came from

Re: [PATCH] Improvements to "Getting started" tutorial for Google Code-in task

2018-11-05 Thread Andreas 'ads' Scherbaum
On 05.11.18 09:22, LAM JUN RONG wrote: New diff is attached. This still has the "hard" in it. Everything else looks fine. Once you changed that, please register the new patch in the Commitfest application. Regards, -- Andreas 'ads' Scherb

Re: [PATCH] Improvements to "Getting started" tutorial for Google Code-in task

2018-11-04 Thread Andreas 'ads' Scherbaum
his limit by modifying the NAMEDATALEN variable, but that would require recompiling PostgreSQL. you will need to quote the the identifier, like "1st database". Database names are limited to 63 bytes in length, or more specifically to the length defined in NAMEDATALEN. Changing thi

Re: [PATCH] Improvements to "Getting started" tutorial for Google Code-in task

2018-11-03 Thread Andreas 'ads' Scherbaum
ALEN here as well. The part about the first character is correct - except you quote the name. Then any name is allowed. If you rewrite this part, maybe include this as well. The other changes look good. -- Andreas 'ads' Scherbaum German PostgreSQL Use

Re: Installation instructions update (pg_ctl)

2018-11-03 Thread Andreas 'ads' Scherbaum
On 30.10.18 14:52, Andreas 'ads' Scherbaum wrote: On 30.10.18 09:04, Michael Banck wrote: Hi, On Tue, Oct 30, 2018 at 12:08:49AM +0100, Andreas 'ads' Scherbaum wrote: The installation instructions (short version) are not consistent with the "initdb" output. The first one still uses

Re: INSTALL file

2018-11-03 Thread Andreas 'ads' Scherbaum
On 03.11.18 18:06, Stephen Frost wrote: Greetings, * Andreas 'ads' Scherbaum (a...@pgug.de) wrote: On 02.11.18 01:38, Stephen Frost wrote: * Andreas 'ads' Scherbaum (a...@pgug.de) wrote: How about the attached one? Picked up your draft, and cleaned it up a bit. (unsurprisingly

Re: INSTALL file

2018-11-02 Thread Andreas 'ads' Scherbaum
On 02.11.18 01:38, Stephen Frost wrote: Greetings, * Andreas 'ads' Scherbaum (a...@pgug.de) wrote: How about the attached one? Picked up your draft, and cleaned it up a bit. (unsurprisingly) this is looking pretty good to me. A few additional notes: Incorporated. See the attached

Re: INSTALL file

2018-11-01 Thread Andreas 'ads' Scherbaum
On 01.11.18 18:41, Stephen Frost wrote: Greetings, * Andreas 'ads' Scherbaum (a...@pgug.de) wrote: On 01.11.18 07:26, Michael Paquier wrote: It includes links to the website, as well as the short version of the installation instructions. +The installation instructions are listed

Re: INSTALL file

2018-11-01 Thread Andreas 'ads' Scherbaum
On 01.11.18 07:26, Michael Paquier wrote: On Thu, Nov 01, 2018 at 01:32:09AM +0100, Andreas 'ads' Scherbaum wrote: Picking up on this idea, attached is a first draft for changing the README. Why don't you add it to the upcoming commit fest? It would be good to get some traction with a formal

Re: INSTALL file

2018-10-31 Thread Andreas 'ads' Scherbaum
would be a good thing. Picking up on this idea, attached is a first draft for changing the README. It includes links to the website, as well as the short version of the installation instructions. Regards, -- Andreas 'ads' Scherbaum German PostgreSQL User Group

Re: Installation instructions update (pg_ctl)

2018-10-30 Thread Andreas 'ads' Scherbaum
On 30.10.18 09:04, Michael Banck wrote: Hi, On Tue, Oct 30, 2018 at 12:08:49AM +0100, Andreas 'ads' Scherbaum wrote: The installation instructions (short version) are not consistent with the "initdb" output. The first one still uses "postgres -D", even mentions

Re: INSTALL file

2018-10-30 Thread Andreas 'ads' Scherbaum
On 30.10.18 11:49, Andrew Dunstan wrote: On 10/30/2018 06:14 AM, Andreas 'ads' Scherbaum wrote: On 30.10.18 04:11, Michael Paquier wrote: On Mon, Oct 29, 2018 at 01:01:47PM +0100, Andreas 'ads' Scherbaum wrote: That is not the first file people looking at. Especially not people looking

Installation instructions update (pg_ctl)

2018-10-29 Thread Andreas 'ads' Scherbaum
pdates the short install instructions and replaces "postgres -D" with "pg_ctl" calls. The long version is left as it is, because it describes both "postgres -D" and "pg_ctl" as a wrapper. Regards, -- Andreas 'ads' Scherbaum

INSTALL file

2018-10-28 Thread Andreas 'ads' Scherbaum
ed on the platform (Linux, BSD, Windows, Source) Regards, -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact, Germany - PostgreSQL Project

Re: [PoC PATCH] Parallel dump to /dev/null

2018-03-05 Thread Andreas 'ads' Scherbaum
NULL. Regards, -- Andreas 'ads' Scherbaum German PostgreSQL User Group European PostgreSQL User Group - Board of Directors Volunteer Regional Contact, Germany - PostgreSQL Project

Re: [PATCH] Find additional connection service files in pg_service.conf.d directory

2018-03-05 Thread Andreas 'ads' Scherbaum
> Looked over this patch and found that you limit the directory entries to files only. Would it make sense to allow links as well? That would allow other programs/distributions to place a link in the config directory and point to a service file in their own directory. Regards, -- Andreas