[HACKERS] Proposal: ALTER EXTENSION SET OPTION

y.sql and foo--[version]--unset-parallel-safety.sql -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405 Berlin

Re: [HACKERS] proposal: schema variables

: SET VARIABLE foo='bar'; Perhaps one can have a short form of: SET VAR foo = 'bar'; vs SET foo = 'bar'; -- GUC > > regards, tom lane > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make c

Re: [HACKERS] Oracle to PostGre

y causing the problem. My guess is that either you didn't declare the type properly or there is some other error in your function, but the information provided is not sufficient to answer it. Best or luck asking on -general. -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405 Berlin

Re: [HACKERS] WIP: Restricting pg_rewind to data/wal dirs

upport different use cases well and then build common infrastructure to support the different cases. I am not against building common infrastructure for pg_rewind and pg_basebackup. I am very much against having the core guarantees being the exact same. Best Wishes, Chris Travers On Sat, Oct 28, 20

Re: [HACKERS] Patch: restrict pg_rewind to whitelisted directories

On Tue, Oct 31, 2017 at 1:38 PM, Robert Haas wrote: > On Mon, Oct 30, 2017 at 6:44 PM, Chris Travers > wrote: > > The attached patch is cleaned up and filed for the commit fest this next > > month: > > It's generally better to post the patch on the same message as t

[HACKERS] Anyone have experience benchmarking very high effective_io_concurrency on NVME's?

ns of PostgreSQL to bump this setting up to ever higher values, I am wondering if anyone has done this yet and if so if you would be willing to share results. -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a,

[HACKERS] Patch: restrict pg_rewind to whitelisted directories

d2fa1 tag: mine/pg_rewind_restrict_dirs parent: 60446:e638ba9c3c11 user: Chris Travers date:Mon Oct 30 12:25:18 2017 +0100 files: doc/src/sgml/ref/pg_rewind.sgml src/bin/pg_rewind/copy_fetch.c src/bin/pg_rewind/fetch.c src/bin/pg_rewind/fetch.h src/bin

Re: [HACKERS] WIP: Restricting pg_rewind to data/wal dirs

On Mon, Oct 30, 2017 at 11:36 AM, Michael Paquier wrote: > On Mon, Oct 30, 2017 at 10:15 AM, Chris Travers > wrote: > > This also brings up a fairly major concern more generally about control > by > > the way. A lot of cases where pg_rewind is called, the user doesn't

Re: [HACKERS] WIP: Restricting pg_rewind to data/wal dirs

On Mon, Oct 30, 2017 at 10:57 AM, Michael Paquier wrote: > On Mon, Oct 30, 2017 at 9:43 AM, Chris Travers > wrote: > > Are there any cases right now where you have features added by > extensions that write to directories which are required for a rewind? > > In some of th

Re: [HACKERS] WIP: Restricting pg_rewind to data/wal dirs

First, thanks for your thoughts on this, and I am interested in probing them more. On Mon, Oct 30, 2017 at 9:04 AM, Michael Paquier wrote: > On Sat, Oct 28, 2017 at 4:22 AM, Chris Travers > wrote: > > The Solution: > > The solution is a whitelist of directories specified

Re: [HACKERS] proposal: schema variables

ter the output. > > Regards > > Pavel > > > > >> >> >>> regards >>> >>> Pavel >>> >>> >>> >> >> >> -- >> Best Regards, >> Chris Travers >> Database Administrator >> &

Re: [HACKERS] proposal: schema variables

settings. 3. In a subsequent stage you might be able to SELECT INTO setting_name FROM ; allowing access to setting writes based on queries. > regards > > Pavel > > > -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405 Berlin

[HACKERS] WIP: Restricting pg_rewind to data/wal dirs

ore descriptive name but currently did not remove the old function yet. Feedback is very welcome. pg_rewind is a very nice piece of software. I am hoping that these sorts of changes will help ensure that it is easier to use and provides more predictable results. -- Best Regards, Chris T

Re: [HACKERS] Add Roman numeral conversion to to_number

!: dfetter > Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com > > Remember to vote! > Consider donating to Postgres: http://www.postgresql.org/about/donate > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405 Berlin

Re: [HACKERS] pg_rewind proposed scope and interface changes

On Wed, Sep 13, 2017 at 6:28 AM, Michael Paquier wrote: > On Tue, Sep 12, 2017 at 11:52 PM, Chris Travers > wrote: > > Additionally the wal, xact, timestamp and logical directories must be > > processed in some way. > > To what does the term "logical directories&

