pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: codeWarrior <gpatnude@hotmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: restore challenge
Date: Thu, 17 Nov 2005 07:36:49 -0800
Message-ID: <dli7ta$18ho$1@news.hub.org> (raw)
References: <012701c5ea9a$dbab31a0$5605a8c0@ng3054>

it doesnt work that way.... this is postgreSQL -- a relational database..... 
you can't just copy the data directory like you can with mySQL or DBase, or 
BTrieve or any of the "old-school" databases... if you need to backup and 
restore data you need to look at pg_dump and pg_dumpall and the import 
statements in psql...

""Yogvinder Singh"" <yogvinder@newgen.co.in> wrote in message 
news:012701c5ea9a$dbab31a0$5605a8c0@ng3054...
hi,
    I have the backup of the usr/local/pgsql/data folder
    can i use this to manually export all the databases to some other same 
version installation of postgres?
    if possible, how come...
    if not possible why ?
thnks in advance
yogi

Disclaimer :- This e-mail message including any attachment may contain 
confidential, proprietary or legally privileged information. It should not 
be used by who is not the original intended recipient. If you have 
erroneously received this message, you are notified that you are strictly 
prohibited from using, coping, altering or disclosing the content of this 
message. Please delete it immediately and notify the sender. Newgen Software 
Technologies Ltd and / or its subsidiary Companies accept no responsibility 
for loss or damage arising from the use of the information transmitted by 
this email including damage from virus and further acknowledges that any 
views expressed in this message are those of the individual sender and no 
binding nature of the message shall be implied or assumed unlessthe sender 
does so expressly with due authority of Newgen Software TechnologiesLtd and 
/ or its subsidiary Companies, as applicable. 





view thread (5+ messages)  latest in thread

Message-ID: <dli7ta$18ho$1@news.hub.org>
Permalink:  ../dli7ta$18ho$1@news.hub.org/
Also on:    postgresql.org/message-id/dli7ta$18ho$1@news.hub.org

 · 

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: gpatnude@hotmail.com
  Subject: Re: restore challenge
  In-Reply-To: <dli7ta$18ho$1@news.hub.org>
  References: <012701c5ea9a$dbab31a0$5605a8c0@ng3054> <dli7ta$18ho$1@news.hub.org>

* 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