Re: pg data backup from vps

On 12/01/2017 11:56 AM, support-tiger wrote: To diversify risk, we would like to have a daily or weekly data backup stored in another location besides the VPS service we are using - pg_dump is great for the backup but transferring a growing db across the internet to a local machine disk seems

Re: Migration to PGLister - After

On 11/20/2017 09:32 AM, John R Pierce wrote: On 11/20/2017 6:45 AM, Stephen Frost wrote: The changes which we expect to be most significant to users can be found on the wiki here:https://wiki.postgresql.org/wiki/PGLister_Announce  the current version of which is also included below. A peeve

Re: Procmail recipe for new setup

On 11/20/2017 02:10 PM, Steve Litt wrote: Hi all, The following procmail recipe works for me: === :0: * ^(To|Cc).*pgsql-gene...@postgresql.org .Postgres/ === You may want to use TO ... See here:

Re: To all who wish to unsubscribe

On 11/20/2017 11:40 AM, Magnus Hagander wrote: https://wiki.postgresql.org/wiki/PGLister_Announce Those looking to unsubscribe should also read that page.  Sending "unsubscribe" messages to the list will not

Re: To all who wish to unsubscribe

On 11/20/2017 11:11 AM, Tom Lane wrote: Vick Khera writes: Did the list software change? All my messages from here are not being properly auto-files by the filter I have set up. Yes - did you not see either of the "migration to pglister" messages? There's a summary of the

Re: To all who wish to unsubscribe

On 11/20/2017 11:45 AM, Joshua D. Drake wrote: So do you have any suggestions for actually fixing that? Given that we have more lists to migrate, if you can figure out a way to make those changes without peoples filters not matching, we'd be happy to hear it.. I was thinking about that. I

Re: To all who wish to unsubscribe

On 11/20/2017 12:03 PM, Tom Lane wrote: Unfortunately, the removal of the footer is a feature not a bug. In order to be DKIM-compatible and thus help avoid becoming classified as spammers, we can't mangle message content anymore, just like we can't mangle the Subject: line. Ugh, o.k. In

Re: To all who wish to unsubscribe

On 11/20/2017 12:20 PM, Magnus Hagander wrote: On Mon, Nov 20, 2017 at 9:07 PM, Joshua D. Drake <j...@commandprompt.com <mailto:j...@commandprompt.com>> wrote: Not even remotely. People use gmail. See https://blog.hagander.net/mail-agents-in-the-postgresql-community-

Re: Warm standby can't start because logs stream too quickly from the master

On 12/02/2017 11:02 AM, Zach Walton wrote: Generally this works itself out if I wait (sometimes a really long time). Is there a configuration option that allows a warm standby to start without having fully replayed the logs from the master? * Note: wal_keep_segments is set to 8192 on these

Re: Renice on Postgresql process

On 05/23/2018 04:36 PM, Ben Chobot wrote: On May 7, 2018, at 11:50 PM, Ayappan P2 > wrote: We are doing "renice" on the main Postgresql process to give higher scheduling priority because other critical operations depends on the database.

Re: Service pgpool

On 06/07/2018 11:16 AM, Jean Claude wrote: Hi all, below my problem about daemon : Jun 07 14:06:45 vm02 systemd[1]: Failed to start SYSV: Starts and stops the pgpool daemon. Jun 07 14:06:45 vm02 systemd[1]: Unit pgpool-II-10.service entered failed state. Jun 07 14:06:45 vm02 systemd[1]:

Re: Code of Conduct plan

On 06/04/2018 01:46 PM, Tom Lane wrote: "Joshua D. Drake" writes: On 06/03/2018 11:29 AM, Tom Lane wrote: We are now asking for a final round of community comments. Actually, it's intentional that we are not saying that. The idea is that any interaction between PG communi

Re: Code of Conduct plan

On 06/05/2018 07:45 AM, Chris Travers wrote: It is my hope that PostgreSQL.Org -Core chooses members for that committee that are exceedingly diverse otherwise it is just an echo chamber for a single ideology and that will destroy this community. If I may suggest:  The committee

Re: Code of Conduct plan

On 06/05/2018 08:41 AM, Lutz Horn wrote: Am 05.06.2018 17:26 schrieb Joshua D. Drake: As one of the people that interacts with external members of the community more than most, I can tell you that a CoC is something the wider community wants. I have sat in feedback meetings with hundreds

Re: Code of Conduct plan

On 06/05/2018 08:19 AM, Lutz Horn wrote: Am 05.06.2018 17:03 schrieb Chris Travers: On to the code of conduct committee: This needs to be explicitly international and ideally people from very different cultures.  This is the best protection against one small group within one country deciding

Re: Code of Conduct plan

On 06/04/2018 09:55 PM, Tom Lane wrote: Adrian Klaver writes: On 06/03/2018 11:29 AM, Tom Lane wrote: https://wiki.postgresql.org/wiki/Code_of_Conduct We are now asking for a final round of community comments. My comments: 1) Reiterate my contention that this is a solution is search of

Re: Code of Conduct plan

On 06/05/2018 10:26 AM, Chris Travers wrote: Let's role play. I'll be a homophobic person. You've just submitted a proposal suggesting that we change master-master replication to be multi-partner replication. I've told you I don't like the wording because of it's implication of

Re: Code of Conduct plan

On 06/05/2018 09:32 AM, Tom Lane wrote: James Keener writes: I don't participate too much here, but I've never see a group implement a code of conduct go well. Yeah, personally I'm a bit worried about this too. The proposed CoC does contain provisions to try to prevent misusing it, but

Re: Code of Conduct plan

On 06/05/2018 10:44 AM, James Keener wrote: Your example is flawed because: Multi-Partner has nothing to do with sexuality unless you want to make the argument that your belief is that a relationship should be between one person and another and in this argument a man and a

Re: Code of Conduct plan

On 06/05/2018 12:12 PM, Christophe Pettus wrote: On Jun 5, 2018, at 12:06, Benjamin Scherrey wrote: Doesn't that 20 years of results pretty clearly demonstrate that this community does not gain an advantage for adopting a CoC? Not at all. The need for a CoC is not theoretical. Real

Re: Code of Conduct plan

On 06/05/2018 04:41 PM, Tom Lane wrote: Benjamin Scherrey writes: On Wed, Jun 6, 2018 at 2:12 AM, Christophe Pettus wrote: Not at all. The need for a CoC is not theoretical. Real people, recently, have left the community due to harassment, and there was no system within the community to

Re: Code of Conduct plan

On 06/05/2018 08:55 PM, Tom Lane wrote: Adrian Klaver writes: On 06/05/2018 04:41 PM, Tom Lane wrote: I'm getting a little tired of people raising hypothetical harms and ignoring the real harms that we're hoping to fix. Yes, this is an experiment and it may not work, but we can't find out

Re: Code of Conduct plan

On 06/06/2018 11:22 AM, Tom Lane wrote: I wrote: Yeah, somebody else made a similar point upthread. I guess we felt that the proper procedure was obvious given the structure, but maybe not. I could support adding text to clarify this, perhaps along the line of Hmm ... actually, there's

Re: Code of Conduct plan

On 06/03/2018 11:29 AM, Tom Lane wrote: https://wiki.postgresql.org/wiki/Code_of_Conduct We are now asking for a final round of community comments. Please send any public comments to the pgsql-general list (only). If you wish to make a private comment, you may send it to c...@postgresql.org.

Re: Code of Conduct plan

On 06/03/2018 04:08 PM, Gavin Flower wrote: My comments: 1) Reiterate my contention that this is a solution is search of problem. Still it looks like it is going forward, so see below. 2) "... engaging in behavior that may bring the PostgreSQL project into disrepute, ..." This to me is

Re: Code of Conduct plan

On 06/04/2018 09:44 AM, Ron wrote: If there's been so much Bad Behavior that's so Weakened the Community, then someone's done an excellent job of hiding that Bad Behavior. The inner circle of any community is very good at protecting itself and exerting authority without representation or

