On Feb 9, 2005, at 10:13 AM, John Sidney-Woollett wrote:

> Here's what we're attempting (to build the test database):
>
> # DUMP FULL DATABASE
> /usr/local/pgsql/bin/pg_dump $SRC_DATABASE > $BACKUPFILE
>
> # IMPORT THE DUMP FILE
> psql $DEST_DATABASE < $BACKUPFILE
>

I just did a restore for running some analysis on another local system. 
  Basically the process was

pg_dump -Fc dbname
pg_restore -l dumpfile > list
edit list to remove all slony-related objects (tables, triggers, 
functions, etc.)
pg_restore -L list  dumpfile

this restored a cleaned copy.  this works for me since all my tables 
aready had primary keys and slony didn't need to add columns to them.

Vivek Khera, Ph.D.
+1-301-869-4449 x806