| chat.freenode.net #tryton log beginning Thu Jun 8 00:00:01 CEST 2017 | ||
| 2017-06-08 00:11 -!- nicoe(~nicoe@2a02:a03f:30b2:3c00:ee55:f9ff:fe7b:f7ac) has joined #tryton | ||
| 2017-06-08 01:39 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2017-06-08 02:23 -!- JosDzG(~Thunderbi@189.250.57.203) has joined #tryton | ||
| 2017-06-08 03:51 -!- thaneor(~ldlc6@r167-56-50-49.dialup.adsl.anteldata.net.uy) has joined #tryton | ||
| 2017-06-08 04:23 -!- zmijunkie1(~Adium@p5B15332B.dip0.t-ipconnect.de) has joined #tryton | ||
| 2017-06-08 05:40 -!- zmijunkie(~Adium@p5B15332B.dip0.t-ipconnect.de) has joined #tryton | ||
| 2017-06-08 05:43 -!- zmijunkie1(~Adium@p5B15332B.dip0.t-ipconnect.de) has joined #tryton | ||
| 2017-06-08 05:53 -!- smarro(~sebastian@181.16.7.104) has joined #tryton | ||
| 2017-06-08 05:56 -!- zmijunkie(~Adium@p5B15332B.dip0.t-ipconnect.de) has joined #tryton | ||
| 2017-06-08 06:00 -!- zmijunkie1(~Adium@p5B15332B.dip0.t-ipconnect.de) has joined #tryton | ||
| 2017-06-08 06:06 -!- zmijunkie(~Adium@p5B15332B.dip0.t-ipconnect.de) has joined #tryton | ||
| 2017-06-08 06:50 -!- plaes(~plaes@unaffiliated/amd) has joined #tryton | ||
| 2017-06-08 07:00 -!- JanGB(~jan@ip92343817.dynamic.kabel-deutschland.de) has joined #tryton | ||
| 2017-06-08 08:14 -!- dj_xatra(~dj_xatra@217.166.83.130) has joined #tryton | ||
| 2017-06-08 08:44 -!- Timitos(~kpreisler@host-88-217-184-172.customer.m-online.net) has joined #tryton | ||
| 2017-06-08 08:50 -!- dmollerm(~dmollerm@170.red-80-28-119.staticip.rima-tde.net) has joined #tryton | ||
| 2017-06-08 09:09 -!- mrichez(~smuxi@mail.saluc.com) has joined #tryton | ||
| 2017-06-08 09:10 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2017-06-08 09:24 -!- rpit(~rpit@aftr-37-24-147-53.unity-media.net) has joined #tryton | ||
| 2017-06-08 10:32 -!- JanGB(~jan@x2f7ffd6.dyn.telefonica.de) has joined #tryton | ||
| 2017-06-08 11:05 -!- JanGB(~jan@business-178-015-079-061.static.arcor-ip.net) has joined #tryton | ||
| 2017-06-08 12:02 -!- nicoe(~nicoe@2a02:a03f:30b2:3c00:ee55:f9ff:fe7b:f7ac) has joined #tryton | ||
| 2017-06-08 12:23 -!- JanGB(~jan@business-178-015-079-061.static.arcor-ip.net) has joined #tryton | ||
| 2017-06-08 12:46 -!- JanGB(~jan@business-178-015-079-061.static.arcor-ip.net) has joined #tryton | ||
| 2017-06-08 13:03 -!- mariomop(~quassel@181.110.124.22) has joined #tryton | ||
| 2017-06-08 13:40 -!- nicoe(~nicoe@host-85-201-184-151.dynamic.voo.be) has joined #tryton | ||
| 2017-06-08 13:41 -!- cryptic(~cryptic@67-8-35-31.res.bhn.net) has joined #tryton | ||
| 2017-06-08 15:12 -!- csotelo_at_work(~csotelo@179.43.99.44) has joined #tryton | ||
| 2017-06-08 15:43 -!- kstenger(~karla@r186-54-22-97.dialup.adsl.anteldata.net.uy) has joined #tryton | ||
| 2017-06-08 15:55 -!- thaneor(~ldlc6@r179-25-180-232.dialup.adsl.anteldata.net.uy) has joined #tryton | ||
| 2017-06-08 16:27 -!- kstenger1(~karla@r190-133-122-78.dialup.adsl.anteldata.net.uy) has joined #tryton | ||
| 2017-06-08 17:53 -!- JosDzG(~Thunderbi@189.250.57.203) has joined #tryton | ||
| 2017-06-08 18:54 -!- Telesight(~anthony@4dae0c97.ftth.telfortglasvezel.nl) has joined #tryton | ||
| 2017-06-08 20:13 -!- JosDzG(~Thunderbi@189.250.57.203) has joined #tryton | ||
| 2017-06-08 20:23 -!- JosDzG(~Thunderbi@189.250.57.203) has joined #tryton | ||
| 2017-06-08 20:25 -!- nicoe(~nicoe@2a02:a03f:30b2:3c00:ee55:f9ff:fe7b:f7ac) has joined #tryton | ||
| 2017-06-08 20:30 -!- JosDzG(~Thunderbi@189.250.57.203) has joined #tryton | ||
| 2017-06-08 21:26 -!- JosDzG(~Thunderbi@189.250.57.203) has joined #tryton | ||
| 2017-06-08 21:41 -!- JosDzG(~Thunderbi@189.250.57.203) has joined #tryton | ||
| 2017-06-08 22:06 -!- JosDzG(~Thunderbi@189.250.57.203) has joined #tryton | ||
| 2017-06-08 22:08 <kstenger> Trying to put up the dump of a database on another server gives me: ProgrammingError: relation "<some_table>_id_seq" already exists. | ||
| 2017-06-08 22:08 <kstenger> How do you get past this error when you want to put up a backup ? (postgresql) | ||
| 2017-06-08 22:12 <Pilou> you should explain which commands are used (backup and restore commands) | ||
| 2017-06-08 22:22 <kstenger> I 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 anyway | ||
| 2017-06-08 22:26 <kstenger> when 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.dump | ||
| 2017-06-08 22:27 <kstenger> and this worked until I wanted to "install" the modules that were previously installed on the database, where it showed this error | ||
| 2017-06-08 22:28 -!- JosDzG(~Thunderbi@189.250.57.203) has joined #tryton | ||
| 2017-06-08 22:28 <kstenger> oh, 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 dump | ||
| 2017-06-08 22:29 <cedk> kstenger: you must not initialize the DB when restoring a backup | ||
| 2017-06-08 22:30 <kstenger> oh | ||
| 2017-06-08 22:31 <cedk> kstenger: the backup contains all the table definition | ||
| 2017-06-08 22:32 -!- sebd(~seb@aditu.ldd.fr) has joined #tryton | ||
| 2017-06-08 22:32 <cedk> kstenger: so if you init first, you will have existing table etc. | ||
| 2017-06-08 22:32 <kstenger> cedk: indeed, I thiink I just got there because I wanted to change the admin password | ||
| 2017-06-08 22:32 <cedk> kstenger: you can change using trytond-admin | ||
| 2017-06-08 22:33 <kstenger> ok, let me go through my steps again see what I missed | ||
| 2017-06-08 22:36 <kstenger> ok, 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_cache | ||
| 2017-06-08 22:38 <cedk> kstenger: I guess you are restoring using the wrong user | ||
| 2017-06-08 23:47 <kstenger> oh yeah, that got it |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!