File: README.pg_filedump

package info (click to toggle)
postgresql-filedump-8.1 8.1-1
  • links: PTS
  • area: main
  • in suites: etch, etch-m68k
  • size: 148 kB
  • ctags: 95
  • sloc: ansic: 1,598; makefile: 62
file content (97 lines) | stat: -rw-r--r-- 4,006 bytes parent folder | download
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
pg_filedump - Display formatted contents of a PostgreSQL heap/index/control
              file. 

Copyright (c) 2002, 2003, 2005 Red Hat, Inc.

This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.

Author: Patrick Macdonald  <patrickm@redhat.com>

Version: 8.1.1

Overview:
------------------------------------------------------------------------
pg_filedump is a utility to format PostgreSQL heap/index/control files 
into a human-readable form.  You can format/dump the files several ways,
as listed in the Invocation section, as well as dumping straight binary.

The type of file (heap/index) is determined by the structure of the 
blocks within the file.  However, to format a control file you must use
the -c option.

The default is to format the entire file using the block size listed on
block 0 (heap/index files) and display block relative addresses.  These
defaults can be modified using run-time options.   

Some options may seem strange but they're there for a reason.  For
example, block size.  It's there because if the header of block 0 is
corrupt, you need a method of forcing a block size.  


Release  Notes / Databases Supported
-----------------------------------------------------------------------
  V8.1.1 Must be compiled against a PostgreSQL 8.1 installation.
         Supports: PostgreSQL 8.1.x

  V4.0   Must be compiled against a PostgreSQL 8.0 installation.
         Supports: PostgreSQL 8.0.x

  V3.0   Must be compiled against a PostgreSQL 7.4 installation.
         Supports: PostgreSQL 7.4.x 

  V2.0   Must be compiled against a PostgreSQL 7.3 installation.
         Supports: PostgreSQL - Red Hat Edition 3.0,
                   Red Hat Database 2.x, Red Hat Database 1.x
                   PostgreSQL 7.3.x, PostgreSQL 7.2.x, PostgreSQL 7.1.x

  V1.0   Must be compiled against a PostgreSQL 7.1 or PostgreSQL 7.2
         installation.
         Supports: Red Hat Database 2.x, Red Hat Database 1.x
                   PostgreSQL 7.2.x, PostgreSQL 7.1.x


Compile/Installation:
------------------------------------------------------------------------
There are two makefiles included in this package.  Makefile is a
standalone makefile for pg_filedump.  Alter the include and src 
variables to point to the proper directories.  Makefile.contrib can be
used if the package was untarred in the contrib directory of a 
PostgreSQL/RHDB build tree.

  make
  make install (if in the contrib directory)


Invocation:
------------------------------------------------------------------------ 
pg_filedump [-abcdfhixy] [-R startblock [endblock]] [-S blocksize] file

Defaults are: relative addressing, range of the entire file, block size
              as listed on block 0 in the file

The following options are valid for heap and index files:
  -a  Display absolute addresses when formatting (Block header
      information is always block relative)
  -b  Display binary block images within a range (Option will turn
      off all formatting options)
  -d  Display formatted block content dump (Option will turn off
      all other formatting options)
  -f  Display formatted block content dump along with interpretation
  -h  Display this information
  -i  Display interpreted item details
  -R  Display specific block ranges within the file (Blocks are
      indexed from 0)
        [startblock]: block to start at
        [endblock]: block to end at
      A startblock without an endblock will format the single block
  -S  Force block size to [blocksize]
  -x  Force interpreted formatting of block items as index items
  -y  Force interpreted formatting of block items as heap items

The following options are valid for control files:
  -c  Interpret the file listed as a control file
  -f  Display formatted content dump along with interpretation
  -S  Force block size to [blocksize]