On 5 Dec 2006 at 2:59, [EMAIL PROTECTED] 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
[EMAIL PROTECTED]
----------------------------------------------------------------------
---------------------------(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
