Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
cpanel:fix_postgresql [2010-01-08 09:03:03] garrett.plasky |
cpanel:fix_postgresql [2010-06-09 16:29:58] (current) garrett.plasky |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ===== 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> | ||
| Line 7: | Line 7: | ||
| 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}} | ||
