pick up the activity covered
in the WAL files.
From: Jeremy Schneider
Sent: Monday, November 13, 2017 3:56 PM
To: eric...@hotmail.com
Cc: PostgreSQL General; Paul Jungwirth
Subject: Re: [GENERAL] archive_command not being executed
Hi Eric,
Thanks for using PostgreSQL!
On Fri, Nov 10, 2017 at
before.
From: Michael Paquier
Sent: Monday, November 13, 2017 6:01 PM
To: Jeremy Schneider
Cc: eric...@hotmail.com; PostgreSQL General; Paul Jungwirth
Subject: Re: [GENERAL] archive_command not being executed
On Tue, Nov 14, 2017 at 8:56 AM, Jeremy Schneider
wrot
On Tue, Nov 14, 2017 at 8:56 AM, Jeremy Schneider
wrote:
> From my reading of the docs and commit logs, standby databases
> couldn't archive their WALs until 9.5.
pg_receivexlog is available in 9.3. You could leverage your archives
with it easily, by for example connecting it to a standby you'd l
Hi Eric,
Thanks for using PostgreSQL!
On Fri, Nov 10, 2017 at 9:26 AM, Paul Jungwirth
wrote:
> Oh this has happened to me before. :-) On SB1 you need to set
> archive_mode to always (not on). Otherwise it is ignored when running as a
> standby.
It looks to me like this feature was not added unt
On 11/10/2017 09:10 AM, Eric D wrote:
I have a standby db server (SB1) that will soon become the master. SB1
is set up with streaming replication from the current master. I'm
trying to set up a third server (SB2) as a slave/standby to SB1, so that
when SB1 becomes the master, there will be a st
> On Aug 19, 2017, at 04:05, twoflower wrote:
>
> Alvaro Herrera-9 wrote
> I saw one installation with "gsutil cp" in archive_command recently. It had
> the CLOUDSDK_PYTHON environment variable set in the archive_command itself.
> Maybe that's a problem.
> After all, this was the solution:
>
Alvaro Herrera-9 wrote
> I saw one installation with "gsutil cp" in archive_command recently.
> Ithad the CLOUDSDK_PYTHON environment variable set in the
> archive_commanditself. Maybe that's a problem.
After all, this was the solution:
archive_command = 'CLOUDSDK_PYTHON=/usr/bin/python gsutil c
Mark Watson-12 wrote
> I think the parameter %p contains the complete path of the file
It does not, see the link to the official documentation above.
--
View this message in context:
http://www.postgresql-archive.org/archive-command-fails-but-works-outside-of-Postgres-tp5979040p5979061.html
Se
Alvaro Herrera-9 wrote
> I saw one installation with "gsutil cp" in archive_command recently.
> Ithad the CLOUDSDK_PYTHON environment variable set in the
> archive_commanditself. Maybe that's a problem.
That's not the case here, I don't have this variable set anywhere where
gsutil works.
Alvaro
Scott Marlowe-2 wrote
> Sounds like it depends on some envvar it doesn't see when run from the
> postmaster. If you sudo -u postgres and run it does it work?
Yes, I can do su postgres, execute the command and it works.
--
View this message in context:
http://www.postgresql-archive.org/archive
De : pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] De la part de twoflower
Envoyé : Friday, August 18, 2017 2:40 PM
À : pgsql-general@postgresql.org
Objet : [GENERAL] archive_command fails but works outside of Postgres
I changed my archive_command to the following
Scott Marlowe wrote:
> On Fri, Aug 18, 2017 at 12:40 PM, twoflower wrote:
> > I changed my archive_command to the following:
> >
> > archive_command = 'gsutil cp /storage/postgresql/9.6/main/%p
> > gs://my_bucket/pg_xlog/'
> > 2017-08-18 18:34:25.057 GMT [1436][0]: [104321] WARNING: archiving
>
On Fri, Aug 18, 2017 at 12:40 PM, twoflower wrote:
> I changed my archive_command to the following:
>
> archive_command = 'gsutil cp /storage/postgresql/9.6/main/%p
> gs://my_bucket/pg_xlog/'
>
> and it fails, leaving the following in the log:
>
> 2017-08-18 18:34:25.057 GMT [1436][0]: [104319] LO
On Wed, May 25, 2016 at 1:36 PM, Raymond O'Donnell wrote:
> On 25/05/16 20:57, Jeff Janes wrote:
>>
>> On Wed, May 25, 2016 at 10:31 AM, Sameer Kumar
>> wrote:
>>>
>>>
>>>
>>> On Thu, 26 May 2016, 1:25 a.m. Jeff Janes, wrote:
I've recently wanted to run a different archive_command
On 25/05/16 20:57, Jeff Janes wrote:
On Wed, May 25, 2016 at 10:31 AM, Sameer Kumar wrote:
On Thu, 26 May 2016, 1:25 a.m. Jeff Janes, wrote:
I've recently wanted to run a different archive_command during
database shutdown than during normal operations. In particular, if
the normal archive
On Wed, May 25, 2016 at 10:31 AM, Sameer Kumar wrote:
>
>
> On Thu, 26 May 2016, 1:25 a.m. Jeff Janes, wrote:
>>
>> I've recently wanted to run a different archive_command during
>> database shutdown than during normal operations. In particular, if
>> the normal archive process fails during norm
On Thu, 26 May 2016, 1:25 a.m. Jeff Janes, wrote:
> I've recently wanted to run a different archive_command during
> database shutdown than during normal operations. In particular, if
> the normal archive process fails during normal operations, I want it
> to be retried later (as it currently do
Scott Briggs wrote:
> So if you do need to use wal files to catch up a slave, what would
> that process be? If you caught up with wal files, how would streaming
> replication know what positon to start at? And how would you tell
> streaming replication the new position after catching up with wal
>
Thanks Laurenz for the response.
So if you do need to use wal files to catch up a slave, what would
that process be? If you caught up with wal files, how would streaming
replication know what positon to start at? And how would you tell
streaming replication the new position after catching up with
Scott Briggs wrote:
> Hi, can someone please explain the purpose of archive_command on both
> the master and slave when it comes to streaming replication? From
> what I understand so far, what really matters is how many pg_xlog
> files are kept when it comes to reestablishing replication when it
>
On Wed, Jun 2, 2010 at 3:47 AM, Jun Wang wrote:
> The document recommends a command as below:
>
> archive_command = 'test ! -f /var/lib/pgsql/backup_in_progress || cp
> -i %p /var/lib/pgsql/archive/%f < /dev/null'
>
> How can this be done using windows batch? I tried the following
> command, but i
Hi,
On Tue, Jun 1, 2010 at 8:47 PM, Jun Wang wrote:
> The document recommends a command as below:
>
> archive_command = 'test ! -f /var/lib/pgsql/backup_in_progress || cp
> -i %p /var/lib/pgsql/archive/%f < /dev/null'
>
> How can this be done using windows batch? I tried the following
> command,
The document recommends a command as below:
archive_command = 'test ! -f /var/lib/pgsql/backup_in_progress || cp
-i %p /var/lib/pgsql/archive/%f < /dev/null'
How can this be done using windows batch? I tried the following
command, but it did not work:
archive_command = 'if not exist C:\\pgsql\\b
Hello
In my environment,archive_command works fine with this command.
archive_command = 'COPY %p C:\\Program
Files\\PostgreSQL\\8.4\\data\\archive\\%f'
(Is this what you want to know?)
> Where can I find an example shell script and windows batch file for
> archive_command for backup?
>
> Tha
Jun Wang wrote:
> Where can I find an example shell script and windows batch file for
> archive_command for backup?
There are no examples. I can be any command you want, like 'COPY'.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
Martin Marques <[EMAIL PROTECTED]> writes:
> I have a question related to the archive_command option of postgresql.conf.
> In the documentation[1] I found examples that add a "< /dev/null" at the
> end of the cp command. I know what the redirection from /dev/null does
> (send an EOF), but is it r
On Thu, 6 Sep 2007, Eric Pailleau wrote:
so I wonder if we can use environnement variable directly or by sourcing an
env file, i.e :
archive_command = 'test ! -f $myvar/%f && cp %p $myvar/%f'
archive_command = 'csh ; source ~/.cshrc && test ! -f $myvar/%f && cp %p
$myvar/%f'
As far as I know
27 matches
Mail list logo
