Re: Upgrading Database: need to dump and restore?

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: Carlos Oliva <carlos(at)pbsinet(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Upgrading Database: need to dump and restore?
Date: 2009-06-04 12:49:20
Message-ID: 2f4958ff0906040549u53bafe7br772033214d43e262@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jun 4, 2009 at 1:23 PM, Carlos Oliva <carlos(at)pbsinet(dot)com> wrote:
> In which state do we need to put the db?  We can use both types of backup
> strategy.  We can pg_dump the table and copy the tablespace folder along
> with anyhting else that we may need.
Well, not quite. Pg_dump is fine, but you can't just copy data itself,
when server is running.

--
GJ

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Carlos Oliva 2009-06-04 13:11:41 Re: Upgrading Database: need to dump and restore?
Previous Message hubert depesz lubaczewski 2009-06-04 12:42:21 is it safe to clear oroginal xlog after archiving it?