Re: [GENERAL] Left join help

On Fri, Jun 23, 2017 at 3:17 PM, Arup Rakshit wrote: > Hi David, > > Can you tell me how can I add ordering between LEFT and INNER JOIN. I > think also that is where I am wrong, but not sure how to correct the > ordering. > ​Generally... FROM tbl1 LEFT JOIN (tbl2

Re: [GENERAL] Left join help

I tried a query, but it is not giving me any result. Can anyone help me pls? SELECT missions.*, CASE WHEN submissions.id IS NULL THEN 'incompleted' ELSE 'completed' END AS mission_status FROM "missions" LEFT JOIN submissions ON submissions.mission_id = missions.id INNER JOIN members

Re: [GENERAL] Left join help

Hi David, Can you tell me how can I add ordering between LEFT and INNER JOIN. I think also that is where I am wrong, but not sure how to correct the ordering. Thanks, A On Jun 24, 2017, at 3:18 AM, David G. Johnston > wrote: On

Re: [GENERAL] Left join help

On Friday, June 23, 2017, Arup Rakshit wrote: > > FROM "missions" LEFT JOIN submissions ON submissions.mission_id = > missions.id > INNER JOIN members ON members.id = submissions.member_id > Quick look here but having submissions as part of the inner join with

Re: [GENERAL] Chained slaves smaller?

Nevermind. Turns out it was on the wrong timeline and replication was broken. It was smaller because it was 77 days behind. (facepalm) > On Jun 23, 2017, at 2:40 PM, Jon Erdman wrote: > > Hi, > > I have SR set up in a couple of datacenters, where there’s a

[GENERAL] Left join help

Hi, I have this relationship Track has many missions. Missions has many submissions. Each Submission has one member and one mission. Say I have track id 7. I want to find out which missions under track 7 are submitted by John ( a user id say 3 ) and which are not yet. I tried a query, but it

Re: [GENERAL] Chained slaves smaller?

Jon Erdman writes: > Hi, > > I have SR set up in a couple of datacenters, where there’s a master in > DC_A with 2 slaves, and a 3rd slave off that master in DC_ B. Also, in > DC_B I have 2 slaves chained off the “local master”. Our main database > is ~551GB in DC_A

[GENERAL] Chained slaves smaller?

Hi, I have SR set up in a couple of datacenters, where there’s a master in DC_A with 2 slaves, and a 3rd slave off that master in DC_ B. Also, in DC_B I have 2 slaves chained off the “local master”. Our main database is ~551GB in DC_A and on the replica in B that is subscribed to the real

Re: [GENERAL] Download 9.6.3 Binaries

Hi, On 6/23/2017 11:47 AM, Joshua D. Drake wrote: Looks like EnterpriseDB is behind. You can try BigSQL: https://www.bigsql.org/postgresql/installers/ Thanks, but I prefer the archive version rather than the installer. Contrary to "rumors" on the internet, it is very easy to install Postgres

Re: [GENERAL] Download 9.6.3 Binaries

"Igal @ Lucee.org" writes: > Hello, > > I expected to find binaries for 9.6.3 at https://www.enterprisedb.com > /download-postgresql-binaries but I only see 9.6.2. > > Am I looking at the wrong place? I don't know but you should ask the fine people at EDB for best results. HTH

Re: [GENERAL] Download 9.6.3 Binaries

On 06/23/2017 11:04 AM, Igal @ Lucee.org wrote: Hello, I expected to find binaries for 9.6.3 at https://www.enterprisedb.com/download-postgresql-binaries but I only see 9.6.2. Am I looking at the wrong place? Yes and no. The tags are wrong, but the binaries. If you click on one of the

Re: [GENERAL] Download 9.6.3 Binaries

Am 23. Juni 2017 20:04:39 MESZ schrieb "Igal @ Lucee.org" : >Hello, > >I expected to find binaries for 9.6.3 at >https://www.enterprisedb.com/download-postgresql-binaries but I only >see >9.6.2. > >Am I looking at the wrong place? > >Thanks, > >Igal Sapir >Lucee Core Developer

Re: [GENERAL] Download 9.6.3 Binaries

On 06/23/2017 11:04 AM, Igal @ Lucee.org wrote: Hello, I expected to find binaries for 9.6.3 at https://www.enterprisedb.com/download-postgresql-binaries but I only see 9.6.2. Am I looking at the wrong place? Looks like EnterpriseDB is behind. You can try BigSQL:

[GENERAL] Download 9.6.3 Binaries

Hello, I expected to find binaries for 9.6.3 at https://www.enterprisedb.com/download-postgresql-binaries but I only see 9.6.2. Am I looking at the wrong place? Thanks, Igal Sapir Lucee Core Developer Lucee.org

Re: [GENERAL] Insertion of large xml files into PostgreSQL 10beta1

On Fri, Jun 23, 2017 at 8:19 AM, Alain Toussaint wrote: > Hello, > > I am building up a PostgreSQL server which I intend to load the > entirety of the pubmed database data (23GB bzip2 compressed, 216GB > unpacked) which is available in xml form of which, here is an

[GENERAL] Insertion of large xml files into PostgreSQL 10beta1

Hello, I am building up a PostgreSQL server which I intend to load the entirety of the pubmed database data (23GB bzip2 compressed, 216GB unpacked) which is available in xml form of which, here is an example: https://www.ncbi.nlm.nih.gov/pubmed/21833294?report=xml=text I looked at the

Re: [GENERAL] PostgreSQL Cookbook Testing

On 06/23/2017 05:27 AM, PAWAN SHARMA wrote: Hi All, Please help to configure kitchen.yml to test the PostgreSQL cookbook testing. #-> kitchen converge -> Starting Kitchen (v1.16.0) >> --Exception--- >> Class: Kitchen::UserError >> Message: Error parsing

Re: [GENERAL] Which process is actually doing the WAL writes/calls XLogFlush?

On 06/23/2017 05:50 AM, Daniel Westermann wrote: Hi all, as I did not find the answer in the documentation: Which background process is actually doing the writes/flushes to the WAL? In the docs (https://www.postgresql.org/docs/10/static/wal-configuration.html) it is explained which internal

Re: [GENERAL] PostgreSQL Cookbook Testing

On Fri, Jun 23, 2017 at 06:33:56PM +0530, PAWAN SHARMA wrote: > > On Fri, Jun 23, 2017 at 05:57:44PM +0530, PAWAN SHARMA wrote: > > > > > Please help to configure kitchen.yml to test the PostgreSQL cookbook > > > testing. > > > > > > #-> kitchen converge > > > -> Starting Kitchen (v1.16.0) >

Re: [GENERAL] PostgreSQL Cookbook Testing

On Fri, Jun 23, 2017 at 6:10 PM, Karsten Hilbert wrote: > On Fri, Jun 23, 2017 at 05:57:44PM +0530, PAWAN SHARMA wrote: > > > Please help to configure kitchen.yml to test the PostgreSQL cookbook > > testing. > > > > #-> kitchen converge > > -> Starting Kitchen

[GENERAL] Which process is actually doing the WAL writes/calls XLogFlush?

Hi all, as I did not find the answer in the documentation: Which background process is actually doing the writes/flushes to the WAL? In the docs (https://www.postgresql.org/docs/10/static/wal-configuration.html) it is explained which internal functions are responsible for this:

Re: [GENERAL] PostgreSQL Cookbook Testing

On Fri, Jun 23, 2017 at 05:57:44PM +0530, PAWAN SHARMA wrote: > Please help to configure kitchen.yml to test the PostgreSQL cookbook > testing. > > #-> kitchen converge > -> Starting Kitchen (v1.16.0) > >> --Exception--- > >> Class: Kitchen::UserError > >> Message: Error

[GENERAL] PostgreSQL Cookbook Testing

Hi All, Please help to configure kitchen.yml to test the PostgreSQL cookbook testing. #-> kitchen converge -> Starting Kitchen (v1.16.0) >> --Exception--- >> Class: Kitchen::UserError >> Message: Error parsing /tmp/postgresql-master/.kitchen.yml as YAML. Please run

Re: [GENERAL] Suddenly - LOG: could not open file "postmaster.pid": No such file or directory

Muhammad Hanif Abdul Hamid wrote: > Maybe an irrelevant question, but I would like to know if there anything > from postgres process (e.g any parameter that is not set right) that might > remove the postmaster.pid? If using Linux, you may put it under watch with # auditctl -w

Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100

Hi Everyone, Still trying to fathom this one. I have added quite a few log lines to a copy of 9.4.12 and compiled it hoping to find the fault. Below is from the log (at DEBUG5). Apologies for my name in the log lines, it was the easiest way to grep them specifically I also apologise that its a

Re: [GENERAL] pglogical vs. built-in logical replication in pg-10

On 22/06/2017 20:30, Andres Freund wrote: On 2017-06-22 18:10:40 +0300, Achilleas Mantzios wrote: Once again having pg_largeobject as a system-catalog prevents LOs from working smoothly. Neither replication nor having LOs on a different tablespace (by moving pg_largeobject) works. I think

Re: [GENERAL] Suddenly - LOG: could not open file "postmaster.pid": No such file or directory

Hi, Thanks for your reply, Tom and Michael. Maybe an irrelevant question, but I would like to know if there anything from postgres process (e.g any parameter that is not set right) that might remove the postmaster.pid? FYI, we have 20 other sites with the same database use but have not