PostgreSQL problems on Mac Yosemite Beta

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Re: PostgreSQL problems on Mac Yosemite Beta

Postby pasisiauses » Sun Jul 27, 2014 8:21 am

I already done that. Mike (the other Mike) already looking to the issue, I replied him with things he needed. Waiting for his respond.
pasisiauses
 
Posts: 17
Joined: Tue Dec 21, 2010 9:09 am

Re: PostgreSQL problems on Mac Yosemite Beta

Postby kraada » Sun Jul 27, 2014 8:46 am

Thanks. We'll get this figured out :)
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: PostgreSQL problems on Mac Yosemite Beta

Postby d0nkkk » Sun Jul 27, 2014 6:01 pm

I submitted a support ticket as well.

How long do these things typically take to get sorted out? I need to know whether it makes sense to revert to mavericks or secure a secondary cpu to run pt4 on.
d0nkkk
 
Posts: 27
Joined: Mon Feb 04, 2008 10:24 pm

Re: PostgreSQL problems on Mac Yosemite Beta

Postby runlikeyum » Sun Jul 27, 2014 9:18 pm

+1 for the exact same issue
runlikeyum
 
Posts: 12
Joined: Sat Oct 13, 2012 10:11 pm

Re: PostgreSQL problems on Mac Yosemite Beta

Postby d0nkkk » Sun Jul 27, 2014 9:30 pm

Update:
I created a new database and am now able to use pokertracker (on the new database). However, I still am unable to access/activate the existing database that contains all my previous hands.
d0nkkk
 
Posts: 27
Joined: Mon Feb 04, 2008 10:24 pm

Re: PostgreSQL problems on Mac Yosemite Beta

Postby WhiteRider » Mon Jul 28, 2014 3:37 am

d0nkkk wrote:Update:
I created a new database and am now able to use pokertracker (on the new database). However, I still am unable to access/activate the existing database that contains all my previous hands.


Thanks for the update. That sounds like a problem with PostgreSQL in the Yosemite update. Bear in mind that OSX 10.10 is a very new Beta and will still have bugs.
Did you make a Backup of your databases before you upgraded your operating system? If so, try restoring the backup as that may well work.
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: PostgreSQL problems on Mac Yosemite Beta

Postby YashN » Tue Jul 29, 2014 2:10 pm

Had a similar issue with Yosemite beta and PT4. This is what I did to make PT4 run again:

Get the latest PostgreSQL installer for Mac OS X and install it. Create a new DB in PT 4.

If you want to be able to access your previous DB, then I recommend exporting/backing up the old DB and re-importing/restoring with Yosemite.

That should work for PT3 too.
YashN
 
Posts: 38
Joined: Mon Oct 21, 2013 3:14 pm

Re: PostgreSQL problems on Mac Yosemite Beta

Postby golovinster » Mon Aug 04, 2014 1:13 am

have same problem. trying to run PGSL manually and get that message:
2014-08-04 11:02:14 YEKT FATAL: could not create shared memory segment: Invalid argument
2014-08-04 11:02:14 YEKT DETAIL: Failed system call was shmget(key=5432001, size=37969920, 03600).
2014-08-04 11:02:14 YEKT HINT: This error usually means that PostgreSQL's request for a shared memory segment exceeded your kernel's SHMMAX parameter. You can either reduce the request size or reconfigure the kernel with larger SHMMAX. To reduce the request size (currently 37969920 bytes), reduce PostgreSQL's shared_buffers parameter (currently 4096) and/or its max_connections parameter (currently 104).
If the request size is already small, it's possible that it is less than your kernel's SHMMIN parameter, in which case raising the request size or reconfiguring SHMMIN is called for.
The PostgreSQL documentation contains more information about shared memory configuration.
golovinster
 
Posts: 10
Joined: Thu Nov 07, 2013 5:50 am

Re: PostgreSQL problems on Mac Yosemite Beta

Postby kraada » Mon Aug 04, 2014 11:09 am

Open Terminal and run this command and let me know if it fixes things (it's a temporary measure until the next reboot, until we find a working value there's no reason to change it permanently):

sudo sysctl -w kern.sysv.shmmax=75939840
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: PostgreSQL problems on Mac Yosemite Beta

Postby golovinster » Mon Aug 04, 2014 11:23 am

already run this command with 1G value. but no result :(
new postgres 9.3 installation works well.
golovinster
 
Posts: 10
Joined: Thu Nov 07, 2013 5:50 am

PreviousNext

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: MagPie Crawler and 3 guests

cron
highfalutin