Tradebot with PostgreSQL
#1
Hey SQLite was not working for me, the bot crashes everytime I try to use it with tradebot...works great with everything else ...getting child errors etc...So I want to try postgresql but I’m not familiar with it...I downloaded the newest postgresql and have the server running...edited the uiconfig and base config but still not luck...this is on windows 10 running gekko in UI mode..any ideas?  From what I’ve read SQLite is too weak to handle tradebot so therefore I wanna try postgresql

Code:
c:\Users\Plat\Downloads\gekko-stable\gekko-stable>node gekko --ui

    ______   ________  __    __  __    __   ______
   /      \ /        |/  |  /  |/  |  /  | /      \
  /$$$$$$  |$$$$$$$$/ $$ | /$$/ $$ | /$$/ /$$$$$$  |
  $$ | _$$/ $$ |__    $$ |/$$/  $$ |/$$/  $$ |  $$ |
  $$ |/    |$$    |   $$  $$<   $$  $$<   $$ |  $$ |
  $$ |$$$$ |$$$$$/    $$$$$  \  $$$$$  \  $$ |  $$ |
  $$ \__$$ |$$ |_____ $$ |$$  \ $$ |$$  \ $$ \__$$ |
  $$    $$/ $$       |$$ | $$  |$$ | $$  |$$    $$/
   $$$$$$/  $$$$$$$$/ $$/   $$/ $$/   $$/  $$$$$$/

        Gekko v0.5.11
        I'm gonna make you rich, Bud Fox.


Serving Gekko UI on http://localhost:3000/

  <-- GET /api/imports
  --> GET /api/imports 200 17ms 2b
  <-- GET /api/gekkos
  --> GET /api/gekkos 200 4ms 2b
  <-- GET /api/gekkos
  --> GET /api/gekkos 200 4ms 2b
  <-- GET /api/apiKeys
  --> GET /api/apiKeys 200 3ms 10b
  <-- GET /api/exchanges
  --> GET /api/exchanges 200 8,848ms 64.46kb
  <-- POST /api/import
Import 696685438790157 started
  --> POST /api/import 200 794ms 150b
RECEIVED ERROR IN IMPORT 696685438790157


Gekko encountered an error and can't continue


Gekko encountered an error and can't continue

Error:

{ name: 'error',
  length: 102,
  severity: 'FATAL',
  code: '3D000',
  file: 'postinit.c',
  line: '846',
  routine: 'InitPostgres' }

Meta debug info:

Gekko version: v0.5.11
Nodejs version: v8.9.3

^C
c:\Users\Plat\Downloads\gekko-stable\gekko-stable>
  Reply
#2
hi Plat
Try stop Gekko
-ctrl.+C
-cd gekko

try this:
npm install sqlite3  //now it should install...
  Reply
#3
(01-28-2018, 03:09 PM)susitronix Wrote: hi Plat
Try stop Gekko
-ctrl.+C
-cd gekko

try this:
npm install sqlite3  //now it should install...

SQLITE works thats not the issue...it just doesn't work with Tradebot when I go live.  ... seems like it cannot handle it...which is why i want to try Postgresql...

[Image: lnQ0rjy.png]
  Reply
#4
(01-28-2018, 09:52 PM)Plat Wrote:
(01-28-2018, 03:09 PM)susitronix Wrote: hi Plat
Try stop Gekko
-ctrl.+C
-cd gekko

try this:
npm install sqlite3  //now it should install...

SQLITE works thats not the issue...it just doesn't work with Tradebot when I go live.  ... seems like it cannot handle it...which is why i want to try Postgresql...

[Image: lnQ0rjy.png]

Hi!

I have the same issue and was able to setup the use of Postgres but the created database does not contain any table. Have you experienced the same issue? 

Anyways, were you able to properly use Postgres with gekko? If so, could you share details on your setup?

Cheers, blizzfire101
  Reply
#5
(05-07-2018, 12:42 PM)blizzfire101 Wrote:
(01-28-2018, 09:52 PM)Plat Wrote:
(01-28-2018, 03:09 PM)susitronix Wrote: hi Plat
Try stop Gekko
-ctrl.+C
-cd gekko

try this:
npm install sqlite3  //now it should install...

SQLITE works thats not the issue...it just doesn't work with Tradebot when I go live.  ... seems like it cannot handle it...which is why i want to try Postgresql...

[Image: lnQ0rjy.png]

Hi!

I have the same issue and was able to setup the use of Postgres but the created database does not contain any table. Have you experienced the same issue? 

Anyways, were you able to properly use Postgres with gekko? If so, could you share details on your setup?

Cheers, blizzfire101

Does anyone have this working on postgresql?
  Reply
#6
To get around that error (windows 7) I had to open up the task manager (cntl-alt-del) and close all currently running sqlite tasks/services then restart Gekko.
If you then run a live bot and also try to import data for backtesting etc it might hang up again.

Sorry this doesn't help with Postgresql but should hopefully fix the sqlite bug
  Reply


Forum Jump:


Users browsing this thread: