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 14:54.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.