Search Postgresql Archives

Re: pg_basebackup on standby node failed

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, Feb 4, 2014 at 5:51 AM, Ying He <yinghe0101@xxxxxxxxx> wrote:
> When I do:
> pg_basebackup -D /backupDir
>
> I am getting:
> pg_basebackup: directory "/usr/local/pgsql/data/pg_tblspc/tablespace1"
> exists but is not empty
>
> tablespace1 is a tablespace created by CREATE TABLESPACE and
> ""/usr/local/pgsql/data/pg_tblspc/tablespace1" is a symlink pointing to a
> dir which will always exists and not empty
Creating a tablespace *inside* PGDATA, which is what you seem to be
doing, is not good practice. Btw, it looks like you faced the bug of a
tablespace inside PGDATA fixed by this commit and back-patched down to
9.1:
commit b168c5ef2730d0ecaa7462f0b90345b0a3798c16
Author: Magnus Hagander <magnus@xxxxxxxxxxxx>
Date:   Tue Jan 7 17:04:40 2014 +0100

    Avoid including tablespaces inside PGDATA twice in base backups

    If a tablespace was crated inside PGDATA it was backed up both as part
    of the PGDATA backup and as the backup of the tablespace. Avoid this
    by skipping any directory inside PGDATA that contains one of the active
    tablespaces.

    Dimitri Fontaine and Magnus Hagander
This will appear in the next minor release.

> I tried using -Ft -P, that works to create tar files in the /backupDir but
> pg_basebackup -D /backupDir -Ft -P -X s will fail with:
> pg_basebackup: wal streaming can only be used in plain mode
I see no problem with this error message. You are trying to create a
tarball and to stream xlog files at the same time.
Regards,
-- 
Michael


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux