Issue
The Postgresql file on my server doesn't seem to start. When I looked at the /var/lib/pgsql/pgstartup.log file, it gives the following errorFATAL: could not create shared memory segment: Invalid argument
I read a lot of other posts which suggested changing the SHMMAX value. I did this through the /etc/sysctl.conf file and then ran sysctl -p. It worked the first time and the PGSQL service started running. But then, when I tried a SQL import (of 55GB), it again stopped and this time changing the SHMMAX value didn't help. Actually, the problem started with importing the SQL file of 55GB. It worked till the first 30% and then stopped. I don't know why it keeps crashing.
Basically, there are two things I'm seeking help for:
- How to get the PGSQL service running?
- How to import a 55GB SQL file without any problems?
I've looked into a lot of resources, still haven't been able to find a solution. Any help will be appreciated.
Thanks!
EDIT: I found the solution. The issue was with disk space. After I emptied the psql data log files (day-wise), the service started working. Thank you all for the help.
Solution
This has been solved now. The edited post contains the solution too.
Thanks!
Answered By - Pushpak Raj Gautam