Re: [rt-users] migrating from MySQL to Postgres? - SUCCESS!

t say with certainty, but I think it would. Every row is (re)encoded into UTF-8 before being pushed into the new database, if I understand the advice I was given correctly. Cheers, Dario -- Dario Landazuri

Re: [rt-users] migrating from MySQL to Postgres? - SUCCESS!

can shell script on a good day. ;) Hope this is helpful to some. Cheers, Dario -- Dario Landazurida...@astro.as.utexas.edu Systems Administrator (512) 471-3334 McDonald Observatory *

Re: [rt-users] migrating from MySQL to Postgres?

lking about that. Thanks. -Dario -- Dario Landazurida...@astro.as.utexas.edu Systems Administrator (512) 471-3334 McDonald Observ

Re: [rt-users] migrating from MySQL to Postgres?

ned) packages for it straight from postgres.org. (Side note: I've changed from digest subscription to full for the time being - no need to cc me on messages anymore) Cheers, Dario -- **** Dario Landazurida...@as

Re: [rt-users] migrating from MySQL to Postgres?

, ?, ?, ?, ?, ?, ?, ?, ?, ?)'ERROR: duplicate key value violates unique constraint "tickets_pkey", referer: https:///Ticket/Create.html?Queue=3 Any ideas? I have moved back to the mysql-backed instance for the time being. Thanks, Dario -- ******

[rt-users] Edward Groenendaal?

Dario -- Dario Landazurida...@astro.as.utexas.edu Systems Administrator (512) 471-3334 McDonald Observatory smime.p7s Description: S/MIME Cryptographic Signature 2011 Tra

Re: [rt-users] migrating from MySQL to Postgres?

Thanks, Dario -- **** Dario Landazurida...@astro.as.utexas.edu Systems Administrator (512) 471-3334 McDonald Observatory smime.p7s Description: S/MIME Cryptographic Signature 2011

Re: [rt-users] migrating from MySQL to Postgres?

be helpful. Additionally, since I'm on the digest instead of full rt-users list, please cc me if you reply to this. Thanks, Dario -- Dario Landazurida...@astro

Re: [rt-users] migrating from MySQL to Postgres?

vice? Cheers, Dario -- **** Dario Landazurida...@astro.as.utexas.edu Systems Administrator (512) 471-3334 McDonald Observatory smime.p7s Description: S/MIME Cry

[rt-users] migrating from MySQL to Postgres?

Hat (the system is running RHEL5) and looking at using one of the tools (probably the one from PostgreSQL themselves) here: http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL Advice? Cheers, Dario -- ****

[rt-users] HTTP/HTTPS bug in 4.0?

ast ticket transaction, etc) all properly go to https://... Cheers, Dario -- ******** Dario Landazurida...@astro.as.utexas.edu Systems Administrator (512) 471-3334 McDonald O