[HACKERS] pg_rewind proposed scope and interface changes

. Problems that we will not try to solve: * Rewinding past table creation orphans table file. This is a complex topic on its own and probably needs a separate utility. Thoughts? -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com

Re: [HACKERS] Proposal: pg_rewind to skip config files

p of patches, and then submitting them as they become complete. > -- > Álvaro Herrera https://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services > -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405 Berlin

Re: [HACKERS] Proposal: pg_rewind to skip config files

undo subsystem would fix this. Is this a reason to rethink the idea that maybe a pg_fsck utility might be useful that could be run immediately after a rewind? -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405 Berlin

Re: [HACKERS] Proposal: pg_rewind to skip config files

under heavy load. > How would this work when it comes to rewinding against a file directory? > > -- > May the force be with you… > https://simply.name > > -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405 Berlin

Re: [HACKERS] Proposal: pg_rewind to skip config files

On Tue, Sep 5, 2017 at 1:04 PM, Michael Paquier wrote: > On Tue, Sep 5, 2017 at 7:54 PM, Vladimir Borodin wrote: > > 5 сент. 2017 г., в 12:31, Chris Travers > > написал(а): > > > > I think the simplest solution for now is to skip any files ending in > .conf, >

Re: [HACKERS] Proposal: pg_rewind to skip config files

On Tue, Sep 5, 2017 at 12:54 PM, Vladimir Borodin wrote: > > 5 сент. 2017 г., в 12:31, Chris Travers > написал(а): > > I think the simplest solution for now is to skip any files ending in > .conf, .log, and serverlog. > > > Why don’t you want to solve the problem once

Re: [HACKERS] Proposal: pg_rewind to skip config files

On Mon, Sep 4, 2017 at 3:38 PM, Alvaro Herrera wrote: > Chris Travers wrote: > > On Mon, Sep 4, 2017 at 12:23 PM, Michael Paquier < > michael.paqu...@gmail.com> > > wrote: > > > > > On Mon, Sep 4, 2017 at 7:21 PM, Michael Paquier > > > wr

Re: [HACKERS] Proposal: pg_rewind to skip config files

sequently, I think it would be good to fix in the tool. The fundamental question is if there is any reason someone would actually want to copy config files over. -- > Michael > -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405 Berlin

Re: [HACKERS] Proposal: pg_rewind to skip config files

of any cases where anyone would actually want to do this but that doesn't mean they aren't out there. If people really want to, then they need to copy the configuration files they want separately. Next Steps: If people like this idea I will add test cases and edit documentation as app

[HACKERS] Proposal: pg_rewind to skip config files

file tree traversal. Any feedback before I create.a proof of concept? -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405 Berlin

Re: [HACKERS] Proposal: global index

On Fri, Aug 25, 2017 at 12:15 PM, Petr Jelinek wrote: > On 25/08/17 10:28, Chris Travers wrote: > > > > > > On Thu, Aug 24, 2017 at 9:44 PM, Andres Freund > <mailto:and...@anarazel.de>> wrote: > > > > Hi, > > > > On 2017-08-18

Re: [HACKERS] Thoughts on unit testing?

y of moving forward. But I still think the question of what to test ought to be geared around "what are we willing to try to guarantee as behaviour for some years, not just to ourselves but to third parties." > > Greetings, > Torsten > > > -- > Sent via pgsql-hacker

Re: [HACKERS] Proposal: global index

ailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405 Berlin

Re: [HACKERS] Proposal: global index

On Aug 21, 2017 07:47, "Simon Riggs" wrote: On 18 August 2017 at 15:40, Alvaro Herrera wrote: > Ildar Musin wrote: > >> While we've been developing pg_pathman extension one of the most frequent >> questions we got from our users was about global index support. We cannot >> provide it within an e

Re: [HACKERS] [RFC] What would be difficult to make data models pluggable for making PostgreSQL a multi-model database?

On Sun, Aug 20, 2017 at 4:10 AM, MauMau wrote: > From: Chris Travers > > Why cannot you do all this in a language handler and treat as a user > defined function? > > ... > > If you have a language handler for cypher, why do you need in_region > or cast_region? Why n

Re: [HACKERS] [RFC] What would be difficult to make data models pluggable for making PostgreSQL a multi-model database?

e data models pluggable, > especially related to plugging the parser, planner, executor, etc? > One possible concern is that various PostgreSQL components might be > too dependent on the data model being relational, and it would be > difficult to separate tight coupling. > I guess I am m

Re: [HACKERS] Proposal: global index

