Does anyone know how to run a REINDEX via command line?

[Rivers]

Anyone know what the syntax is? I tried a couple but it doesn't seem to work. Trying to automate it by running a .bat file every weekend.

psql .. ?

[netsrak]

If you activate it in pgadminII there is a message box which displays the command line. You can copy and paste it from there.

[Rivers]

hmm i just tried it but i don't seem to be able to see the command line changing to show the reindex command?

[netsrak]

You are right, seems like i used a different pgadmin version (i guess the linux version) when i saw the command line options.

Here are some links explaining how it should work:
Re: Reindex from command line linux (http://archives.postgresql.org/pgsql-admin/2005-04/msg00315.php)
PostgreSQL: Documentation: Manuals: PostgreSQL 8.3: REINDEX (http://www.postgresql.org/docs/8.3/static/sql-reindex.html)

[Rivers]

Just tried both but to no avail..

Get an error: psql: FATAL: role -c does not exist

I tried using psql <mydbname> -c "reindex database" and quite a fair bit of others. :( nobody ever tried this out using command line and scheduling it?

[netsrak]

if you run psql --help you should get a syntax help.
And there should also be a documentation for this on the postgresql site.

I can't test it in the moment but if you can't figure it out push this thread again and i will try it on my own

[netsrak]

This is the easiest solution i think:


reindexdb -U postgres -w -d HoldemManager

-U the user to connect
-w don't ask for password
-d the database name

for further options type reindexdb --help

[Rivers]

doesnt work.. i have to put a psql in front cos reindexdb isn't an executable in windows


C:\Windows\System32>psql reindexdb -U postgres -w HOLDEMMANAGER
psql: warning: extra command-line argument "postgres" ignored
psql: warning: extra command-line argument "-w" ignored
psql: warning: extra command-line argument "HOLDEMMANAGER" ignored
psql: FATAL: database "reindexdb" does not exist


the vacuumdb command line script works fine for me though

psql -h localhost -d HOLDEMMANAGER -U postgres -c "vacuum full"

when I try to edit the vacuum db script with "reindex database" it doesn't work. darn.

[netsrak]

You need to have "reindexdb" in the postgresql\bin folder and start it from there

[Rivers]

Thanks. That worked perfect!