Hi Chris, yeah these tools works great, our problem was that if I did backup and restoration from web interface then this problem happen.
I wasn't also familiar with postgres :) Cheers - Petr 2008/11/10 Chris Miles <[EMAIL PROTECTED]>: > > > On Nov 10, 4:57 am, "Petr Kobalíček" <[EMAIL PROTECTED]> wrote: >> I have postgres related problem. I'm normally developing with sqlite, >> but we are using postgres on the server. The problem is that >> sqlalchemy probably remembers primary keys and after database restore >> it will start in all tables from 1. > > If you use the PostgreSQL tools pg_dump and pg_restore they should > maintain the sequences properly for you when copying databases between > servers. > > Cheers, > Chris Miles > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---