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}} |