PDA

View Full Version : postgrsql problem


Ovidiu
14th October 2005, 09:04
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
14th October 2005, 09:38
Which user is running that cron job? Seems like the user postgres. What happens if root runs the cron job?

Ovidiu
16th October 2005, 04:26
psql: FATAL: Benutzer »root« existiert nicht
psql: FATAL: Benutzer »root« existiert nicht

Ovidiu
18th October 2005, 01:07
anyone able to help with these postgrsql errors?

till
18th October 2005, 10:37
psql: FATAL: Benutzer »root« existiert nicht
psql: FATAL: Benutzer »root« existiert nicht

Do you have a pgsql user "root" ?

Ovidiu
18th October 2005, 14:11
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
18th October 2005, 15:57
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

Ovidiu
18th October 2005, 16:38
OK ,-) that means I can safely deinstall and reinstall it and see what the original crontab entry will look like thx