From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from mail-lf1-f45.google.com (mail-lf1-f45.google.com [209.85.167.45]) by mx.groups.io with SMTP id smtpd.web09.32690.1623049215957675652 for ; Mon, 07 Jun 2021 00:00:19 -0700 Authentication-Results: mx.groups.io; dkim=pass header.i=@neopsis.com header.s=google header.b=K0Ixo9Rq; spf=pass (domain: neopsis.com, ip: 209.85.167.45, mailfrom: robert@neopsis.com) Received: by mail-lf1-f45.google.com with SMTP id n12so17500989lft.10 for ; Mon, 07 Jun 2021 00:00:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=neopsis.com; s=google; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=kSBa4ycCD9Z/6+MUwUWsRraa8keFgzrfy0dIJfvp8UQ=; b=K0Ixo9RqCYH804mGXfgCk/zvM0dvineZLHRThIXz09cl+vPnBzntXwU5OFTdIiqVEP DukK+V549GNocsDTYup8JGjubLUPbnUOHS0ZrgaVARL2xBtymwAThOVoJd63JLZTCHKU nzRusu8RNRWZsE4ZbxaTZEHgkN+Ds3+zfQlF0= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=kSBa4ycCD9Z/6+MUwUWsRraa8keFgzrfy0dIJfvp8UQ=; b=NH16fju0cxnlRuN1kTAPsHIBT6I+OO3Kfx/k9uvXNW9ep+rAjftKJlEUpBiL1pYg47 6O6UyC4lazn+SKk5DqdryBq87xjtwih5Co2llaD/J5jU6dGifGBV3MkzsHZghNtNO0nP 6bEksy5tCCZaoZZGtda5FK+O+4y2I468l7f2XmmrcNBnz9QBNs/dUxBk+KjNFsk+/AsQ qZOtvnz4uIqtoUwAJ8ljXPV4riWsPZJ1xCSm6rEo5fonXsynJvAfd+XksBRGtFovwTOU uIvCQpQ0KEdjrqBRT3OaZCbPaARrDrlCTh95QeKLfCvhaTqhelbn3Nnh3QAh9h3py8mb CRYw== X-Gm-Message-State: AOAM531OiY7g6EP6XuanXeJdJd88cucDNu1ZHPVb6xdPy49XheTVh68G Rh6p+BdL9BfoDhwNcttkxd5Qmkk5d52JMvvAc/zrGw== X-Google-Smtp-Source: ABdhPJxb9B8xaKij/u0j33kZ1Kr25BEOc1gX27fcMOGsYjCEWiQRbIbMdKINI0v8UG7KobylNepAJuRosdEzF5jBvGk= X-Received: by 2002:ac2:5182:: with SMTP id u2mr11082853lfi.134.1623049212370; Mon, 07 Jun 2021 00:00:12 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: "Robert Carnecky" Date: Mon, 7 Jun 2021 09:00:01 +0200 Message-ID: Subject: Re: [Toaster] Toaster and Posgres database To: "Reyna, David" Cc: "toaster@lists.yoctoproject.org" Content-Type: text/plain; charset="UTF-8" David, Unfortunately, I have no full error stack. I analyzed the problem a bit more and found out that Django requires Postgres minimum version 9.6. My version was 9.3. I don't know if the bad statement is generated or written manually. In the former case, there would be a good chance that the problem is a bad database version. Unfortunately, I can't currently update Postgres on the server I wanted to install Toaster on, because that would cause complications for other programs running on that server. I will try to install Toaster on a brand new virtual server with a newer version of the Postgres database, but it will take some time. Robert Robert Carnecky Neopsis GmbH Sustenweg 9 CH-6020 Emmenbruecke Switzerland Tel. (+)41-41-262 0230 Fax (+)41-41-262 0231 Mobile (+)41-79-457 9776 Mail robert@neopsis.com On Thu, Jun 3, 2021 at 7:04 AM Reyna, David wrote: > > Hi Robert, > > I have not. > > Do you have the full error? We will probably need to update the schema for Toaster since Postgres is very rigid as per the model information. SQLite and MariaDB are much more relaxed by comparison. > > David > > -----Original Message----- > From: toaster@lists.yoctoproject.org On Behalf Of Robert Carnecky (Neopsis) > Sent: Wednesday, June 2, 2021 9:07 AM > To: toaster@lists.yoctoproject.org > Subject: [Toaster] Toaster and Posgres database > > Has anyone managed to successfully install Toaster on Postgres > database? My installation crashes on the migration step 'Applying > orm.0008_refactor_artifact_models' with syntax error 'FROM > unnest(c.conkey) WITH ORDINALITY co...'. > > Robert > > >