On 5 Dec 2006 at 2:59, hugo.wetterberg@gmail.com wrote:

> live database. We need to copy all data, structure information,
> functions et.c. from the live database to the development database
> every now and then. The development database will be on a separate
> machine. What is the best way to do this?

I do that every now and then.....I simply do a complete dump of the
database I need using pg_dump, and then reload it on the development
machine using psql (I generally do a text-format dump).

--Ray.


----------------------------------------------------------------------

Raymond O'Donnell
Director of Music, Galway Cathedral, Galway, Ireland
rod@iol.ie
----------------------------------------------------------------------



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match