Re: Mysql/postgre sql database question
Re: Mysql/postgre sql database question
- Subject: Re: Mysql/postgre sql database question
- From: Musall Maik <email@hidden>
- Date: Tue, 28 Jun 2016 21:13:17 +0200
PostgreSQL runs fine on OS X. I recommend homebrew to manage the software installation, which lets you easily choose which version you want, pin certain versions and so on.
The only caveat that I know of is when you run pg on another platform, say Linux, in production, and use an OS X server as hot standby replication target. That works, but is not supported. There are issues like "=" selects producing empty result sets while "like" on the same values work. So, if using replication, stay within the same platform. Otherwise, no restrictions.
Maik
> Am 28.06.2016 um 19:58 schrieb ute Hoffmann <email@hidden>:
>
> Hi,
> my intranet applications runs for some years on mysql. But now it seems the new version of mysql and Mac OS X Yosemite are no
> longer compatible. The database opens tables but never closes them and after some time throws exceptions (too many open files). I tried what I found
> on the web but to little avail. At the moment someone has to stop and restart the database engine twice a day by hand - very bad solution.
> As I understood it, it is a incompatibility beween how mac os x handles files and how mysql does so there is no real bugfix to this.
>
> So I thought about porting all to Postgres. Do you have any caveats? Will Postgres run (without major bugs) on mac os x yosemite+?
>
> Thanks for some advice.
>
> Regards,
> Ute
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden