HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)

- Server Operation (http://www.howtoforge.com/forums/forumdisplay.php?f=5)

- - postgrsql problem (http://www.howtoforge.com/forums/showthread.php?t=849)

Ovidiu

14th October 2005 09:04

postgrsql problem

I am getting postgrsql errors with this cronjob:

Quote:

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:

Quote:

/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

Quote:

Originally Posted by Tenaka

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

Quote:

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

Code:

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

All times are GMT +2. The time now is 08:56.