i have one table db with 216000 records and about 800mg size.
i want to backup it with pg_dump, but with compress format ,backup stop at 20mg and then nothing happen(at dos prompt)...
pg_dum done backup with plain data-only switch, but when i want to restore it on other pc ,
psql gives me error :
COPY mytbl (id, site, category, title, author, mydate, keywords, body) FROM stdin; 2009-01-20 11:49:29 IRST LOG: could not receive data from client: No connection could be made because the target machine actively refused it.
so please help me, how to backup and restore this db ?
i run postgresql 8.3.3 on WinXP sp2.