restore you can, kind of pause, by pausing data feed to it. (assuming you have a control over pipe, and you are using text dump format). as for pg dump, I don't think there's a way. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general