On Sat, Oct 27, 2012 at 6:20 PM, David Lee <davidomundo@gmail.com> wrote:
> Hey folks,
>
> It seems like right now when you want to create an index concurrently, the index creation will get canceled if you
cancelthe statement (i.e. you must keep your statement open).
>
> Is there a way to "launch" an index creation in the background so that the statement doesn't need to be kept open?
>
do it in the command line:
psql -c "CREATE INDEX CONCURRENTLY aname ON atable(acolumn)" adb &
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
Phone: +593 4 5107566 Cell: +593 987171157