Re: [ADMIN] Filesystem Backup

2002-02-04 Thread manav
Well the pg_dump(all) utils give a version mismatch, I guess my DB is 7.1.3 and the utils are some other version (how do I check the versions correctly?) dunno how that happened. How can I upgrade the utils and leave the DB engine untouched? It's a redhat linux box so rpms would be preferrd. Than

Re: [ADMIN] Filesystem Backup

2002-02-04 Thread Naomi Walker
If I understand correctly, the only time a pure file system restore would work to put back your data was if the instance was down when the file systems were backed up.  Otherwise, pg_dump of a database, or pg_dumpall of the whole instance would be necessary.  If you were doing this for some oth

Re: [ADMIN] Filesystem Backup

2002-02-03 Thread David Stanaway
On Monday, February 4, 2002, at 12:54 AM, manav wrote: Hello All,   I am in a fix and need help. I am reinstalling postgresql server on my linux workstation and\ I did a filesystem backup of ../pgsql/data/*, but when I deleted the data directory and reconstructed it from my backup (without the

[ADMIN] Filesystem Backup

2002-02-03 Thread manav
Hello All,   I am in a fix and need help. I am reinstalling postgresql server on my linux workstation and\ I did a filesystem backup of ../pgsql/data/*, but when I deleted the data directory and reconstructed it from my backup (without the reinstall, just to check if things would work) I