Re: Code of Conduct plan

On 06/04/2018 06:33 AM, Benjamin Scherrey wrote:     I did go back and read through the 2016 content rather thoroughly. But where has all the discussion been going on for the last two years? Am I to understand that this effort has been going on in an entirely undocumented manner? I find

Re: Code of Conduct plan

On 06/03/2018 05:57 PM, Jonathan S. Katz wrote: Anyway, a big +1 to the effort of everyone who worked on the CoC for the past several years. From feedback in other forums through the years, I know it does make a difference to have a code of conduct in terms of helping people to feel more

Re: data-checksums

On 01/09/2018 12:22 PM, Andres Freund wrote: On 2018-01-09 20:04:04 +0100, Rakesh Kumar wrote: I also would like to believe that the hit is small, but when PG official document writes "noticeable performance penalty", it becomes difficult to convince management that the hit is small :-) Why

Re: Does postgresq database supports reading data from the same table from many observable simultanousely?

On 12/22/2017 11:20 AM, hmidi slim wrote: But is it possible to make simultanoues select queries from the same connection? Yes but it will happen serially. JD -- Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc PostgreSQL centered full stack support, consulting and

Re: Error creating a table

On 01/02/2018 02:38 PM, Dale Seaburg wrote: le): NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "public_rowkey" for table "ABSTRACT-SERVER_runsheet" ERROR:  relation "public_rowkey" already exists ** Error ** ERROR: relation "public_rowkey" already exists SQL

Re: Call for Papers - PGConf.ASIA 2018

On 07/29/2018 05:59 PM, Tatsuo Ishii wrote: Hi PostgreSQL lovers, The call for papers for PGConf.ASIA 2018 will be closed on 31st July, 2018 (Japan time), that is 15:00 31st July 2018 UTC. I am looking forward to receiving your great proposals and seeing you in Akihabara (yes, like last year,

Re: using graph model with PostgreSQL

On 08/15/2018 07:09 AM, 김세훈 wrote: Hi there, currently I'm using PostgreSQL with PostGIS extension to handle geospatial data. In my project I need to apply some graph algorithms like MST for some network of GPS coordinates. I know there is some way of using Neo4j with PostgreSQL but is

Re: moving data to from ms sql server via SSIS

On 08/15/2018 11:03 AM, cosmin ioan wrote: hi folks, we're trying to phase out MS SQL Server and we're trying to understand the easiest way to move data from MS SQL Server to postgres, via SSIS, say via ODBC, OleDB or .Net drivers, and basically create new tables & move data, into the target

Re: pg_basebackup failed to read a file

On 08/14/2018 09:14 AM, Tom Lane wrote: Mike Cardwell writes: It'd be nice to have a more coherent theory about what needs to be copied or not, and not fail on files that could simply be ignored. Up to now we've resisted having any centrally defined knowledge of what can be inside a PG data

Re: Difference between "autovacuum_naptime" and "autovacuum_vacuum_cost_delay"?

On 08/16/2018 06:10 PM, Raghavendra Rao J S V wrote: Hi All, I have gone through several documents but I am still have confusion related to "autovacuum_naptime" and "autovacuum_vacuum_cost_delay". Could you clarify me with an example. When Auto vacuum worker process will start?

Re: vPgSql

On 08/17/2018 05:45 AM, Dmitry Igrishin wrote: Hey Vlad пт, 17 авг. 2018 г. в 15:31, Vlad Alexeenkov : Maybe will be useful for someone Very simple Postgres SQL client vPgSql: https://vsdev.ru Looking nice! Thank you. But I unable to start it on Ubuntu, because there is no bash(1) in

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

On 08/22/2018 08:56 AM, David Gauthier wrote: Hi: The title says it all.  I need to be control who can gain access to a DB based on a linux user group.  I can set up a generic role and password, but also want to prevent users who are not in a specific linux group from accessing the DB.  For

Re: User documentation vs Official Docs

On 07/20/2018 10:38 AM, George Neuner wrote: As libraries allow users/citizens to request books be purchased at no cost to the user/citizen, the argument that someone cannot afford a book is now a moot point. This thread is getting off topic. The tl;dr; of this particular subthread is that

Re: User documentation vs Official Docs

On 07/20/2018 03:59 PM, Alvaro Herrera wrote: I don't see why we need this thread to continue. This sounds like somebody looking for a solution when they don't yet know what the problem is. Unfortunately, you don't understand the problem which is why this thread is happening on -general and

Re: User documentation vs Official Docs

On 07/20/2018 04:56 PM, Stephen Frost wrote: +1. I'd personally like to see improvements to the tutorials, and patches could certainly be submitted or specific ideas discussed over on -docs. A few ideas around that would be: - Setting up async replication - Setting up sync replication, with

Re: User documentation vs Official Docs

On 07/20/2018 05:31 PM, Adrian Klaver wrote: On 07/20/2018 04:48 PM, Joshua D. Drake wrote: On 07/20/2018 03:59 PM, Alvaro Herrera wrote: I don't see why we need this thread to continue.  This sounds like somebody looking for a solution when they don't yet know what the problem

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

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

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", 

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

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: 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 <mailto:j...@commandprompt.com>> 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 t

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

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 <mailto:j...@commandprompt.com>>wrote: On 07/16/2018 03:14 PM, David G. Johnston wrote: What does the community think about a community run, community organized, su

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

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

Re: How can i install contrib modules in pg11 via source

On 07/24/2018 12:08 PM, Adrian Klaver wrote: On 07/24/2018 12:00 PM, Márcio Antônio Sepp wrote: Hi all, How can i install contrib modules in pg11. I’m using FreeBSD 11.2. In specific i need to install hstore for test purpose. To confirm you are building from source correct? If so I can

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

Re: Barman versus pgBackRest

On 09/04/2018 07:52 AM, Ron wrote: On 09/04/2018 09:24 AM, Joshua D. Drake wrote: On 09/04/2018 07:14 AM, Ron wrote: That was about barman, in the barman group.  This is asking about pgbackrest...  :) So: does pgbackrest have this ability which barman does not have? The "--db-in

