pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gourish Singbal <gourish@gmail.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Fwd: Need HELP - URGENT
Date: Thu, 20 Oct 2005 14:40:59 +0530
Message-ID: <674d1f8a0510200210u71177e60s4c261562ea9753a2@mail.gmail.com> (raw)
In-Reply-To: <674d1f8a0510190455k48425e0ds10d549cd433c18f3@mail.gmail.com>
References: <674d1f8a0510190455k48425e0ds10d549cd433c18f3@mail.gmail.com>

---------- 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: 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

view thread (3+ messages)

Message-ID: <674d1f8a0510200210u71177e60s4c261562ea9753a2@mail.gmail.com>
Permalink:  ../674d1f8a0510200210u71177e60s4c261562ea9753a2@mail.gmail.com/
Also on:    postgresql.org/message-id/674d1f8a0510200210u71177e60s4c261562ea9753a2@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: gourish@gmail.com
  Subject: Re: Fwd: Need HELP - URGENT
  In-Reply-To: <674d1f8a0510200210u71177e60s4c261562ea9753a2@mail.gmail.com>
  References: <674d1f8a0510190455k48425e0ds10d549cd433c18f3@mail.gmail.com> <674d1f8a0510200210u71177e60s4c261562ea9753a2@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox