Re: WAL Archiving under Windows - Mailing list pgsql-general

From Tom Lane
Subject Re: WAL Archiving under Windows
Date
Msg-id 29018.1162306666@sss.pgh.pa.us
Whole thread Raw
In response to Re: WAL Archiving under Windows  (Tim Tassonis <timtas@cubic.ch>)
Responses Re: WAL Archiving under Windows
List pgsql-general
Tim Tassonis <timtas@cubic.ch> writes:
> The strange thing is, even with loglevel debug5, I don't get any log
> message indicating that postgres is even trying to call the command.

Then it isn't, because there are definitely log messages, which were
specifically put there for the purpose of recording the fully-expanded
archive command string:

    ereport(DEBUG3,
            (errmsg_internal("executing archive command \"%s\"",
                             xlogarchcmd)));
    rc = system(xlogarchcmd);
    if (rc != 0)
    {
        ereport(LOG,
                (errmsg("archive command \"%s\" failed: return code %d",
                        xlogarchcmd, rc)));
        return false;
    }
    ereport(LOG,
            (errmsg("archived transaction log file \"%s\"", xlog)));

Better double-check the usual sorts of gotchas, like whether you are
editing the right config file and properly forcing a config reload
afterwards.

            regards, tom lane

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: [HACKERS] Index greater than 8k
Next
From: Darcy Buskermolen
Date:
Subject: Re: [HACKERS] Index greater than 8k