toaster.lists.yoctoproject.org archive mirror
 help / color / mirror / Atom feed
* Toaster and Posgres database
@ 2021-06-02 16:07 Robert Carnecky (Neopsis)
  2021-06-03  5:04 ` [Toaster] " Reyna, David
  0 siblings, 1 reply; 3+ messages in thread
From: Robert Carnecky (Neopsis) @ 2021-06-02 16:07 UTC (permalink / raw)
  To: toaster

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

^ permalink raw reply	[flat|nested] 3+ messages in thread

* Re: [Toaster] Toaster and Posgres database
  2021-06-02 16:07 Toaster and Posgres database Robert Carnecky (Neopsis)
@ 2021-06-03  5:04 ` Reyna, David
  2021-06-07  7:00   ` Robert Carnecky
  0 siblings, 1 reply; 3+ messages in thread
From: Reyna, David @ 2021-06-03  5:04 UTC (permalink / raw)
  To: Robert Carnecky (Neopsis), toaster

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

^ permalink raw reply	[flat|nested] 3+ messages in thread

* Re: [Toaster] Toaster and Posgres database
  2021-06-03  5:04 ` [Toaster] " Reyna, David
@ 2021-06-07  7:00   ` Robert Carnecky
  0 siblings, 0 replies; 3+ messages in thread
From: Robert Carnecky @ 2021-06-07  7:00 UTC (permalink / raw)
  To: Reyna, David; +Cc: toaster

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

^ permalink raw reply	[flat|nested] 3+ messages in thread

end of thread, other threads:[~2021-06-07  7:00 UTC | newest]

Thread overview: 3+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
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 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 NNTP newsgroup(s).