The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Postgre Errors when running backup

Discussion in 'General Discussion' started by gdahl, May 7, 2005.

  1. gdahl

    gdahl Member
    PartnerNOC

    Joined:
    Mar 6, 2005
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    I'm getting authentication errors when running the /scripts/cpbackup:


    Grabbing mysql privs...Done
    Grabbing PostgreSQL databases............
    psql: FATAL: Password authentication failed for user "postgres"

    psql: FATAL: Password authentication failed for user "postgres"

    Done
    Grabbing PostgreSQL privileges...psql: FATAL: Password authentication failed for user "postgres"

    psql: FATAL: Password authentication failed for user "postgres"

    Done
    -----------------------------------------

    It'll do that about three times throughout the backup process.

    I'm wondering is there a way I can keep it from doing this? I don't use PostgreSQL, why does it keep trying to back it up?
     
  2. BenThomas

    BenThomas Well-Known Member

    Joined:
    Feb 12, 2004
    Messages:
    598
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Houston, Texas USA
    cPanel Access Level:
    Root Administrator
    If PostgreSQL is installed, then it is assumed that it is being used. If you are not using it then you should uninstall it.
     
  3. PPNSteve

    PPNSteve Well-Known Member

    Joined:
    Mar 13, 2003
    Messages:
    393
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Somewhere in Ilex Forest
    cPanel Access Level:
    Root Administrator
    Twitter:
    whats the process to uninstall it?

    we have a similar problem..
     
  4. BenThomas

    BenThomas Well-Known Member

    Joined:
    Feb 12, 2004
    Messages:
    598
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Houston, Texas USA
    cPanel Access Level:
    Root Administrator
    Just remove the installation of PostgreSQL. This varies between OS vendors. On Redhat 9 it's something like this:

    /etc/init.d/postgresql stop
    rpm -e postgresql-devel postgresql-libs postgresql-server postgresql
     
  5. Stream

    Stream Well-Known Member

    Joined:
    Feb 7, 2004
    Messages:
    64
    Likes Received:
    0
    Trophy Points:
    6
    I'm getting the same errors and don't have postgresql installed.

    I've had it in earlier though, but moved it to another server...
     
  6. BenThomas

    BenThomas Well-Known Member

    Joined:
    Feb 12, 2004
    Messages:
    598
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Houston, Texas USA
    cPanel Access Level:
    Root Administrator
    Add the following to /etc/cpbackup.conf

    PSQLBACKUP=no

    Or remove the postgres user (should have not been there if PostgreSQL was never installed).
     
  7. hjunior

    hjunior Member

    Joined:
    Mar 6, 2005
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Your cpbackup makes psql backups??

    My cpbackup.conf does not have PSQLBACKUP line and is not backing up my postgresql databases. What should I do so it starts postgres backups?
     
  8. BenThomas

    BenThomas Well-Known Member

    Joined:
    Feb 12, 2004
    Messages:
    598
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Houston, Texas USA
    cPanel Access Level:
    Root Administrator
    That's an interesting one. There might be a problem with your PostgreSQL installation. Can you send in a support ticket to my attention so that I can take a look at your server?

    Thanks
     
  9. hjunior

    hjunior Member

    Joined:
    Mar 6, 2005
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    It seems like postgres full support is only on Edge version. My version is Stable. I'm getting psql backups after I changed /scritps/cpbackup2.

    It was needed because /scripts/pkgacct, if called from the shell was executing psql backup perfectly. But when called from /scripts/cpbackup2, lacks $ENV{'pkgacct-psql'} eq "yes".

    /scripts/cpbackup correctly sets pkgacct-psql environment variable, but /scripts/cpbackup2 had those lines missing. I copied the following lines from cpbackup to cpbackup2 and all worked well:

    $ENV{'pkgacct-psql'} = 'yes';
    if ($CONF{'PSQLBACKUP'} eq "no") { $ENV{'pkgacct-psql'} = 'no'; }

    Of course I added the line below to /etc/cpbackup.conf

    PSQLBACKUP yes

    It solved my problem by now. I just would like to exactly from wich version WHM fully supports postgresql.
     
  10. BenThomas

    BenThomas Well-Known Member

    Joined:
    Feb 12, 2004
    Messages:
    598
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Houston, Texas USA
    cPanel Access Level:
    Root Administrator
    /scripts/cpbackup2 will soon be removed from /scripts.
     
  11. KirkColvin747

    KirkColvin747 Member

    Joined:
    Mar 17, 2005
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    was getting that error in backup logs also...

    changed
    PSQLBACKUP=no

    to

    PSQLBACKUP no

    seems = sign caused problems.

    no error messages now.
     
  12. dprophit

    dprophit Member

    Joined:
    Apr 1, 2002
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
     
  13. BenThomas

    BenThomas Well-Known Member

    Joined:
    Feb 12, 2004
    Messages:
    598
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Houston, Texas USA
    cPanel Access Level:
    Root Administrator
    Since cpbackup2 is deprecated (and will be removed in the near future) PostgreSQL support was not added to it.
     
  14. baldor

    baldor Active Member

    Joined:
    Oct 3, 2004
    Messages:
    26
    Likes Received:
    0
    Trophy Points:
    1
    this helps me a lot. but you may have some problem while uninstalling postgre. on redhat enterprise edition 3, i used this;

    Code:
    rpm -e rh-postgresql-devel rh-postgresql-libs rh-postgresql-server rh-postgresql
     
  15. peterbaker

    peterbaker Registered

    Joined:
    Jun 26, 2004
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    You may need to get rid of the contrib, python and perl stuff as well. Give this a try.

    rpm -e rh-postgresql-contrib rh-postgresql-python php-pgsql mod_auth_pgsql perl-DBD-Pg rh-postgresql-devel rh-postgresql-
    libs rh-postgresql-server rh-postgresql
     
  16. bking

    bking Well-Known Member

    Joined:
    Mar 1, 2004
    Messages:
    206
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Sydney
    I am seeing this error during each nights backups.
    I have made some mods as per this thread with /scripts/cpbackup* and I have uninstalled, reinstalled all to no avail. I have also reset the password numerous times.

    Does anyone have any further suggestions?
    Thanks
     
  17. Snowman30

    Snowman30 Well-Known Member
    PartnerNOC

    Joined:
    Apr 7, 2002
    Messages:
    681
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    DataCenter Provider
    Ive noticed were getting this issue now when we do any account moves

    we have postgres installed as well and the master postgres pass is set

    anyone know why these errors would be still occuring?
     
Loading...

Share This Page