I can run the following command from a command prompt with no problem on my database.
/usr/bin/vacuumdb --verbose --analyze --all -U postgres
But if I try to execute it via a bash shell script, I receive the following error. The role does exist in the database.
does not existnot connect to database postgres: FATAL: role "postgres
I am new to postgresql so any help would be greatly appreciated.
Thanks
Craig
________________________________________
Craig Ferry
Sr. Database Administrator
WESCO Distribution, Inc.
Suite 700
225 West Station Square Drive
Pittsburgh, PA 15219
P:412-454-2835
F:412-222-7535
crferry@xxxxxxxxxxxxx
________________________________________
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
