Your name : Krok
Your email address : [EMAIL PROTECTED]
System Configuration
-
Architecture : Dual PIII-500
Operating System : FreeBSD 4.7-RELEASE-p7
PostgreSQL version: PostgreSQL-7.3.2
Compiler used : gcc
Yes, RAM is ok.
My server works with very high load and there are no problems at all...
BTW, backend crashes both when used COPY and INSERT in the dump.
I've split dump file into several parts and restore them one by one. Everything was ok.
Krok.
On Tue, Mar 25, 2003 at 12:35:34PM -0500
| 33554438 |
(2 rows)
void=>
Is it bug or there are some errors in my queries ?
Thanks.
Krok.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
ase system is ready
I'm Using PostgreSQL 7.3.2 on FreeBSD-4.7-RELEASE-p7
configure :
./configure '--prefix=/slave/pgsql_7.3.2' '--with-perl' '--enable-integer-datetimes'
'--enable-recode'
Thanks.
Krok.
---(end of broadca
#x27;
$
I've REINDEX and VACUUM table, but it doesn't help.
Can anybody help with this ?
And a question : is the size, that pg_dump has reported (Failed on
request of size 536870920) is required size of available shared memory ?
If it is, then what ?! I need to have 10GB shared memory to dump table
whith 100'000'000 records ?!
--
With best regards,
Krok
signature.asc
Description: OpenPGP digital signature
deleted this row and now backend process crashes with core dumped -
will keep trying to find out why
But how can this happen, that varchar(255) field became broken ?
Tom Lane wrote:
Krok <[EMAIL PROTECTED]> writes:
pg_dump: dumping contents of table users
pg_dump: ERROR: out of memory
DETAIL: Fai
