Created
March 31, 2021 15:37
-
-
Save nbhusare/54890c2cb5927b8a5a46be208ecb9752 to your computer and use it in GitHub Desktop.
Postgresql: Out of memory while running a script
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ERROR: out of shared memory | |
| HINT: You might need to increase max_locks_per_transaction. | |
| # Solution | |
| 1. Open /data/postgresql.conf | |
| 2. set max_locks_per_transaction = 1024 | |
| 3. Save and Restart postgresql. | |
| # Restarting Postgresql | |
| 1. Winkey + R | |
| 2. services.msc | |
| 3. Search Postgres service based on version installed | |
| 4. Click stop, start or restart the service option. | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment