X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 16041DA7B6 for ; Thu, 20 Oct 2005 06:11:03 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 53540-10 for ; Thu, 20 Oct 2005 09:10:57 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.192]) by svr1.postgresql.org (Postfix) with ESMTP id 7990BDA6AC for ; Thu, 20 Oct 2005 06:10:57 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id 8so49958nzo for ; Thu, 20 Oct 2005 02:11:00 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=Zvqq+vV/cLAFVMp5fdLycniCNswTyhzWtFAT8Bbe6d1Y3J91gLrSoO7FTLj6UNBQT+S3MBQb8tBzQ1DWChODWBY/j8AuZkxl7BVsqqLO8Dm5HqHmGgEuIjgDC5bnFhDEjOYnjAlkpg9Ts0os+f1vRCKR18RuBR92/LaF7oGMn0M= Received: by 10.36.222.44 with SMTP id u44mr1488085nzg; Thu, 20 Oct 2005 02:10:59 -0700 (PDT) Received: by 10.36.74.15 with HTTP; Thu, 20 Oct 2005 02:10:59 -0700 (PDT) Message-ID: <674d1f8a0510200210u71177e60s4c261562ea9753a2@mail.gmail.com> Date: Thu, 20 Oct 2005 14:40:59 +0530 From: Gourish Singbal To: pgsql-admin Subject: Fwd: Need HELP - URGENT In-Reply-To: <674d1f8a0510190455k48425e0ds10d549cd433c18f3@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_113_29473363.1129799459616" References: <674d1f8a0510190455k48425e0ds10d549cd433c18f3@mail.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.123 required=5 tests=[AWL=0.003, HTML_50_60=0.095, HTML_MESSAGE=0.001, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200510/229 X-Sequence-Number: 19301 ------=_Part_113_29473363.1129799459616 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline ---------- Forwarded message ---------- From: Gourish Singbal Date: Oct 19, 2005 5:25 PM Subject: Need HELP - URGENT To: pgsql-admin Tom, Need some help in analyzing the pg_controldata output. pg_control version number: 72 Catalog version number: 200310211 Database cluster state: in production pg_control last modified: Wed 19 Oct 2005 02:40:53 AM PDT Current log file ID: 875 Next log file segment: 165 Latest checkpoint location: 36B/9E7BFAB8 Prior checkpoint location: 36B/94485F20 Latest checkpoint's REDO location: 36B/9E2065F8 Latest checkpoint's UNDO location: 0/0 Latest checkpoint's StartUpID: 69 Latest checkpoint's NextXID: 52699733 *Latest checkpoint's NextOID: 3508694151 *Time of latest checkpoint: Wed 19 Oct 2005 02:37:19 AM PDT Database block size: 8192 Blocks per segment of large relation: 131072 Maximum length of identifiers: 64 Maximum number of function arguments: 32 Date/time type storage: 64-bit integers Maximum length of locale name: 128 LC_COLLATE: en_US.UTF-8 LC_CTYPE: en_US.UTF-8 *From Whats given Below i understand that The OID of my database is 3.5Billion and O IDs are stored as 4-byte integers, and will overflow at 4 billion.* ** http://www.sql.org/sql-database/postgresql/FAQ/#4.16 We am using Postgresql 7.4.5 version and its a production database. Are the OIDs going to Overflow ?. if so whats the Solution, Need help, please. -- Best, Gourish Singbal -- Best, Gourish Singbal ------=_Part_113_29473363.1129799459616 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

---------- Forwarded message ----------
From: Gourish Singbal <gourish@gmail.com>
Date: Oct 19, 2005 5= :25 PM
Subject: Need HELP - URGENT
To: pgsql-admin <pgsql-admin@postgresql.org>

Tom,
 
Need some help in analyzing the pg_controldata output.
 
pg_control version number:    &nb= sp;       72
Catalog version number: =             &nb= sp; 200310211
Database cluster state:      = ;         in production
pg_contr= ol last modified:         &nbs= p;   Wed 19 Oct 2005 02:40:53 AM PDT=20
Current log file ID:        &nb= sp;         875
Next log file se= gment:           &nb= sp;    165
Latest checkpoint location:   &= nbsp;       36B/9E7BFAB8
Prior checkpoint = location:           = 36B/94485F20
Latest checkpoint's REDO location:    36B/9= E2065F8=20
Latest checkpoint's UNDO location:    0/0
Latest chec= kpoint's StartUpID:        69
Latest = checkpoint's NextXID:         = 52699733
Latest checkpoint's NextOID:    &n= bsp;     3508694151
Time of latest checkpoi= nt:            Wed 1= 9 Oct 2005 02:37:19 AM PDT=20
Database block size:        &nb= sp;         8192
Blocks per segm= ent of large relation: 131072
Maximum length of identifiers:  =       64
Maximum number of function arguments: = 32
Date/time type storage:       &nbs= p;       64-bit integers=20
Maximum length of locale name:       = ; 128
LC_COLLATE:         &= nbsp;           &nbs= p;     en_US.UTF-8
LC_CTYPE:    =             &nb= sp;            en_US= .UTF-8
 
From Whats given Below i understand that The OID of my da= tabase is 3.5 Billion and OIDs are stored as 4-byte integers= , and will overflow at 4 billion.
 
 

We am using Postgresql 7.4.5 version and its a = production database.
 
Are the OIDs going to Overflow ?. if so whats the Solution, Need help,= please.
--
Best,
Gourish Singbal


-- =
Best,
Gourish Singbal=20 ------=_Part_113_29473363.1129799459616--