pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dario <dario_d_s@unitech.com.ar>
To: pgsql-admin@postgresql.org
Subject: Re: restore database from bare files
Date: Wed, 29 Jun 2005 17:10:35 -0300
Message-ID: <MHEDJHCKDNOEHJKHIOCJIECKCEAA.dario_d_s@unitech.com.ar> (raw)
In-Reply-To: <200506292048.23713.peter_e@gmx.net>

Hello. Sorry for mi inglish! :-)

Postgres 7.4 will not access 7.3 PGDATA repository. You must downgrade your
binary files to any 7.3.X (latest is better)
Note: 7.3 won't access 7.4 files neither. Yo can only do sub-sub-version
updates without having to dump and restore (example 7.3.1. to 7.3.9 doesn't
need to dump and restore of databases)

greeting.

-----Mensaje original-----
De: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]En nombre de Peter Eisentraut
Enviado el: miƩrcoles, 29 de junio de 2005 15:48
Para: jehan procaccia
CC: pgsql-admin@postgresql.org
Asunto: Re: [ADMIN] restore database from bare files


jehan procaccia wrote:
> However I do have a tar file of the filesystem , it was on a RHEL 3
> with rh-postgresql-server-7.3.9-2 and I have a tar of /var/lib/pgslq
> will just restoring the whole directory /var/lib/pgsql will suffices

Assuming that you made the tarball when the server was shut down, just
restore it and you should be all set.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)




view thread (12+ messages)  latest in thread

Message-ID: <MHEDJHCKDNOEHJKHIOCJIECKCEAA.dario_d_s@unitech.com.ar>
Permalink:  ../MHEDJHCKDNOEHJKHIOCJIECKCEAA.dario_d_s@unitech.com.ar/
Also on:    postgresql.org/message-id/MHEDJHCKDNOEHJKHIOCJIECKCEAA.dario_d_s@unitech.com.ar

 · 

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: dario_d_s@unitech.com.ar
  Subject: Re: restore database from bare files
  In-Reply-To: <MHEDJHCKDNOEHJKHIOCJIECKCEAA.dario_d_s@unitech.com.ar>
  References: <200506292048.23713.peter_e@gmx.net> <MHEDJHCKDNOEHJKHIOCJIECKCEAA.dario_d_s@unitech.com.ar>

* 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