Differences

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

Link to this comparison view

Next revision
Previous revision
cpanel:fix_postgresql [2010-01-08 09:02:00]
garrett.plasky created
cpanel:fix_postgresql [2010-06-09 16:29:58]
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:
  
-<quote>ERROR: role "​user"​ doesn'​t exist</quote>+<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}}