hear it. > > [1] https://www.postgresql.org/message-id/c8fe4f6b-ff46-aae0-89e > 3-e936a35f0cfd%40postgrespro.ru > > Thanks! > > -- > Ildar Musin > i.mu...@postgrespro.ru > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make chang

Re: [HACKERS] Orphaned files in base/[oid]

l programs to do after-the-fact review and cleanup. > > Greetings, > > Andres Freund > -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405 Berlin

Re: [HACKERS] Orphaned files in base/[oid]

make sure everything is ok? -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405 Berlin

Re: [HACKERS] Orphaned files in base/[oid]

On Tue, Aug 15, 2017 at 3:32 PM, Tom Lane wrote: > Chris Travers writes: > > I wonder about a different solution. Would it be possible to special > case > > vacuum to check for and remove (or just move to where they can be > removed) > > files when vacuuming pg_

Re: [HACKERS] Orphaned files in base/[oid]

we ought to be able to know that a relfilenode shouldn't be used anymore, right? -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405 Berlin

Re: [HACKERS] Orphaned files in base/[oid]

ions but that I might be able to do. > > regards, tom lane > -- Best Regards, Chris Travers Database Administrator Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com Saarbrücker Straße 37a, 10405 Berlin

Re: [HACKERS] Orphaned files in base/[oid]

On Mon, Aug 14, 2017 at 6:33 PM, Andres Freund wrote: > Hi, > > On 2017-08-14 14:12:22 +0200, Chris Travers wrote: > > Problem: > > The system this came up on is PostgreSQL 9.6.3 and has had repeated > trouble > > with disk space. Querying pg_database_size, as well

Re: [HACKERS] Orphaned files in base/[oid]

On Aug 14, 2017 14:12, "Chris Travers" wrote: Hi all; I am trying to track down a problem we are seeing that looks very similar to bug #12050, and would certainly consider trying to contribute a fix if we agree on one. (I am not sure we can, so absent that, the next question is

[HACKERS] Orphaned files in base/[oid]

various operations including creating materialised views. So my question is if there is a way we can safely clean these up on server restart? If not does it make sense to try to create a utility that can connect to PostgreSQL, seek out valid files, and delete the rest? -- Best Regards, Chris Travers

Re: [HACKERS] Funny WAL corruption issue

On Fri, Aug 11, 2017 at 1:33 PM, Greg Stark wrote: > On 10 August 2017 at 15:26, Chris Travers wrote: > > > > > > The bitwise comparison is interesting. Remember the error was: > > > > pg_xlogdump: FATAL: error in WAL record at 1E39C/E1117FB8: unexpected &

Re: [HACKERS] Funny WAL corruption issue

On Fri, Aug 11, 2017 at 1:33 PM, Greg Stark wrote: > On 10 August 2017 at 15:26, Chris Travers wrote: > > > > > > The bitwise comparison is interesting. Remember the error was: > > > > pg_xlogdump: FATAL: error in WAL record at 1E39C/E1117FB8: unexpected &

Re: [HACKERS] Funny WAL corruption issue

ut wal records ISTR have a separate CRC check), would this perhaps indicate that the checksum operated over incorrect data? > > -- > Vladimir Rusinov > PostgreSQL SRE, Google Ireland > > Google Ireland Ltd.,Gordon House, Barrow Street, Dublin 4, Ireland > Registered in Dubl

Re: [HACKERS] Funny WAL corruption issue

pg_xlogdump: FATAL: error in WAL record at 1E39C/E1117FB8: unexpected pageaddr 1E375/61118000 in log segment 0001E39C00E1, offset 1146880 > -- Best Wishes, Chris Travers Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in. http://www.efficito.com/learn_more

Re: [HACKERS] Funny WAL corruption issue

Sorry, meant to reply all. On Thu, Aug 10, 2017 at 2:19 PM, Vladimir Borodin wrote: > Hi, Chris. > > 10 авг. 2017 г., в 15:09, Chris Travers > написал(а): > > Hi; > > I ran into a funny situation today regarding PostgreSQL replication and > wal corruption and wan

[HACKERS] Funny WAL corruption issue

hings from happening in the future if, for example, a replica dies in the middle of a wal fsync. -- Best Wishes, Chris Travers Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in. http://www.efficito.com/learn_more

Re: [HACKERS] 9.3 Json & Array's

originally thought but that just means it will take longer. > > cheers > > andrew > > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers Best Wishes, Chris Travers http://www.2ndquadrant.com PostgreSQL Services, Training, and Support

Re: [HACKERS] 9.3 Json & Array's

