Re: WSL (windows subsystem on linux) users will need to turn fsync off as of 11.2

On Fri, Feb 15, 2019 at 5:29 PM Tom Lane wrote: > Thomas Munro writes: > >> On Fri, Feb 15, 2019 at 2:56 PM Bruce Klein wrote: > >>> In 11.1 did you see the message "WARNING: could not flush dirty data: > >>> Function not implemented" > >> Yes > > > Here is a place where people go to complain a

Re: WSL (windows subsystem on linux) users will need to turn fsync off as of 11.2

Thomas Munro writes: >> On Fri, Feb 15, 2019 at 2:56 PM Bruce Klein wrote: >>> In 11.1 did you see the message "WARNING: could not flush dirty data: >>> Function not implemented" >> Yes > Here is a place where people go to complain about that: > https://github.com/Microsoft/WSL/issues/645 > I s

Re: Shared hosting with FDW on AWS RDS

On Sun, Feb 10, 2019 at 03:19:48PM -0800, Paul Jungwirth wrote: > On 2/10/19 2:57 PM, auxsvr wrote: > >We'd like to configure an RDS server for shared hosting. The idea is that > >every customer will be using a different database and FDW will be > >configured, so that the remote tables have acces

Re: WSL (windows subsystem on linux) users will need to turn fsync off as of 11.2

On Fri, Feb 15, 2019 at 3:56 PM Thomas Munro wrote: > On Fri, Feb 15, 2019 at 2:56 PM Bruce Klein wrote: > > > In 11.1 did you see the message "WARNING: could not flush dirty data: > > > Function not implemented" > > Yes > > I wonder if this is coming from sync_file_range(), which is not > impl

Re: WSL (windows subsystem on linux) users will need to turn fsync off as of 11.2

On Fri, Feb 15, 2019 at 2:56 PM Bruce Klein wrote: > > In 11.1 did you see the message "WARNING: could not flush dirty data: > > Function not implemented" > Yes I wonder if this is coming from sync_file_range(), which is not implemented on WSL according to random intergoogling, but probably app

Re: WSL (windows subsystem on linux) users will need to turn fsync off as of 11.2

> In 11.1 did you see the message "WARNING: could not flush dirty data: Function not implemented" Yes re: the discussions of O/S and filesystem in that thread: I am not qualified to describe the implementation of WSL but I believe it is neither pure Ubuntu running on metal, nor a virtual machine

Re: WSL (windows subsystem on linux) users will need to turn fsync off as of 11.2

Thanks Tom I feel like I'm in a little over my head here but I'll try to help as I can. With fsync off, everything appears to run as it did before on 11.1. With fsync default/on, the problem is easily reproducible by trying to create a database. I believe the very first time I saw it it was with

Re: WSL (windows subsystem on linux) users will need to turn fsync off as of 11.2

Bruce Klein writes: > If you are running Postgres inside Microsoft WSL (at least on Ubuntu, maybe > on others too), and just picked up a software update to version 11.2, you > will need to go into your /etc/postgresql.conf file and set fsync=off. Hm. Probably this is some unexpected problem with

Re: loading plpython error

> On 2/14/19 4:17 PM, Alan Nilsson wrote: > > Platform: Linux x86-64, CentOS 6, Postgres 11.1. > > > > We have installed from the YUM repo. The server runs fine but we > > are > > trying to add python support. > > > > yum install postrgesql11-contrib postgresql11-plpython > > > > I can see th

Re: loading plpython error

Alan Nilsson writes: > Platform: Linux x86-64, CentOS 6, Postgres 11.1. > We have installed from the YUM repo. The server runs fine but we are trying > to add python support. > yum install postrgesql11-contrib postgresql11-plpython > I can see the installed files in the correct locations but

Re: loading plpython error

On 2/14/19 4:34 PM, Adrian Klaver wrote: On 2/14/19 4:17 PM, Alan Nilsson wrote: Platform:  Linux x86-64, CentOS 6, Postgres 11.1. We have installed from the YUM repo.  The server runs fine but we are trying to add python support. yum install postrgesql11-contrib postgresql11-plpython I can

Re: loading plpython error

On 2/14/19 4:17 PM, Alan Nilsson wrote: Platform:  Linux x86-64, CentOS 6, Postgres 11.1. We have installed from the YUM repo.  The server runs fine but we are trying to add python support. yum install postrgesql11-contrib postgresql11-plpython I can see the installed files in the correct lo

WSL (windows subsystem on linux) users will need to turn fsync off as of 11.2

Just in case this helps the next person who can't figure out why their postgres server won't start today: If you are running Postgres inside Microsoft WSL (at least on Ubuntu, maybe on others too), and just picked up a software update to version 11.2, you will need to go into your /etc/postgresql.

Re: loading plpython error

On 2/14/19 4:17 PM, Alan Nilsson wrote: Platform:  Linux x86-64, CentOS 6, Postgres 11.1. We have installed from the YUM repo.  The server runs fine but we are trying to add python support. yum install postrgesql11-contrib postgresql11-plpython I can see the installed files in the correct lo

loading plpython error

Platform: Linux x86-64, CentOS 6, Postgres 11.1. We have installed from the YUM repo. The server runs fine but we are trying to add python support. yum install postrgesql11-contrib postgresql11-plpython I can see the installed files in the correct locations but when we invoke create extensio

Correct setup for 3+ node cluster with streaming replication and WAL archiving

I'm having issues with replication on slave node after shutting down primary node and somehow successful promotion of another slave to master node. I have setup streaming replication with WAL archiving that works until failover is triggered when slave, after shutdown and repointing to new primary,