Re: Barman versus pgBackRest

On 09/04/2018 08:55 AM, Ron wrote: On 09/04/2018 10:51 AM, David Steele wrote: [snip] This will work, but I don't think it's what Ron is getting at. To be clear, it is not possible to restore a database into an *existing* cluster using pgBackRest selective restore.  This is a limitation of

Re: Barman versus pgBackRest

On 09/04/2018 07:14 AM, Ron wrote: That was about barman, in the barman group.  This is asking about pgbackrest...  :) So: does pgbackrest have this ability which barman does not have? The "--db-include" option seems to indicate that you can restore a single db, but does indicate whether

Re: increasing HA

On 09/04/2018 07:58 AM, Thomas Poty wrote: - using an automatick failover  I found PAF  Could you advice any others solutions to explore or share your experience? LinuxHA or Patroni are the most common we run into. JD-- Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc

Any community members in Phoenix, AZ?

Folks, We have a Postgres meetup we have been trying to get off the ground in Phoenix: https://www.meetup.com/Phoenix-Postgres/ We could use some help with facilities and speakers. Do we have any locals down there on this list? It would be great to get a team together to help with this

Re: FDW with DB2

On 04/06/2018 01:01 PM, Ravi Krishna wrote: Has anyone used PG with DB2(Linux) ? Looks like the way you go about it is with the ODBC FDW. JD -- Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc *** A fault and talent of mine is to tell it exactly how it is. ***

Re: Postgresql 9.3 Server will not start after Ubuntu Upgrade

On 03/27/2018 11:00 AM, Ken Beck wrote: And, looking for log files, I find none. Nothing in /var/log/postgresql or /var/lib/postgresql/9.3/main/pg_log? JD -- Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc *** A fault and talent of mine is to tell it exactly how it is.

Re: PostgreSQL version on VMware vSphere ESXI 6.5 and harware version 13

On 03/26/2018 07:03 AM, nmmulla wrote: We are upgrading Vmware to version 6.5. Operating system for virtual servers will not be changing. The other change that will be happening is VM hardware version which will be upgraded from current version ( 9 or 10) to version 13. Your compatibility is

