Hi all,
Trying to restore actual data into a development database:
$ pg_dump -Fc KakaoStats > KakaoStats.dump
$ pg_restore -a -d ksDesenv KakaoStats.dump
pg_restore: [compressão de arquivo (banco de dados)] erro retornado
pelo PQputline -- [file compression (database)] error returned by
PQputline
The database is about 3GB
postgresql 7.4.2, FC2, 768 MB memory
$ uname -a
Linux s1 2.6.8-1.521 #1 Mon Aug 16 09:01:18 EDT 2004 i686 athlon i386
GNU/Linux
During some minutes the machine was irresponsive. A litle before that
free showed:
$ free
total used free shared buffers
cached
Mem: 759600 755712 3888 0 8380
70144
-/+ buffers/cache: 677188 82412
Swap: 1539712 1539712 0
From postgreql.conf:
shared_buffers = 3000 # min 16, at least max_connections*2,
8KB each
sort_mem = 65536 # min 64, size in KB
vacuum_mem = 65536 # min 1024, size in KB
max_fsm_pages = 300000 # min max_fsm_relations*16, 6 bytes
each
#max_fsm_relations = 1000 # min 100, ~50 bytes each
_______________________________________________________
Yahoo! Acesso Grátis - navegue de graça com conexão de qualidade!
http://br.acesso.yahoo.com/