Re: Copying pg_control file

From: Kretschmer Andreas
Subject: Re: Copying pg_control file
Date: ,
Msg-id: 20041218093731.GA2887@kaufbach.delug.de
(view: Whole thread, Raw)
In response to: Copying pg_control file  ("Deepa K")
List: pgsql-novice

Tree view

Copying pg_control file  ("Deepa K", )
 Re: Copying pg_control file  (Kretschmer Andreas, )
 Re: Copying pg_control file  ("Deepa K", )
  Re: Copying pg_control file  (Kretschmer Andreas, )
  Re: Copying pg_control file  (Tom Lane, )

am  Sat, dem 18.12.2004, um 14:04:07 +0530 mailte Deepa K folgendes:
> Hi all,
>  I am running postgresql 7.1.3 on Red Hat Linux 7.2. pg_control file get
> corrupted on abrupt PC reboot. Can I copy the pg_control file of another
> PC (in which also postgresql 7.1.3 is running on Red Hat Linux 7.2)
> here??

Unlikely. The pg_control contains information about the last checkpoint.
It is used by pg_restore. I think, the contents of the pg_control - file
ist from the other machine ist very different to the crashed machine.


Regards, Andreas
--
Diese Message wurde erstellt mit freundlicher Unterstützung eines freilau-
fenden Pinguins aus artgerechter Freilandhaltung.   Er ist garantiert frei
von Micro$oft'schen Viren. (#97922 http://counter.li.org)     GPG 7F4584DA
Was, Sie wissen nicht, wo Kaufbach ist? Hier: N 51.05082°, E 13.56889° ;-)


pgsql-novice by date:

From: George Weaver
Date:
Subject: Re: how to echo SQL commands in the output of a script
From: Tom Lane
Date:
Subject: Re: Copying pg_control file