Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | |
| cpanel:fix_postgresql [2010-01-08 09:03:03] – garrett.plasky | cpanel:fix_postgresql [2010-06-09 16:29:58] (current) – garrett.plasky |
|---|
| ===== Fixing PostgreSQL ===== | ===== Fixing PostgreSQL ===== |
| |
| cPanel's PostgreSQL support is still a bit rudimentary, and as of 11.25 RELEASE ther estill is one major bug with it. After following the [[http://docs.cpanel.net/twiki/bin/view/AllDocumentation/InstallationGuide/InstallingPostgresql|PostgreSQL installation]] steps on in the documentation, existing users still will not have the ability to create databases. You will see the following in the error log indicating this: | cPanel's PostgreSQL support is still a bit rudimentary, and as of 11.25 RELEASE there still is one major bug with the installation. After following the [[http://docs.cpanel.net/twiki/bin/view/AllDocumentation/InstallationGuide/InstallingPostgresql|PostgreSQL installation]] steps on in the documentation, existing users still will not have the ability to create databases. You will see the following in the error log indicating this: |
| |
| <code>ERROR: role "user" doesn't exist</code> | <code>ERROR: role "user" doesn't exist</code> |
| cPanel will also die without an error in the interface when attempting to create a database. To fix this, run the following from a root shell: | cPanel will also die without an error in the interface when attempting to create a database. To fix this, run the following from a root shell: |
| |
| <code console># # cd /var/cpanel/users && for x in *; do su -c "createuser -S -D -R $x" postgres; done</code> | <code console># cd /var/cpanel/users && for x in *; do su -c "createuser -S -D -R $x" postgres; done</code> |
| {{tag>cpanel postgresql}} | {{tag>cpanel postgresql}} |
