IRC logs of #tryton for Thursday, 2017-06-08

chat.freenode.net #tryton log beginning Thu Jun 8 00:00:01 CEST 2017
-!- nicoe(~nicoe@2a02:a03f:30b2:3c00:ee55:f9ff:fe7b:f7ac) has joined #tryton00:11
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton01:39
-!- JosDzG(~Thunderbi@189.250.57.203) has joined #tryton02:23
-!- thaneor(~ldlc6@r167-56-50-49.dialup.adsl.anteldata.net.uy) has joined #tryton03:51
-!- zmijunkie1(~Adium@p5B15332B.dip0.t-ipconnect.de) has joined #tryton04:23
-!- zmijunkie(~Adium@p5B15332B.dip0.t-ipconnect.de) has joined #tryton05:40
-!- zmijunkie1(~Adium@p5B15332B.dip0.t-ipconnect.de) has joined #tryton05:43
-!- smarro(~sebastian@181.16.7.104) has joined #tryton05:53
-!- zmijunkie(~Adium@p5B15332B.dip0.t-ipconnect.de) has joined #tryton05:56
-!- zmijunkie1(~Adium@p5B15332B.dip0.t-ipconnect.de) has joined #tryton06:00
-!- zmijunkie(~Adium@p5B15332B.dip0.t-ipconnect.de) has joined #tryton06:06
-!- plaes(~plaes@unaffiliated/amd) has joined #tryton06:50
-!- JanGB(~jan@ip92343817.dynamic.kabel-deutschland.de) has joined #tryton07:00
-!- dj_xatra(~dj_xatra@217.166.83.130) has joined #tryton08:14
-!- Timitos(~kpreisler@host-88-217-184-172.customer.m-online.net) has joined #tryton08:44
-!- dmollerm(~dmollerm@170.red-80-28-119.staticip.rima-tde.net) has joined #tryton08:50
-!- mrichez(~smuxi@mail.saluc.com) has joined #tryton09:09
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton09:10
-!- rpit(~rpit@aftr-37-24-147-53.unity-media.net) has joined #tryton09:24
-!- JanGB(~jan@x2f7ffd6.dyn.telefonica.de) has joined #tryton10:32
-!- JanGB(~jan@business-178-015-079-061.static.arcor-ip.net) has joined #tryton11:05
-!- nicoe(~nicoe@2a02:a03f:30b2:3c00:ee55:f9ff:fe7b:f7ac) has joined #tryton12:02
-!- JanGB(~jan@business-178-015-079-061.static.arcor-ip.net) has joined #tryton12:23
-!- JanGB(~jan@business-178-015-079-061.static.arcor-ip.net) has joined #tryton12:46
-!- mariomop(~quassel@181.110.124.22) has joined #tryton13:03
-!- nicoe(~nicoe@host-85-201-184-151.dynamic.voo.be) has joined #tryton13:40
-!- cryptic(~cryptic@67-8-35-31.res.bhn.net) has joined #tryton13:41
-!- csotelo_at_work(~csotelo@179.43.99.44) has joined #tryton15:12
-!- kstenger(~karla@r186-54-22-97.dialup.adsl.anteldata.net.uy) has joined #tryton15:43
-!- thaneor(~ldlc6@r179-25-180-232.dialup.adsl.anteldata.net.uy) has joined #tryton15:55
-!- kstenger1(~karla@r190-133-122-78.dialup.adsl.anteldata.net.uy) has joined #tryton16:27
-!- JosDzG(~Thunderbi@189.250.57.203) has joined #tryton17:53
-!- Telesight(~anthony@4dae0c97.ftth.telfortglasvezel.nl) has joined #tryton18:54
-!- JosDzG(~Thunderbi@189.250.57.203) has joined #tryton20:13
-!- JosDzG(~Thunderbi@189.250.57.203) has joined #tryton20:23
-!- nicoe(~nicoe@2a02:a03f:30b2:3c00:ee55:f9ff:fe7b:f7ac) has joined #tryton20:25
-!- JosDzG(~Thunderbi@189.250.57.203) has joined #tryton20:30
-!- JosDzG(~Thunderbi@189.250.57.203) has joined #tryton21:26
-!- JosDzG(~Thunderbi@189.250.57.203) has joined #tryton21:41
-!- JosDzG(~Thunderbi@189.250.57.203) has joined #tryton22:06
kstengerTrying to put up the dump of a database on another server gives me: ProgrammingError: relation "<some_table>_id_seq" already exists.22:08
kstengerHow do you get past this error when you want to put up a backup ? (postgresql)22:08
Pilouyou should explain which commands are used (backup and restore commands)22:12
kstengerI used "pg_dump -xO my_db > my.dump", to create the dump, and "createdb my_db" plus "psql my_db < my.dump" to restore it. I use the same name because it's another server anyway22:22
kstengerwhen I first got the error while trying to update with "trytond-admin --all -d my_db" I thought about doing 1) createdb my_db, 2) trytond-admin --all -d my_db, 3) psql my_db < my.dump22:26
kstengerand this worked until I wanted to "install" the modules that were previously installed on the database, where it showed this error22:27
-!- JosDzG(~Thunderbi@189.250.57.203) has joined #tryton22:28
kstengeroh, and actually the first error was complaining it's not a tryton database... I should have started with this, but I thought i had it figured out by updating the tryton database before feeding the db with the dump22:28
cedkkstenger: you must not initialize the DB when restoring a backup22:29
kstengeroh22:30
cedkkstenger: the backup contains all the table definition22:31
-!- sebd(~seb@aditu.ldd.fr) has joined #tryton22:32
cedkkstenger: so if you init first, you will have existing table etc.22:32
kstengercedk: indeed, I thiink I just got there because I wanted to change the admin password22:32
cedkkstenger: you can change using trytond-admin22:32
kstengerok, let me go through my steps again see what I missed22:33
kstengerok, if I feed the database with the dump, and then just try to run the server with the -d parameter I get psycopg2.ProgrammingError: permission denied for relation ir_cache22:36
cedkkstenger: I guess you are restoring using the wrong user22:38
kstengeroh yeah, that got it23:47

Generated by irclog2html.py 2.11.0 by Marius Gedminas - find it at mg.pov.lt!