On Fri, Apr 22, 2005 at 11:36:46 -0500, FBaron@xxxxxxxxxxxxxx wrote: > > > > > thanks Bruno : > I'm running the command with root > psql -c "REINDEX DATABASE Clibelcorpco FORCE" > psql: FATAL: La base de datos "root" no existe en el catalogo del > sistema.(Traslate : The "root" database doesn´t exsists) You need to run it as the Postgres superuser instead of "root". > I execute : > > psql -d Clibelcorpco -c "REINDEX DATABASE Clibelcorpco FORCE" > ERROR: REINDEX DATABASE: Can be executed only on the currently open > database. > > what do you think? I am not sure what is happening in this case. It might be a case mismatch on the database name.
