Re: Code of Conduct plan

e list subscribers who also have a slackogger account. -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu signature.asc Description: OpenPGP digital signature

Re: Code of Conduct plan

r world with things worded this way. "The issue isn't whether you're paranoid, it's whether you're paranoid enough" -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu signature.asc Description: OpenPGP digital signature

Re: Code of Conduct plan

On 09/14/2018 12:46 PM, Peter Geoghegan wrote: > On Fri, Sep 14, 2018 at 10:31 AM, Dimitri Maziuk > wrote: >> So let me get this straight: you want to have a "sanctioned" way to deny >> people access to postgresql community support channel? > > Yes. A quest

Re: Code of Conduct plan

o postgresql community support channel? "Because somebody who may or may not be the same person, allegedly said something somewhere that some other tweet disagreed with on faceplant"? Great plan if you do for-pay postgresql support for the living. -- Dimitri Maziuk Progr

Re: Code of Conduct plan

ried by the same air in the same atmosphere as theirs. Please stand by while the black helicopters are being dispatched to your current location, you will be shot in the face and dropped in the ocean shortly. Have a nice day -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW

Re: increasing HA

ite on a public-facing database, the above won't work for you. -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu signature.asc Description: OpenPGP digital signature

Re: PostgreSQL: Copy from File missing data error

ou could play with csv.Reader and unicode/bytes encode/decode... -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu signature.asc Description: OpenPGP digital signature

Re: unorthodox use of PG for a customer

On 8/27/2018 8:20 AM, John McKown wrote: On Fri, Aug 24, 2018 at 1:19 PM David Gauthier > wrote: I can't think of anything better.  Does anyone have any ideas? Yes, but the civil authorities would prosecute you if they found the body. And that's why we ha

Re: unorthodox use of PG for a customer

another question. -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu signature.asc Description: OpenPGP digital signature

Re: unorthodox use of PG for a customer

ds "a server" on the workstation to accept incoming connections and all that overhead, with enough oomph to handle concurrency he expects. Or it's a beefed-up central server where everybody writes to, and every workstation can poll it and maintain its own state databases from there (i.e.

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

s. It's just not a "computer login" shared account. That said, there is nothing scary about shared computer accounts either. It's the users that are the scary part. -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu signature.asc Description: OpenPGP digital signature

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

//www.postgresql.org/docs/10/static/auth-methods.html#AUTH-LDAP You should be able to get the role name from AD already, but the password they still have to remember. Although I still don't see this really working for anything more complicated than one database and no user in more than one g

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

user the name and password of that role to connect as? -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu signature.asc Description: OpenPGP digital signature

Re: pg_basebackup failed to read a file

uld care to wait... so it can be just as expensive. One could just as easily ask why create mode 600 files in places where they don't belong. -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu signature.asc Description: OpenPGP digital signature

Re: Who and How is responsible for released installations packages and 3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/)

opying plv8.so out of the resulting image is the easy way out. -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu signature.asc Description: OpenPGP digital signature

Re: Who and How is responsible for released installations packages and 3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/)

ostgres built by them and included in the distribution -- in RHEL7 it's v.9.2 but RedHat is known to patch code without changing version numbers. -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu signature.asc Description: OpenPGP digital signature

Re: Question on postgresql.conf

location that works best is the chef master. -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu signature.asc Description: OpenPGP digital signature

Re: Question on postgresql.conf

On 07/31/2018 01:05 PM, Steve Atkins wrote: > You'd do that with "include_dir 'conf.d'" or similar, I think, which > PostgreSQL > has in all current versions. So it does, huh. I guess it helps to read all the way to end of postgresql.conf sometimes... --

Re: Question on postgresql.conf

/etc/blah.d/myhost.conf, all living together happily ever after. You still want the latter to be a local file that's guaranteed available when blah service starts up. (Postgres devs: hint! hint!) -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu

Re: Question on postgresql.conf

