Problem with pg_baselinebackup
От | Sebastian, John (CONTR) |
---|---|
Тема | Problem with pg_baselinebackup |
Дата | |
Msg-id | 4064ED67C76A40459DF222111AFD47BE139828FB@EIAMBX01.eia.doe.gov обсуждение исходный текст |
Ответы |
Re: Problem with pg_baselinebackup
|
Список | pgadmin-support |
<div class="WordSection1"><p class="MsoNormal">Hi Folks,<p class="MsoNormal"> <p class="MsoNormal">I’m pretty new to Postgres.I have an extensive Oracle and MySQL background here.<p class="MsoNormal">We are putting up test and productionservers.<p class="MsoNormal">I’m interested in doing online backups with WAL archiving turned on so that I cando point in time recovery.<p class="MsoNormal"> <p class="MsoNormal">My database files are stored in /u01/postgres/dataand /u02/postgres/data/confluence_data directories.<p class="MsoNormal">My WAL files are in /u03/postgres/data/pg_log<pclass="MsoNormal"> <p class="MsoNormal">I want to backup my database to the directory /u03/postgres_backups/pg_basebackups/”directoryname_date_timestamp”<pclass="MsoNormal"> <p class="MsoNormal">I’m trying acommand like this:<p class="MsoNormal">$ pg_basebackup -x --pgdata=/u03/postgres_backups/pg_basebackups/pg_basebackup_16-Jan-2014:10:15:00--label=TEST<p class="MsoNormal"> <p class="MsoNormal">Afterentering the password, I’m receiving the following error:<p class="MsoNormal">pg_basebackup: directory"/u02/postgres/data/confluence_data" exists but is not empty<p class="MsoNormal"> <p class="MsoNormal">The directorythat it is complaining about ("/u02/postgres/data/confluence_data" is a database directory with database data init. Not the directory where I want the backup files to go. I expected that the switch <p class="MsoNormal">--pgdata=/u03/postgres_backups/pg_basebackups/pg_basebackup_16-Jan-2014:10:15:00<p class="MsoNormal"> <pclass="MsoNormal">Would send the backup to that directory. Can anyone enlighten me on why it wouldcomplain about a directory where database files reside?</div>
В списке pgadmin-support по дате отправления: