[rt-users] migrating from MySQL to Postgres?

[Dario Landazuri]

Greetings,

Some progress has been made on this front.  I have made some slight 
edits to Edward Groenendaal's script found here: 
http://wiki-archive.bestpractical.com/view/MySQLToPg that Ruslan pointed 
out.  I am now able to migrate data from my mysql database to a postgres 
one.  I'll post that script tomorrow.

RT comes up ok with the postgres database, but I am unable to create new 
tickets - the following error comes up in /var/log/httpd/error_log:

[Tue Jun 28 17:31:56 2011] [error] [client 128.83.129.176] FastCGI: 
server "/opt/rt/rt4/sbin/rt-server.fcgi" stderr: [Tue Jun 28 22:31:56 
2011] [crit]: Couldn't create a ticket: Internal Error: Couldn't execute 
the query 'INSERT INTO Tickets (Subject, Status, Queue, Creator, Owner, 
LastUpdatedBy, Started, Type, Resolved, Starts, Created, Priority, 
LastUpdated, Due) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
?)'ERROR:  duplicate key value violates unique constraint 
"tickets_pkey", referer: https://<rt instance>/Ticket/Create.html?Queue=3

Any ideas?  I have moved back to the mysql-backed instance for the time 
being.

Thanks,
Dario

-- 
************************************************************
Dario Landazuri                    dario at astro.as.utexas.edu
Systems Administrator                         (512) 471-3334
McDonald Observatory
************************************************************

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5065 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110628/b3a91191/attachment.bin>