Role does not exist when running script.

[craig322]

I can run the following command with no problem on my database.

/usr/bin/vacuumdb --verbose --analyze --all -U super_user

But if I try to execute it via a shell script, I receive the following error. The role does exist in the database.

does not existnot connect to database postgres: FATAL: role "super_user

I am new to postgresql so any help would be greatly appreciated.

 

[stefanwagner]

Your superuser is 'super_user', not 'postgres'?


don't visit my homepage:

http://home.arcor.de/hirnstrom/bewerbung

 

[craig322]

Actually that was my second attempt. The postgres user gives me the same message, so I tried creating a new super user to see if it would work.