pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
NAMEDATALEN  change
2+ messages / 2 participants
[nested] [flat]

* NAMEDATALEN  change
@ 2007-08-15 01:09  Gregory Williamson <Gregory.Williamson@digitalglobe.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Gregory Williamson @ 2007-08-15 01:09 UTC (permalink / raw)
  To: pgsql-admin

We need to change the maximum length of table/column name lengths, and it looks as if changing NAMEDATALEN in src/include/postgres_ext.h and recompiling postgres.

2 questions:

a) Do I need to dump the database and reload ? (my guess is yes but only a guess ...)

b) any caveats or warnings about this ?

TIA,

Greg Williamson
Senior DBA
GlobeXplorer LLC, a DigitalGlobe company

Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information and must be protected in accordance with those provisions. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

(My corporate masters made me say this.)

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: NAMEDATALEN change
@ 2007-08-15 02:00  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Gregory Williamson <Gregory.Williamson@digitalglobe.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2007-08-15 02:00 UTC (permalink / raw)
  To: Gregory Williamson <Gregory.Williamson@digitalglobe.com>; +Cc: pgsql-admin

"Gregory Williamson" <Gregory.Williamson@digitalglobe.com> writes:
> a) Do I need to dump the database and reload ?

Yes.  (Any reasonably modern backend will in fact refuse to start
if pg_control shows an incompatible nameDataLen.)  This is not a
lot different from changing --enable-integer-datetimes, for instance.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2007-08-15 02:00 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-08-15 01:09 NAMEDATALEN  change Gregory Williamson <Gregory.Williamson@digitalglobe.com>
2007-08-15 02:00 ` Re: NAMEDATALEN change Tom Lane <tgl@sss.pgh.pa.us>

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