Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2007

    Exclamation Issue in postgreSQL

    Issue in postgreSQL

    client has created postgresql database & user for it,
    but unable to login to the postgreSQL
    HostNotch Hosting Services 99.9% uptime Shared Hosting, Reseller Hosting
    yajur | Sales Team
    CPanel Hosting • R1 Soft • Offsite-Backup • Great Uptime sales @

  2. #2
    Join Date
    Jul 2009
    psql -d mydb -U myuser

    Use this command if you find any error please paste it here

  3. #3
    If you are seeing the following error in the cPanel error log (/usr/local/cpanel/logs/error_log) you need to reset the password of postgres user from WHM >> SQL Services >> Postgres Config as given in the file /var/lib/pgsql/.pgpass

    psql: FATAL: password authentication failed for user “postgres”

    And the error – ERROR: role “cPanel_username” does not exist can be fixed by executing the following command as root.

    cd /var/cpanel/users && for x in *; do su -c “createuser -S -D -R $x” postgres; done

    It will create all the missing entries inside the postgreSQL database corresponding to the cPanel users.

Similar Threads

  1. Serious security issue with default postgresql install on cPanel?
    By dspillettt in forum Hosting Software and Control Panels
    Replies: 8
    Last Post: 05-08-2013, 10:43 PM
  2. postgresql issue :(
    By Rafal_A in forum Hosting Security and Technology
    Replies: 1
    Last Post: 07-18-2007, 06:36 PM
  3. PostgreSQL 8.2.a
    By dumpster in forum Web Hosting
    Replies: 0
    Last Post: 07-04-2007, 06:15 AM
  4. PostgreSQL and PHP
    By lide in forum Hosting Security and Technology
    Replies: 9
    Last Post: 05-20-2005, 09:29 AM
  5. postgresql with php
    By Lem0nHead in forum Hosting Security and Technology
    Replies: 3
    Last Post: 05-27-2004, 03:32 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts