psql - Role root does not exist

Question

I build a bash command in a PHP script. The built command is such as :

su postgres -c "for tbl in `psql -qAt -c \"select tablename from pg_tables where schemaname = 'public';\" demodoo` ;do  psql -c \"alter table $tbl owner to postgres\" demodoo ;done "

When I try to run this command in a shell, I get this error :

 psql: FATAL:  role "root" does not exist

Why is this occuring, whereas i execute the command under postgres user ?

Thanks Cheers,

EDIT I change the command to

sudo -u postgres for tbl in `psql -qAt -c "select tablename from pg_tables where schemaname = 'public';" demodoo` ;do  psql -c "alter table $tbl owner to postgres" demodoo ;done

but now I get another error which I can't understand the origin :

-bash: syntax error near unexpected token `do'

check this link : http://serverfault.com/questions/601140/whats-the-difference-between-sudo-su-postgres-and-sudo-u-postgres — Hardik Solanki, Nov 25 '14 at 10:46
Thanks, I edited my question after reading the post, but I get an error — renard, Nov 25 '14 at 11:07
This link may help you : http://stackoverflow.com/questions/11919391/postgresql-error-fatal-role-username-does-not-exist — Hardik Solanki, Nov 25 '14 at 11:12

score 10 · Answer 1 · answered Jul 02 '15 at 08:35

10

try:

sudo -u postgres psql

> CREATE USER root WITH SUPERUSER;

answered Jul 02 '15 at 08:35

Dmitriy Kosolobov

347
3
10

score 0 · Answer 2 · answered Nov 25 '14 at 11:36

I finnaly get it working, by saving the content of the command

for tbl in `psql -qAt -c "select tablename from pg_tables where schemaname = 'public';" demodoo` ;do  psql -c "alter table $tbl owner to postgres" demodoo ;done

in a file myfile.sh, then call the file as follow :

sudo -u postgres /bin/bash myfile.sh

Thank you for your help

psql - Role root does not exist

2 Answers2