On 7/31/2018 9:36 AM, Matt Zagrabelny wrote: Or have puppet/chef/ansible/etc. write the correct config file based on your dynamic data. Postgres ain't orrible. I wonder if one actually needs as much host-specific config tuning in the first place... I haven't touched oracle in forever, thoug

Re: logical replication snapshots

On 07/27/2018 05:20 PM, Adrian Klaver wrote: > On 07/27/2018 03:04 PM, Dimitri Maziuk wrote: >> ... but if I did the publication for ALL, I could just use streaming >> replication ... > > Well I was just showing the extremes from a single table publication to > ALL

Re: logical replication snapshots

On 07/26/2018 07:11 PM, Adrian Klaver wrote: > On 07/26/2018 04:48 PM, Dimitri Maziuk wrote: ... >> The publication foopub is at this point fubar I take it? And needs to be >> re-created on the publisher and reconnected on the subscriber? Complete >> with with inital

Re: logical replication snapshots

On 07/26/2018 05:34 PM, Adrian Klaver wrote: > On 07/26/2018 03:01 PM, Dimitri Maziuk wrote: >> Let me ask a different question: if I drop and re-create a published >> table on the publisher without doing anything to the publication and >> subscription, what happens

Re: logical replication snapshots

ask a different question: if I drop and re-create a published table on the publisher without doing anything to the publication and subscription, what happens? Do I need to re-create the publication when I re-create the table? -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW-Madison -- http://ww

Re: logical replication snapshots

On 07/26/2018 02:54 PM, Adrian Klaver wrote: > On 07/26/2018 10:54 AM, Dimitri Maziuk wrote: >> I'm not sure what happened, I remember the initial sync of that >> particular schema failing on one table only, but looking at it now, all >> tables are empty on the s

Re: logical replication snapshots

d need to fill whether that >> might account for the 13 million files in the ~snapshot/ directory. > > That indicates there's some error handling issues to be resolved. Petr? It logs "COPY TO STDOUT", does that actually cache to disk (in ~snapshot/)? Would it be sa

Re: logical replication snapshots

database rebuilt with no publications defined, and I have the original $PGDATA on a ZFS volume. I have not looked at the subscriber host yet, I've more urgent fires to douse first. -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu signature.asc Description: OpenPGP digital signature

Re: logical replication snapshots

AL: the database system is starting up ... ad infinitum ... Would "permission denied" be relevant? (Not sure where that is coming from: I did initial sync as postgres then altered it to replication user. Can't track it down now since the database is dead.) -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu signature.asc Description: OpenPGP digital signature

Re: logical replication snapshots

On 7/25/2018 10:28 AM, Andres Freund wrote: Are you really expecting us to be able to reproduce the problem based on the above description? Our test suites do setup plain replications setups, and the problem doesn't occur there. I don't, by definition, have a reproducible case: it only happene

Re: logical replication snapshots

On 07/24/2018 01:43 PM, Andres Freund wrote: > On 2018-07-24 12:22:24 -0500, Dimitri Maziuk wrote: >> On 07/24/2018 12:21 PM, Alvaro Herrera wrote: >>> >>> Are you serious about us trying to diagnose a bug with this description? >> >> What do you want to k

Re: logical replication snapshots

On 07/24/2018 12:21 PM, Alvaro Herrera wrote: > > Are you serious about us trying to diagnose a bug with this description? What do you want to know, exactly? -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu signature.asc Description: O

Re: logical replication snapshots

On 7/23/2018 6:51 PM, Andres Freund wrote: What precedes that "loop"? systemctl start postgresql-10 Could you describe what exactly you did into that situation? Created a database, few publications, as per TFM, and a few subscriptions on another host. Went on vacation for 3 weeks. The pro

logical replication snapshots

ar/lib/pgsql/10/data/pg_logical/snapshots -printf . | wc -c 12727975 It looks like ZFS simply can't handle this many files: `ls` etc. hang forever. So my question is, does it have to be that many? And if not, is there a knob to keep the number down? TIA -- Dimitri Maziuk Program