Congrats to PostgreSQL sponsor OpenSCG

Community, Major PostgreSQL Sponsor OpenSCG has just been acquired by PostgreSQL sponsor AWS. Congrats to both companies! JD -- Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc *** A fault and talent of mine is to tell it exactly how it is. *** PostgreSQL centered

Re: system catalog permissions

On 02/26/2018 03:11 PM, PropAAS DBA wrote: All; We have a client which is segmenting their multi-tenant cluster (PostgreSQL 9.6) by schema, however if one of their clients connects via pgadmin they see ALL schemas, even the ones they don't have access to read. I assume pgadmin is pulling

Re: Is pg_restore in 10.6 working?

On 11/12/18 10:37 AM, David wrote: I can connect with psql either of these two ways: psql -U postgres or psql -h ip-172-31-62-127.ec2.internal -p 5432 -U postgres -W postgres (Yes, it's an AWS server) This pg_dump command works: pg_dump -U postgres -f predata.sql -F p -v  -d prod_data But a

Re: Alter table column constraint

On 12/17/18 12:01 PM, Rich Shepard wrote: On Mon, 17 Dec 2018, Rich Shepard wrote: I want to alter a term in a column's constraint to allow only specified strings as attributes and have not found how to do this in the docs (using version 10 docs now). There is an alter table command that

Re: simple division

On 12/4/18 12:29 PM, Martin Mueller wrote: I have asked this question before and apologize for not remembering it. How do you do simple division in postgres and get 10/4 with decimals? This involves cast and numeric in odd ways that are not well explained in the documentation. For instance,

Re: Code of Conduct plan

On 09/14/2018 06:59 AM, Robert Eckhardt wrote: I really have to object to this addition: "This Code is meant to cover all interaction between community members, whether or not it takes place within postgresql.org infrastructure, so long as there is not another Code of

Re: Code of Conduct plan

On 09/14/2018 07:51 AM, Dave Page wrote: If that business is publicly bringing the project into disrepute, or harassing other community members and they approach us about it, then it becomes our business. If it's unrelated to PostgreSQL, then it's your personal business and not

Re: Code of Conduct plan

On 09/14/2018 07:14 AM, Dave Page wrote: On Fri, Sep 14, 2018 at 3:08 PM, Joshua D. Drake <mailto:j...@commandprompt.com>> wrote: On 09/14/2018 01:31 AM, Chris Travers wrote: I apologize for the glacial slowness with which this has all been moving. The

Re: Code of Conduct plan

On 09/14/2018 01:31 AM, Chris Travers wrote: I apologize for the glacial slowness with which this has all been moving. The core team has now agreed to some revisions to the draft CoC based on the comments in this thread; see

Re: Code of Conduct plan

On 09/14/2018 07:36 AM, Dave Page wrote: On Fri, Sep 14, 2018 at 3:21 PM, James Keener > wrote: Now, you may say that (2) would be rejected by the committee, but I would counter that it's still a stain on me and something that

Re: Code of Conduct plan

On 09/14/2018 07:41 AM, James Keener wrote: > Community is people who joined it We're not a "community." I do not think you are going to get very many people on board with that argument. As anyone who knows me will attest I am one of the most contrarian members of this community but I still

Re: Code of Conduct plan

On 09/17/2018 08:11 AM, Dmitri Maziuk wrote: On Sun, 16 Sep 2018 12:52:34 + Martin Mueller wrote: ... The overreach is dubious on both practical and theoretical grounds. "Stick to your knitting " or the KISS principle seem good advice in this context. Moderated mailing lists ain't been

Re: Slow shutdowns sometimes on RDS Postgres

On 09/13/2018 03:04 PM, Chris Williams wrote: Hi, I'm using AWS RDS Postgres (9.6.6) and have run into very slow shutdowns (10+ minutes) a few times when making database modifications (e.g. reboot, changing instance size, etc.).  Other times, it shuts down quickly (1 minute or so).  I have