Re: [GENERAL] pg_dumpall and check constraints

2000-07-02 Thread Philip Warner
At 11:33 1/07/00 +0200, Jan Wieck wrote: Was late for me too, and maybe the answer was too lazy. So let me give you an example of what I meant: About 5 mins after I hit the send button on my last message I realized the error in my ways (again). There are probably limitations one

Re: [GENERAL] Announce: Testers needed for revised pg_dump/pg_restore

2000-07-02 Thread Philip Warner
It's probably best to look in the directory: ftp://ftp.rhyme.com.au/pub/ for the latest version. Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.C.N. 008 659 498)

Re: [GENERAL] disk backups

2000-07-02 Thread Martijn van Oosterhout
Philip Warner wrote: At 23:34 1/07/00 +1000, Martijn van Oosterhout wrote: Philip Warner needs alpha testers for his new version of pg_dump ;-). Unfortunately I think he's only been talking about it on pghackers so far. What versions does it work on? 6.5.x and 7.0.x. Which

Re: [GENERAL] pg_dumpall and check constraints

2000-07-02 Thread Jan Wieck
Philip Warner wrote: At 11:33 1/07/00 +0200, Jan Wieck wrote: Was late for me too, and maybe the answer was too lazy. So let me give you an example of what I meant: About 5 mins after I hit the send button on my last message I realized the error in my ways (again). There are

Re: [GENERAL] vacuumdb problem

2000-07-02 Thread Tom Lane
Marcin Inkielman [EMAIL PROTECTED] writes: NOTICE: FlushRelationBuffers(osoby, 228): block 223 is referenced (private 0, global 1) FATAL 1: VACUUM (vc_repair_frag): FlushRelationBuffers returned -2 this table is referenced in my db by a tree of FOREIGN KEYs. Hmm, I wonder whether there

[GENERAL] 2 phase commit abilities

2000-07-02 Thread Christophe Doré
Hi, I am currently in the process of evaluating DB solutions on Linux, and I need to know if it is possible to do 2-phases-commit with PosgreSQL. I would also need some ideas on performances, so if anybody can share anything n this subject, he/she is welcome !! Thanks in advance,