($INBOX_DIR/description missing)
 help / color / mirror / Atom feed
From: "Robert Carnecky" <robert@neopsis.com>
To: "Reyna, David" <david.reyna@windriver.com>
Cc: "toaster@lists.yoctoproject.org" <toaster@lists.yoctoproject.org>
Subject: Re: [Toaster] Toaster and Posgres database
Date: Mon, 7 Jun 2021 09:00:01 +0200	[thread overview]
Message-ID: <CABMENH6NjSZZJWNGNYGMjgf593q9-a_wjC3LiyQjbfGi3FPfXw@mail.gmail.com> (raw)
In-Reply-To: <BY5PR11MB41676B64C74EBF20AA3E32F6EA3C9@BY5PR11MB4167.namprd11.prod.outlook.com>

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 <david.reyna@windriver.com> 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 <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
>
> 
>

      reply	other threads:[~2021-06-07  7:00 UTC|newest]

Thread overview: 3+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2021-06-02 16:07 Toaster and Posgres database Robert Carnecky (Neopsis)
2021-06-03  5:04 ` [Toaster] " Reyna, David
2021-06-07  7:00   ` Robert Carnecky [this message]

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=CABMENH6NjSZZJWNGNYGMjgf593q9-a_wjC3LiyQjbfGi3FPfXw@mail.gmail.com \
    --to=robert@neopsis.com \
    --cc=david.reyna@windriver.com \
    --cc=toaster@lists.yoctoproject.org \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).