Search Postgresql Archives

Re: Warm standby failover mechanism

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

 



On Wed, 2009-02-25 at 21:39 +0000, Thom Brown wrote:
> 
>         As a note, all PITRTools does is wrap around all the tools
>         that you are
>         trying to make work. So you will still need pg_standby, rsync,
>         ssh
>         etc...
>         
>         I have updated the wiki to make it a bit more friendly.
>         
>         https://projects.commandprompt.com/public/pitrtools/wiki
>         
>         
>         
> I've given PITRTools a try, but I have been unsuccessful in utilising
> it.  I've configured both ini files, everything owned by user
> postgres, and upon running "./cmd_archiver -C cmd_archiver.ini" I get:
> 
> NOTICE: check_config_func()
> NOTICE: Performing standard archive
> NOTICE: archive_func()
> NOTICE: send_queue_func()
> NOTICE: list_queue_func()
> NOTICE: generate_slave_list_func()
> NOTICE: Your slaves are: ['192.168.1.17']
> Traceback (most recent call last):
>   File "../pitr_tools/cmd_archiver", line 343, in <module>
>     archive_func()
>   File "../pitr_tools/cmd_archiver", line 254, in archive_func
>     queue = send_queue_func()
>   File "../pitr_tools/cmd_archiver", line 219, in send_queue_func
>     for host in list_queue_func():
>   File "../pitr_tools/cmd_archiver", line 202, in list_queue_func
>     list_archives = os.listdir(queuedir)
> OSError: [Errno 2] No such file or directory:
> '/var/lib/postgresql/archive/192.168.1.17'
> 
> The only time that IP address appears in the INI file is on the slaves
> line, so I'm not sure why it's trying to find a directory called that.

Looks like you didn't run cmd_archiver -C <config_file> -I

Joshua D. Drake


-- 
PostgreSQL - XMPP: jdrake@xxxxxxxxxxxxxxxxxxxxx
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997


-- 
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