Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
cpanel:fix_postgresql [2010-01-08 09:03:03] – garrett.plaskycpanel: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}}