Re: Restarting DB after moving to another drive

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Restarting DB after moving to another drive
Date: 2015-05-13 18:15:57
Message-ID: 555394DD.8050200@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 5/13/2015 11:06 AM, Daniel Begin wrote:
> I am then currently running pg_dumpall on the database. I will restore the cluster on the new drive once completed. However, there is still something obscure in the process. The doc says "pg_dumpall requires all needed tablespace directories to exist before the restore". External tablespaces directories are easy to create but what's about pg_default and pg_global tablespace since I never created specific tablespaces for them?

those are created when you initdb the target cluster prior to restoring
the pg_dumpall output.

--
john r pierce, recycling bits in santa cruz

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Begin 2015-05-13 21:34:45 Re: Restarting DB after moving to another drive
Previous Message Daniel Begin 2015-05-13 18:06:31 Re: Restarting DB after moving to another drive