Results 1 to 2 of 2

Thread: Amanda 3.1.2 and PostgresQL problem

  1. #1

    Default Amanda 3.1.2 and PostgresQL problem

    Hi there!

    I just configured my Amanda 3.1.2 Server to backup local PostgresQL databases [URL="http://wiki.zmanda.com/index.php/How_To:Use_Amanda_to_Back_Up_PostgreSQL"]following this instruction [/URL]and met some kind of problem. After running amcheck I saw the following error.

    Code:
    Amanda Backup Client Hosts Check
    --------------------------------
    ERROR: localhost: Get info from .backup file failed
    It is seems to me like Amanda cannot read a file created by itself within the execution of the command
    Code:
    sudo -u amandabackup amcheck DailySet1
    The only ".backup" files I found is located here...

    Code:
    # ls -la /var/lib/postgresql/8.3/main/pg_xlog/
    ...
    000000010000000000000077.00000020.backup -rw-------  1 postgres postgres 16777216 Окт 26 18:23
    ...
    So the permissions of them are owned by postgres user and group. Amanda can't read the newly created files, it's obvious. How can it be fixed? Or what am I doing wrong?..

    Thanks for help!

    P.S. My system is Debian Linux 5.04/AMD64, Amanda Server/Client 3.1.2 (built from Debian official package), PostgresQL 8.3 (also from packages repository).

  2. #2

    Default WAL logging and Amanda

    hello,

    I actually ran into this problem earlier today which is how I turned up this thread. I think you'll find that the answer is that WAL logging in postgres is improperly configured.

    Check the paths in your archive_command in /var/lib/pgsql/data/postgresql.conf file.

    Make sure you get WAL working by following this guide:

    [url]http://www.postgresql.org/docs/current/static/continuous-archiving.html[/url]

    Once you have successfully backed up up to the archive directory and can cd to that location and see that there are files there you can turn your attention back to Amanda configuration.

    Then make sure you check the PG-DATADIR and PG-ARCHIVEDIR values that you have set in /etc/amanda/amanda-client.conf on the client side are correct. Once you're sure that there aren't any type-o's in the paths you have set for those values make sure that

    1) the amandabackup user is part of the postgres group
    2) that the modes on /var/lib/pgsql/archive are set to 750


    Assuming that your disklist is correct, once you have done the above go back to the amanda server and then run amcheck YOURCONFIG once again and see if that clears up any errors you may be experiencing.

    Best of luck!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •