On 07/03/2018 07:43 PM, Andy Colson wrote:
Hi All,
I moved a physical box to a VM, and set its memory to 1Gig. Everything
runs fine except one backup:
/pub/backup# pg_dump -Fc -U postgres -f wildfire.backup wildfirep
g_dump: Dumping the contents of table "ofrrds" failed: PQgetResult()
failed.
pg_dump: Error message from server: ERROR: out of memory
DETAIL: Failed on request of size 1073741823.
pg_dump: The command was: COPY public.ofrrds (id, updateddate, bytes) TO
stdout;
I've been reducing my memory settings:
maintenance_work_mem = 80MB
work_mem = 5MB
shared_buffers = 200MB
But it doesnt seem to make a difference.
The tables looks like:
wildfire=# \dt+ ofrrds
List of relations
Schema | Name | Type | Owner | Size | Description
--------+--------+-------+-------+-------+-------------
public | ofrrds | table | andy | 15 MB |
ildfire=# \d ofrrds
Table "public.ofrrds"
Column | Type | Modifiers
-------------+------------------------+-----------
id | character varying(100) | not null
updateddate | bigint | not null
bytes | bytea |
Indexes:
"ofrrds_pk" PRIMARY KEY, btree (id)
wildfire=# select id, length(bytes) from ofrrds;
id | length
-------------------+-----------
muc_rooms | 152330241
packet_count | 76165121
muc_users | 76165121
sessions | 76165121
muc_occupants | 9520641
muc_traffic |
server_bytes | 301850625
proxyTransferRate | 76165121
server_sessions | 152330241
conversations | 304660481
(10 rows)
I'm not sure how to get this backup to run. Any hints would be
appreciated.
Maybe:
1) Try:
pg_dump -t ofrrds
to dump only that table.
2) If that works then:
pg_dump -T ofrrds
to dump everything but that table.
-Andy
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
