Postgre Errors when running backup

[gdahl]

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?

[cpanelben]

If PostgreSQL is installed, then it is assumed that it is being used. If you are not using it then you should uninstall it.

[PPNSteve]

whats the process to uninstall it?

we have a similar problem..

[cpanelben]

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

[Stream]

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

[cpanelben]

Add the following to /etc/cpbackup.conf

PSQLBACKUP=no

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

[hjunior]

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?

[cpanelben]

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

[hjunior]

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.

[cpanelben]

/scripts/cpbackup2 will soon be removed from /scripts.

[KirkColvin747]

was getting that error in backup logs also...

changed
PSQLBACKUP=no

to

PSQLBACKUP no

seems = sign caused problems.

no error messages now.

[dprophit]

[QUOTE=hjunior]/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:/QUOTE]cPanel staff, in his solution is this a bug then?

[cpanelben]

Since cpbackup2 is deprecated (and will be removed in the near future) PostgreSQL support was not added to it.

[baldor]

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

this helps me a lot. but you may have some problem while uninstalling postgre. on redhat enterprise edition 3, i used this;

rpm -e rh-postgresql-devel rh-postgresql-libs rh-postgresql-server rh-postgresql

[peterbaker]

this helps me a lot. but you may have some problem while uninstalling postgre. on redhat enterprise edition 3, i used this;

rpm -e rh-postgresql-devel rh-postgresql-libs rh-postgresql-server rh-postgresql

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