Re: which git workflow is used by pg comminuty developers?

On 2020/10/05 16:58, ZHAOWANCHENG wrote: Is one of Git Flow/Github Flow/Gitlab Flow? and why? See: https://wiki.postgresql.org/wiki/Working_with_Git Regards Ian Barwick -- Ian Barwick https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: how to switch off: WARNING: psql major version 11, server major version 13

This warning is generated as a printf() statement by psql itself and is not affected by "client_min_messages" (which sets the level of error messages to be returned from the server). Looking at the source, there's no other way (apart from the -q/--quiet option) to suppres

Re: passing linux user to PG server as a variable ?

this approach. Regards Ian Barwick -- Ian Barwick https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: Keeping state in a foreign data wrapper

shared among the different client / users sessions. Correct, the connections are specific to each individual backend. > But that defeats the purpose, no? The purpose is to cache connections within the session, to avoid the overhead of reconnecting to the remote server eac

Re: Keeping state in a foreign data wrapper

shared among the different client / users sessions. Correct, the connections are specific to each individual backend. > But that defeats the purpose, no? The purpose is to cache connections within the session, to avoid the overhead of reconnecting to the remote server each

Re: Doubt in pgbase

Barwick -- Ian Barwick https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: postgres stats on the new primary

the database, as shown by pg_stats, are of course replicated and will be reliable. More precisely they'll be as up-to-date as the last vacuum/analyze on the former primary, just you won't see the information about when that was. Regards Ian Barwick -- Ian Barwick ht

Re: Automatic failover

eed and certainty. Secondly it will depend on what work the standby needs to do before it completes the promotion process. Typically the standby will promote very quickly, but e.g. if it has a bunch of WAL to replay first, the process will take longer. Regards Ian Barwick -- Ian Barwick

Re: Highly academic: local etcd & Patroni Cluster for testing on a single host

On 2020/02/26 16:55, Paul Förster wrote: Hi Ian, On 26. Feb, 2020, at 01:38, Ian Barwick wrote: Assuming the standby/replica is created using pg_basebackup, you can use the -T/--tablespace-mapping option to remap the tablespace directories. no, with Patroni, replicas are always initiated

Re: Highly academic: local etcd & Patroni Cluster for testing on a single host

y have a single host to do etcd & Patroni cluster experiments on. Assuming the standby/replica is created using pg_basebackup, you can use the -T/--tablespace-mapping option to remap the tablespace directories. Regards Ian Barwick -- Ian Barwick https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: POLL: Adding transaction status to default psql prompt

ult. +1 from me. I've been configuring this in every single .psqlrc I "own" since it was first added in 7.4, and sorely miss it not being just available in environments I don't "own". Regards Ian Barwick

Re: pg_xlog on slaves has grown to 200GB

ROM pg_stat_archiver" will show if issues are being encountered and the PostgreSQL log file will show specifics of any issues) Regards Ian Barwick -- Ian Barwick https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: pg_dump problems: [archiver (db)] query failed: ERROR: relation "pg_opfamily" does not exist

e: - find a 10.9 or earlier package and use the pg_dump from that - build pg_dump yourself - wait for 10.11 to come out (though I imagine that won't be for a month or two) Regards Ian Barwick -- Ian Barwick https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: Default ordering option

ny missing ORDER BY (this assumes nothing else will touch the table and reorder it before the test is run). You could also order by RANDOM() but there would be a chance the rows would end up in sequential order. Regards Ian Barwick -- Ian Barwick https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and Having Problems

've submitted fixes for the empty include directives (which are a special case), I'll see if I can have a look at these ones too. Regards Ian Barwick -- Ian Barwick https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and Having Problems

On 6/21/19 12:34 AM, Ian Barwick wrote: On 6/20/19 11:55 PM, Tom Lane wrote: Brent Bates writes:   I found the problem.  I cleared everything out and started from scratch, then slowly added my changes back to the configuration files.  The problem was in the postgresql.conf.  At the

Re: Testing an extension against multiple versions of Postgresql

sql.org/docs/current//libpq-envars.html Regards Ian Barwick -- Ian Barwick https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: Restoring a database restores to unexpected tablespace

nly --table=sometablename ...) and check exactly what's being dumped and how it gets restored. Regards Ian Barwick -- Ian Barwick https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: how to return rows of data via function written by language C strict

any help will be appreciate. A good place to find working examples is the source code of the various contrib modules. Regards Ian Barwick -- Ian Barwick https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: perl extension error

taly_UAT=# Create extension plperl; > ERROR: could not open extension control file > "/usr/pgsql-11/share/extension/plperl.control": No such file or directory > A4.Italy_UAT=# > > You need to install whatever package contains PL/Perl. Regards Ian Barwick -- Ian B

Re: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and Having Problems

d if there was any potential for circular inclusions and the like. There's a check for nesting depth, but I'm not sure what else. I could take a look in the next few days if no-one else wants to. Regards Ian Barwick -- Ian Barwick https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: pldbgapi error

On 5/20/19 8:57 PM, Prakash Ramakrishnan wrote: On Mon, May 20, 2019 at 5:25 PM Ian Barwick mailto:ian.barw...@2ndquadrant.com>> wrote: On 5/20/19 7:07 PM, Prakash Ramakrishnan wrote:> Hi Team,  >  > We are trying to install the pldbgapi extension in postgresql 1

Re: pldbgapi error

he PostgreSQL 11 source. Check to see if there's updated code available. Regards Ian Barwick -- Ian Barwick https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: PG version recommendation

default version available may be chronically outdated and no longer supported by the community. For example the CentOS 7 out-of-the-box PostgreSQL version is 9.2.24. Regards Ian Barwick -- Ian Barwick https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: Mind of its own?

? Regards Ian Barwick -- Ian Barwick https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: repmgr and SSH

between primary and standby nodes ? Between all three, though outbound SSH connections from the witness node are not essential. We'll clarify the documentation. Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Tra

Re: repmgr and STONIT - SPLIT BAIN

re (location) as the primary can get promoted. STONITH is something you'll need to implement yourself. Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: Tables(s) that feed pg_controldata

On 12/10/2018 11:50 AM, Michael Paquier wrote: On Sun, Dec 09, 2018 at 08:10:57PM -0600, Ron wrote: On 12/09/2018 07:51 PM, Ian Barwick wrote: but you're out of luck for 9.2. The only option to query the desired values via SQL would be to write an extension which reads pg_controldata (pos

Re: Tables(s) that feed pg_controldata

ONS-CONTROLDATA but you're out of luck for 9.2. The only option to query the desired values via SQL would be to write an extension which reads pg_controldata (possibly as a backport of the above-mentioned functions). Regards Ian Barwick -- Ian Barwick http://www.2ndQuad

Re: Streaming Replication between PostGreSQL 9.2.2 on Red Hat and PostGreSQL 9.2.24 on Debian

rwise the identifiers would be the same. Are you sure the PostgreSQL instance running on the standby is the one you backed up with pg_basebackup? Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services

Re: rh-postgresql96 vs community postgresql-9.6

s.git ), or c) persuade your client to switch to a support provider who provides support based around community packages (there are a number, including the one mentioned in my email signature). Regards Ian Barwick -- Ian Barwick http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services