Re: [GENERAL] Wal -long transaction

2006-03-13 Thread Agnes Bocchino
Martijn van Oosterhout wrote: On Mon, Mar 13, 2006 at 03:59:33PM +0100, Agnes Bocchino wrote: I would like to know how Postgresql works when all the files (checkpoint_segment *2 + 1) are full , does Postgresql rollback the transaction when all the wal segments are used, or does the server

[GENERAL] Wal -long transaction

2006-03-13 Thread Agnes Bocchino
I would like to know how Postgresql works when all the files (checkpoint_segment *2 + 1) are full , does Postgresql rollback the transaction when all the wal segments are used, or does the server stop with an error message ? (I have tried to make the test but without success for finding a long t

Re: [GENERAL] Question about the contrib rpm ?

2006-03-03 Thread Agnes Bocchino
Hello Tom, hello List, Sorry if we haven't been clear in our first mail. We don't really understand your answer. So, we try to clarify our general question and give more details : When we go on the web site to download PostgreSQL 8.1.2, we find not only the serveur rpm but also some others rpms.

Re: [GENERAL] How to save and restore a template database ?

2006-03-03 Thread Agnes Bocchino
Michael Fuhr wrote: On Thu, Mar 02, 2006 at 05:17:12PM +0100, DANTE ALEXANDRA wrote: We have a question concerning backup / restore of database. Is it right if we say that for having a complete backup, we have do : 1. use pg_dumpall 2. do a backup of the modified "template1" database with pg

Re: [GENERAL] Initdb panic: invalid record offset at 0/0 creating

2006-01-25 Thread Agnes Bocchino
c and it is fine ! (compiling, installing, initdb,) regards Agnès Tom Lane wrote: Agnes Bocchino <[EMAIL PROTECTED]> writes: Do you have some explanation or/and tips on how to build a successfull rpm on ia64, with icc, perhaps we shoud not please tell us Perhaps you

Re: [GENERAL] Initdb panic: invalid record offset at 0/0 creating

2006-01-24 Thread Agnes Bocchino
Hello Tom Do you know that this compiler generates trustworthy code with those options? The contents of the pg_control file are clearly good according to the dump from pg_controldata, and yet we have Perhaps we should use others options, could you tell us which are the write options with i