Re: Postgresql RDS DB Latency Chossing Hash join Plan

This is beyond my expertise except to say that if your storage is SSDs in AWS, then you definitely want random_page_cost close to the same as seq_page_cost (1 by default) assuming your data is likely to be in cache as discussed in the documentation

Re: Postgresql RDS DB Latency Chossing Hash join Plan

On Thu, Feb 14, 2019 at 12:43 PM Michael Lewis wrote: > How many total rows in these tables? I am assuming these are partitions > and those 100 million rows got distributed. If the data difference is > significant, then you aren't guaranteed similar performance. You may want > to follow more of t

Re: Postgresql RDS DB Latency Chossing Hash join Plan

How many total rows in these tables? I am assuming these are partitions and those 100 million rows got distributed. If the data difference is significant, then you aren't guaranteed similar performance. You may want to follow more of the suggested steps on. https://wiki.postgresql.org/wiki/SlowQue

Version 11.2 for SLES 12?

Hello, Do you happen to know when version 11.2 will be available for download via rpm option? https://www.postgresql.org/download/linux/suse/ [cid:image001.png@01D4C45C.FD0A6820] IMPORTANT: The information contained in this email and/or its attachments is con

Re: Postgresql RDS DB Latency Chossing Hash join Plan

On Wed, Feb 13, 2019 at 11:38 AM Michael Lewis wrote: > I didn't see your email yesterday, sorry about that. Index scans instead > of sequential scans and nested loop instead of hash join means that you > have bad row count estimates on "Non prod Aurora RDS instance" as far as I > can figure. Hav

Re: [External] logical replication

Hi Vijay, Can you please share the Link (or document) Regards Suganthi Sekar From: Vijaykumar Jain Sent: 14 February 2019 17:15:28 To: suganthi Sekar Cc: pgsql-general@lists.postgresql.org Subject: Re: [External] logical replication Yes we already do that,

Re: [External] logical replication

Sure, here it is. https://www.postgresql.org/docs/10/logical-replication-restrictions.html Regards, Vijay On Thu, Feb 14, 2019 at 5:36 PM suganthi Sekar wrote: > Hi Vijay, > > > Can you please share the Link (or document) > > > Regards > > Suganthi Sekar > -- > *Fr

Re: Streaming replication - invalid resource manager ID

Maeldron T. wrote: > I’m a bit stuck with a few LOG messages. The one in the subject disturbs me > the most. > > (FreeBSD 11.2, PostgreSQL 10.6) > > When I restart the hot standby, sometimes I see > > 2019-02-13 21:17:31 CET LOG: redo starts at 0/488A2748 > 2019-02-13 21:17:31 CET LOG: invali

RES: Problem linking to libpq.lib on Windows

Oof! Works now, thanks for the help! -Mensagem original- De: Dmitry Igrishin [mailto:dmit...@gmail.com] Enviada em: quinta-feira, 14 de fevereiro de 2019 08:59 Para: Roberto de Figueiredo Ribeiro Cc: pgsql-gene...@postgresql.org Assunto: Re: Problem linking to libpq.lib on Windows чт, 1

Re: [External] logical replication

Yes we already do that, provided you take care restrictions of logical replication as mentioned in the doc. On Thu, 14 Feb 2019 at 3:25 PM suganthi Sekar wrote: > > Hi Team , > > > Is it possible to do the logical replication in 2 way (Synchronization) > > > Example : > > > server1 : 5 tabl

Re: Problem linking to libpq.lib on Windows

чт, 14 февр. 2019 г. в 12:54, Roberto de Figueiredo Ribeiro : > > Hi list, > > > > I’m building a platform on C++ that uses parts of the libpq-fe.h in it. I had > been previously compiling it in linux, and all was fine. Switched to windows, > now during linking it accuses an error, unable to find

Problem linking to libpq.lib on Windows

Hi list, I'm building a platform on C++ that uses parts of the libpq-fe.h in it. I had been previously compiling it in linux, and all was fine. Switched to windows, now during linking it accuses an error, unable to find an object file. This is the line I'm compiling with: >: cl /I path\to\incl

logical replication

Hi Team , Is it possible to do the logical replication in 2 way (Synchronization) Example : server1 : 5 tables (1,2,3,4,5) Server 2 : 5 tables (1,2,3,4,5) 2,3 table data to be replicate from server 1 to server2 1,5 table data to be replicate from server 2 to server 1 Regards,

Re: Subquery to select max(date) value

I have not really followed this thread but would not a query along the lines of select * from activity where person_id = n and timestamp = (select max(timestamp) from activity where person_id = n); give the required answer ie, always return the latest result for the specified person_id?? Bren

SV: SV: SV: Implementing pgaudit extension on Microsoft Windows

Will do. -Oprindelig meddelelse- Fra: Joe Conway Sendt: 14. februar 2019 00:34 Til: Niels Jespersen ; 'Tom Lane' Cc: 'Pavel Stehule' ; pgsql-general@lists.postgresql.org Emne: Re: SV: SV: Implementing pgaudit extension on Microsoft Windows On 2/13/19 9:17 AM, Joe Conway wrote: > On 2

SV: SV: SV: Implementing pgaudit extension on Microsoft Windows

Hi Joe That is great. Log related settings are here: log_destination = 'stderr' logging_collector = on log_file_mode = 0640 log_timezone = 'Europe/Brussels' shared_preload_libraries = 'pgaudit' pgaudit.log = 'all' show shared_preload_libraries; and show pgaudit.log; confirms. Pgaudit i