On Wed, Aug 25, 2004 at 07:07:23PM +0300, Daniel Kalchev wrote:
> Does such toll exist, that could dump data (records?) from the heap files
> given the table structure?
You may want to check pg_filedump (from http://sources.redhat.com/rhdb
IIRC).
(What happened to pg_fsck BTW?)
--
Alvaro Herr
>>>Tom Lane said:
> Daniel Kalchev <[EMAIL PROTECTED]> writes:
> > (found out 7.2.3 does not have pg_database)
>
> You think not?
Not as a file similar to pg_control. pg_database is indeed table in the system
catalog.
> > By the way, I had to copy over the 'new' files from pg_clog and pg_x
Daniel Kalchev <[EMAIL PROTECTED]> writes:
> (found out 7.2.3 does not have pg_database)
You think not?
> By the way, I had to copy over the 'new' files from pg_clog and pg_xlog (this
> is the second possible error) to get the postmaster running.
That was *not* part of the recipe, and is guarant
Tom I did the following:
(found out 7.2.3 does not have pg_database)
1. saved old data etc.
2. created new database, and the database. database oid was 16556;
3. moved data/global to the old data directory.
4. though, that postmaster would actually use the database oid to locate the
directory
Ah, you said 'is NOT missing'.
Chris
Daniel Kalchev wrote:
data/base/global is missing and this is where postgres gets all it's startup
data from (database oids, next oid, transaction id etc).
Let's see how easy to recover from this it will turn to be.
Daniel
Christopher Kings-Lynne said:
> If
data/base/global is missing and this is where postgres gets all it's startup
data from (database oids, next oid, transaction id etc).
Let's see how easy to recover from this it will turn to be.
Daniel
>>>Christopher Kings-Lynne said:
> If you're not missing your data dir, clog or xlog then wha
If you're not missing your data dir, clog or xlog then what's the problem?
Daniel Kalchev wrote:
Hello,
Is there ANY chance to recover data from a database system that suffered disk
crash, and is not missing the data/global directory?
Version is 7.2.4. Database files seem to be intact as well as
Tom,
This is basically what I had in mind, but you described it better than I ever
could :)
What I need from this database system is just one database and probably not
all of the tables anyway (but some do seem valuable). This database happens to
be second in the pg_dumpall script. The next da
Daniel Kalchev <[EMAIL PROTECTED]> writes:
> Is there ANY chance to recover data from a database system that suffered disk
> crash, and is not missing the data/global directory?
> Version is 7.2.4. Database files seem to be intact as well as pg_clog and
> pg_xlog directories.
The hard part I thin
Hello,
Is there ANY chance to recover data from a database system that suffered disk
crash, and is not missing the data/global directory?
Version is 7.2.4. Database files seem to be intact as well as pg_clog and
pg_xlog directories.
Thanks in advance for any ideas.
Daniel
--
10 matches
Mail list logo
