Re: [PERFORM] pg_restore seems very slow

2016-06-15 Thread Adam Scott
The "simple" case may be anti-virus or firewall blocking feeding into the database. Be sure to check windows system logs for any unusual messages. Check the postgres log (usually in PGDATA/pg_logs) For seeing disk I/O on Win7 check out http://www.digitalcitizen.life/how-use-resource-monitor-wind

Re: [PERFORM] pg_restore seems very slow

2016-06-15 Thread Adrian Myers
Hi David, Thank you for your reply. Yes, there is quite a lot of feedback in the terminal. I can see a small flurry of table operations followed by hours of table contents being printed, presumably as they are inserted. I didn't use the --verbose option, but it seems to be echoing everything it is

Re: [PERFORM] pg_restore seems very slow

2016-06-15 Thread David G. Johnston
On Wed, Jun 15, 2016 at 6:00 PM, Adrian Myers wrote: > This is my first post to the mailing list, so I apologize for any > etiquette issues. > > I have a few databases that I am trying to move from one system to > another. Both systems are running Windows 7 and Postgres 8.4, and they are > prett