| From: | Clodoaldo Pinto Neto <clodoaldo_pinto(at)yahoo(dot)com(dot)br> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | pg_restore: error returned by PQputline |
| Date: | 2004-08-29 23:13:56 |
| Message-ID: | 20040829231356.59097.qmail@web40907.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-08-29 23:40:52 | Re: pg_restore: error returned by PQputline |
| Previous Message | Rick G | 2004-08-29 23:10:31 | Re: monitor+keyboard+mouse together |