[Rt-devel] migration from 2.0.15 to 3.2.0 nearly flawless

[Jesse Vincent]

On Tue, Jul 06, 2004 at 10:43:24AM -0400, Vivek Khera wrote:
> The show stopper:
> 
> None of the sequences in Postgres was initialized after the dumpfile 
> was imported.  

Yes. That's documented in the README for the upgrade tool:

  If you're using a database such as Postgres or Oracle that has
  explicit sequence support, you may need to set the value of each
  table's sequence to the MAX(id) for that table


> The most immediately visible result is that no 
> correspondence can be recorded since attachments keep hitting duplicate 
> id's.  The fix is to run a command like this for every single sequence:
> 
> select setval('users_id_seq',max(id)) from users;
> 
> the sequences are:
> 
>                       List of relations
>  Schema |             Name             |   Type   |  Owner
> --------+------------------------------+----------+----------
>  public | acl_id_seq                   | sequence | postgres
>  public | attachments_id_seq           | sequence | postgres
>  public | attributes_id_seq            | sequence | postgres
>  public | cachedgroupmembers_id_seq    | sequence | postgres
>  public | customfields_id_seq          | sequence | postgres
>  public | customfieldvalues_id_seq     | sequence | postgres
>  public | groupmembers_id_seq          | sequence | postgres
>  public | groups_id_seq                | sequence | postgres
>  public | links_id_seq                 | sequence | postgres
>  public | principals_id_seq            | sequence | postgres
>  public | queues_id_seq                | sequence | postgres
>  public | scripactions_id_seq          | sequence | postgres
>  public | scripconditions_id_seq       | sequence | postgres
>  public | scrips_id_seq                | sequence | postgres
>  public | templates_id_seq             | sequence | postgres
>  public | ticketcustomfieldvalues_id_s | sequence | postgres
>  public | tickets_id_seq               | sequence | postgres
>  public | transactions_id_seq          | sequence | postgres
>  public | users_id_seq                 | sequence | postgres
> 
> _______________________________________________
> Rt-devel mailing list
> Rt-devel at lists.bestpractical.com
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel

--