Re: restore challenge

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(at)newgen(dot)co(dot)in> wrote in message
news:012701c5ea9a$dbab31a0$5605a8c0(at)ng3054(dot)(dot)(dot)
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.