","PS4","ACTION","FIRST PERSON > SHOOTER"],"external_api_key":null}]'::JSON > > SELECT * FROM json_populate_recordset(null::varrm.item, '[{"title":"My > Title","short_desc":"My Short Desc"

Re: [HACKERS] Proposal: json_populate_record and nested json objects

ether to merge the changes into the core, This will be an interesting way to get into PostgreSQL hacking. Best Wishes, Chris Travers > > merlin > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http

Re: [HACKERS] Minmax indexes

his would be a frequently moving target and over years of billing, the subset would be quite small compared to the full system (imagine, say, 50k rows out of 20M). Best Wises, Chris Travers > > - Heikki > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) &

Re: [HACKERS] Proposal: json_populate_record and nested json objects

> On 15 September 2013 at 18:42 Andrew Dunstan wrote: > > > > On 09/14/2013 10:27 PM, chris travers wrote: > > Well, you could fairly easily build it as an extension as a POC. The > main point of the API this is built on was to allow for extensions. > > The logic

[HACKERS] Proposal: json_populate_record and nested json objects

build something like this first as an extension (perhaps with different function names) or first as a patch? Best Wishes, Chris Travers http://www.2ndquadrant.com PostgreSQL Services, Training, and Support

Re: [HACKERS] Proposal: PL/PgSQL strict_mode

comment away any time you please. Well, I don't know if my feedback above is helpful, but there it is ;-) > > > Regards, > Marko Tiikkaja > > [1]: http://www.postgresql.org/message-id/510bf731.5020...@gmx.net > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers Best Wishes, Chris Travers http://www.2ndquadrant.com PostgreSQL Services, Training, and Support

Re: [HACKERS] [GENERAL] Creating temp tables inside read only transactions

chemas of the form "parent!%".  In this case the "%" sign could maybe only > match everything except "!" and the "*" symbol could be used to match "!" as > well. Agreed that this would be helpful. I would personally have a lot of use for this sort o

[HACKERS] Question about the TODO, numerics, and division

missing something? Best Wishes, Chris Travers begin:vcard fn:Chris Travers n:Travers;Chris email;internet:[EMAIL PROTECTED] tel;work:509-888-0220 tel;cell:509-630-7794 x-mozilla-html:FALSE version:2.1 end:vcard ---(end of broadcast)--- TIP 4:

Re: [GENERAL] [HACKERS] 'a' == 'a '

that they are the same length before performing the comparison. Understood, but what gain do you have in a case like this that might justify the effort that would go into making it, say, an initdb option? How often does this behavior cause problems? Best Wishes, Chris Travers Metatron

Re: [GENERAL] [HACKERS] 'a' == 'a '

higher than it is in many other cases. Best Wishes, Chris Travers Metatron Technology Consulting ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] [pgsql-advocacy] Spikewatch testing

ing to get someone to commit to helping me on the contest, so that PostgreSQL can participate. What is involved in this? Maybe if you give specifics one of us can commit to helping :-) Best Wishes, Chris Travers Metatron Technology Consulting ---(end of

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

e of development. Maybe have it divided into two sections: Bids and Bounties. Best Wishes, Chris Travers Metatron Technology Consulting ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] [GENERAL] CREATE DATABASE on the heap with PostgreSQL?

worms regarding these topics which is best left untouched. Best Wishes, Chris Travers Metatron Technology Consulting ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [pgsql-advocacy] [HACKERS] What can we learn from MySQL?

for that feature. As the lead in a project whose roadmap has changed many times due to paid contracts, I don't really see the value of published roadmaps in general. Best Wishes, Chris Travers ---(end of broadcast)--- TIP 3: if posting/rea

Re: [HACKERS] [pgsql-advocacy] What can we learn from MySQL?

tabase (yes, the Cygwin installer because of the ipc stuff is a reasonable barrier to entry). Best Wishes, Chris Travers Metatron Technology Consulting ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [pgsql-advocacy] [HACKERS] What can we learn from MySQL?

llation isntructions is enough to give you second thoughts MS SQL does have a nice installer, however, as do most binary open source products for Windows. I am completely confident that PostgreSQL for Windows, when it arrives, will have a nice GUI-based installer. Best Wishes, Chris Travers M

Re: [HACKERS] [GENERAL] Should we consider empty fields as NULL values when

e values and substitute as appropriate. That is not the answer you were looking for, but... For example (PHP): function db_quote($db_var){ if ($db_var === NULL){ return 'NULL'; } else { return "'$db_var'"; } } T