[SQL] PQendcopy: resetting connection error

2000-11-23 Thread sathya priya
hai, I encountered the following error While I was trying to pg_dump the database using the command pg_dump -z dbname > bkfilename PQendcopy: resetting connection SQL query to dump the contents of Table 'sarehits' did not execute correctly. A fter we read all the table contents from the ba

[SQL] pg_dump

2000-07-25 Thread sathya priya
hai when dump the database it throw "getTables(): relation 'ordermaster': cannot find function with oid 1655 for trigger RI_ConstraintTrigger_2017354 " any clues thank advance p. ashok kumar __ Do You Yahoo!? Get Yahoo! Mail – Free email you

[SQL] query optimazation & starting postmaster with -B option

2000-07-22 Thread sathya priya
hai, Q 1 : Posgresql is running on Linux machine with 512MB ram. My question is When i start the postmaster with -B 3000 then there is no problem. If the start the postmaster with more than the 3000 then errors msg is popped out. How do I increase this buffer option morethan 3000 and wh