Re: pg_dump and cluster

Angva wrote:
> Hello,
> 
> I have a question regarding pg_dump and table clustering. Each night a
> job runs that basically does the following:
> 
> 1) load large amounts of data from flat files into a schema
> 2) cluster the data
> 3) pg_dump that schema
> 4) copy the resulting dmp to several destination databases
> 5) pg_restore the dmp on the destinations
> 
> Can anyone tell me if the restored data will remain clustered? That is,
> does the dmp contain the data in clustered order, and if so, does
> pg_restore preserve this order?

Yes.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.