On 5 Dec 2006 at 2:59, hugo.wetterberg@xxxxxxxxx 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@xxxxxx ----------------------------------------------------------------------
