| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | FBaron(at)co(dot)belcorp(dot)biz |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Reindex from command line linux |
| Date: | 2005-04-22 17:23:07 |
| Message-ID: | 20050422172307.GA11267@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Fri, Apr 22, 2005 at 11:36:46 -0500,
FBaron(at)co(dot)belcorp(dot)biz 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Browne | 2005-04-22 18:44:00 | Re: Another Data directory for second database - feasible? |
| Previous Message | Michael Fuhr | 2005-04-22 17:15:06 | Re: Another Data directory for second database - feasible? |