[ADMIN] restoring a database from a file copy

2004-06-20 Thread Chris Fjell
Can a database system be restored just from the data under the installation directory? I backed-up my database using rsync /var/lib/pgsql dest_directory Then I upgraded my rpms from 7.3.4 to 7.4. Then I tried to start the server as usual and it complained about version conflict (of course). I

Re: [ADMIN] restoring a database from a file copy

2004-06-20 Thread Bruno Wolff III
On Fri, Jun 18, 2004 at 16:42:18 -0700, Chris Fjell [EMAIL PROTECTED] wrote: Can a database system be restored just from the data under the installation directory? Only if the postmaster has been shut down. For live backups you should be using pg_dumpall. ---(end of