Problem in PostgresSQL Configuration with YII 1 & Wordpress

Started by Jyoti Sharmaover 9 years ago2 messages
#1Jyoti Sharma
jyoti.sharma@kiwitech.com

Hi Team,

Currently we have a project running with MySQL with YII & Wordpress, Now i
want to change the Database from MYSQL to PostgreSQL.

Please put your inline comments below.
*[JS:] *Is there any way we can convert MYSQL queries to PostreSQL Queries?

*Your Comment : ?*

*[JS:] *Is there any way we can insert serialize data with junked character
in PostgreSQL?

*Your Comment : ?*

*Can we have a meeting with any of your technical spokesperson.*

*Our Frameworks & software version we are using.*
1. YII 1.1.1.4
2. PostgreSQL 9.3
3. Wordpress
4. MYSQL
5. OS : Ubuntu

--
Thanks
Jyoti Sharma

--

************************************************************************

*This e-mail and all attachments are intended solely for use by the
intended recipient and may contain confidential / proprietary information
of KiwiTech, LLC, subject to important disclaimers and conditions including
restrictions on the use, disclosure, transfer or export of such
information.* *If you have received this message in error or are not the
named recipient(s), please immediately notify the sender at the telephone
number stated above or by reply e-mail and delete this e-mail from your
computer*

#2Craig Ringer
craig@2ndquadrant.com
In reply to: Jyoti Sharma (#1)
Re: Problem in PostgresSQL Configuration with YII 1 & Wordpress

On 24 July 2016 at 02:20, Jyoti Sharma <jyoti.sharma@kiwitech.com> wrote:

Hi Team,

Currently we have a project running with MySQL with YII & Wordpress, Now i
want to change the Database from MYSQL to PostgreSQL.

Hi.

The pgsql-hackers mailing list is for development of PostgreSQL its self.
General questions are better suited to the pgsql-general mailing list or to
Stack Overflow.

Conversion from MySQL to PostgreSQL is a common question and there's lots
of info out there, though you might like the answers since there are't any
automagic tools to make all existing queries "just work". As for junk
characters, look at the "bytea" data type. For more information please post
at one of the more appropriate locations given above; I will not reply to
responses to this mail on pgsql-hackers.

--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services