[ADMIN] Postgres monitoring

, connect_time, error log, virtual memory (system), cpu (system) etc etc. Regards, Francesco. -- -- Francesco Dalla Ca' - Email: [EMAIL PROTECTED] Settore Gestione Sistemi CINECA Via Magnanelli 6/3 40033 Casalecchio di Reno (BO) Bologna,

[ADMIN] Meaning of contexts from pg_settings view

ALTER DATABASE" command? Best regards, Francesco. -- ------ Francesco Dalla Ca' Settore Gestione Sistemi CINECA Via Magnanelli 6/3 40033 Casalecchio di Reno (BO) Bologna, Italy http://www.cineca.it ---

[ADMIN] OIDs wraparaound: postgresql (different versions) behavior

fferents server behaviors for this phenomenon on differents realeases? Thank in advance for replies. Best regards, Francesco. -- ---------- Francesco Dalla Ca' Settore Gestione Sistemi CINECA Via Magnanelli 6/3 40033 Casalecchio di Reno (BO) Bol

[ADMIN] procedural languages and public schema

ages functions on a different schema? This schema must be accessible for all db user? With which privileges (only usage)? What's the mean of the proacl column for these functions relatively to TRUSTED|UNTRUSTED create language clause? ======= CIN

[ADMIN] postgres teoretical and (best-)pratical size limits

I have some questions about the subject. in the postgresql F.A.Q.: http://www.postgresql.org/docs/faqs.FAQ.html#4.4 "... 4.4) What is the maximum size for a row, a table, and a database? These are the limits: Maximum size for a database?unlimited (32 TB databases exist) Maximum size

[ADMIN] pg 8.0: Restoring the catalog after disk corruption: it's possible?

arting from the last backup?). Best regards. -- === CINECA Via Magnanelli 6/3 40033 Casalecchio di Reno (Bologna) Settore Gestione Sistemi Francesco Dalla Ca' Email [EMAIL PROTECTED] ===

Re: [ADMIN] FATAL: invalid value for parameter "wal_sync_method":

and best regards. Scott Marlowe wrote: On Thu, 2005-06-16 at 09:35, Francesco Dalla Ca' wrote: O.S.: SuSE SLES-8 (i386) VERSION = 8.1 After some test with the "syncbench" posted on performance mailing-list (http://archives.postgresql.org/pgsql-performance/2004-09/msg0008

[ADMIN] FATAL: invalid value for parameter "wal_sync_method": "open_datasync"

O.S.: SuSE SLES-8 (i386) VERSION = 8.1 After some test with the "syncbench" posted on performance mailing-list (http://archives.postgresql.org/pgsql-performance/2004-09/msg00080.php) i have obtained that open() with O_DSYNC was the fastest sync method. I want to test this for parameter "wal_syn