The following command use to work:
wts1=# CLUSTER inv_search4_idx ON Invoice ;
But now I am getting the following error:
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
Fedora Core 2
The actual script looks like:
# Knock off any users. They shouldn't be up this late!
/sbin/service postgresql restart
echo -e "\n-->Re-Clustering Orderdate Index on Invoice Table"
/usr/bin/psql -h 192.168.2.144 wts1 <<EOF
CLUSTER inv_search4_idx ON Invoice ;
VACUUM FULL ANALYZE Invoice ;
echo -e "\nDone"
Thanks in advance