postgrsql problem

[Tenaka]

I am getting postgrsql errors with this cronjob:

Cron <postgres@hxxxx> if ! pidof /usr/lib/postgresql/bin/pg_autovacuum > /dev/null && [ -x /usr/lib/postgresql/bin/do.maintenance ]; then /usr/lib/postgresql/bin/do.maintenance -a; fi

the error is as follows:

/bin/sh: line 1: /bin/pidof: Keine Berechtigung
/usr/sbin/invoke-rc.d: line 1: /sbin/runlevel: Keine Berechtigung

so now who has no permission to what? and how can I correct this?

[falko]

Which user is running that cron job? Seems like the user postgres. What happens if root runs the cron job?

[Tenaka]

psql: FATAL: Benutzer »root« existiert nicht
psql: FATAL: Benutzer »root« existiert nicht

[Tenaka]

anyone able to help with these postgrsql errors?

[till]

Originally Posted by Tenaka

psql: FATAL: Benutzer »root« existiert nicht
psql: FATAL: Benutzer »root« existiert nicht

Do you have a pgsql user "root" ?

[Tenaka]

sorry, falko helped out with installing postgrsql, I dunno nothing 'bout it. I just found the error in the logfiles and wanted to fix it, though I posted here...
I'll wait for his feedback.

[falko]

Originally Posted by Tenaka

sorry, falko helped out with installing postgrsql, I dunno nothing 'bout it. I just found the error in the logfiles and wanted to fix it, though I posted here...
I'll wait for his feedback.

I haven't done any Postgresql configuration, I've just installed it with

apt-get install postgresql

[Tenaka]

OK ,-) that means I can safely deinstall and reinstall it and see what the original crontab entry will look like thx