Re: pg_upgrade: out of memory

Поиск
Список
Период
Сортировка
От Carrington, Matthew (Produban)
Тема Re: pg_upgrade: out of memory
Дата
Msg-id 53E23B63FBFF3645A2CDD9BE5933C60C8B1194EACE@ENTAAP2407P.an.ad.anplc.co.uk
обсуждение исходный текст
Ответ на Re: pg_upgrade: out of memory  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: pg_upgrade: out of memory  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I've tried to explore the issue a bit more using 9.2.1. Here's a trace of the build and dump tests ...

tar zxf postgresql-9.2.1.tar.gz
cd postgresql-9.2.1

uname -a
AIX sx1190a 1 6 000A707AD400 powerpc AIX

export OBJECT_MODE=64
export CFLAGS="-maix64"
export LDFLAGS="-maix64 -Wl,-bbigtoc"
export AR="ar -X64"

./configure --prefix=/opt/serviceMonitoring/postgres_9.2.1 --disable-thread-safety

make
cd contrib
make
cd ..
make install
cd contrib
make install

Check to see if a dumpall will work ...

cd /tmp
"/opt/serviceMonitoring/postgres_9.2.1/bin/pg_dumpall" --port 65432 --username "postgres" --schema-only
--binary-upgrade-f pg_upgrade_dump_all.sql 

pg_dump: out of memory
pg_dumpall: pg_dump failed on database "cahoot_monitoring", exiting

... try something less ambitious ...

"/opt/serviceMonitoring/postgres_9.2.1/bin/pg_dump" --port 65432 --username "postgres" --verbose --schema-only
--binary-upgrade-f dump.out template1 
pg_dump: reading schemas
pg_dump: reading user-defined tables
pg_dump: reading extensions
pg_dump: reading user-defined functions
pg_dump: reading user-defined types
pg_dump: reading procedural languages
pg_dump: reading user-defined aggregate functions
pg_dump: out of memory

Has anyone else seen this problem on AIX or elsewhere ?

Matthew
Emails aren't always secure, and they may be intercepted or changed
after they've been sent. Produban doesn't accept liability if this
happens. If you think someone may have interfered with this email,
please get in touch with the sender another way. This message and any
documents attached to it do not create or change any contract unless
otherwise specifically stated. Any views or opinions contained in this
message are solely those of the author, and do not necessarily represent
those of Produban, unless otherwise specifically stated and the sender
is authorised to do so. Produban doesn't accept responsibility for
damage caused by any viruses contained in this email or its attachments.
Emails may be monitored. If you've received this email by mistake,
please let the sender know at once that it's gone to the wrong person
and then destroy it without copying, using, or telling anyone about its
contents. Produban Servicios Informaticos Generales, S.L. (UK Branch).
Registered office: Shenley Wood House, Chalkdell Drive, Shenley Wood,
Milton Keynes MK5 6LA. Branch registration number BR 008486.
Ref:[PDB#014]



В списке pgsql-general по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Re: Need help in reclaiming disk space by deleting the selected records
Следующее
От: "ac@hsk.hk"
Дата:
Сообщение: Re: replicate or multi-master for 9.1 or 9.2