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
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 standby for it. First step is to get W
> 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
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
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] LOG: archive command failed
with exit code 12017-08-18 18:34:25.057
We are running a PITR tests on Postgresql 9.5.4 (moving up from 9.1.18) and
finding that postgres seems to be archiving an invalid WAL (full of nulls)
in cases when a WAL is preallocated on shutdown. Don't see this issue
without preallocation during restartpoint. We use this process on 9.1.18
and
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
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 does). But if it fails during
shutdown, I want it to run a fa
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
>
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
breaks for some reason.
Let'
hi
was testing an idea with pg 8.2.19
generally, I had master and slave, wal archiving set in both of them,
but when slave was slave, it didn't archive any wal segments. which is
fine.
*but*
when I finished slave recovery, it went online, but it didn't start
automatically the archiving process.
i
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
Where can I find an example shell script and windows batch file for
archive_command for backup?
Thanks.
Jack
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
When setting archive_command in postgresql.conf to something different
than '', in other words, not empty, does it mean that archiving will
be attempted periodically since postgresql starts or just when doing
pg_start_backup and pg_stop_backup?
I just use archived files for recovery process w
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
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 really needed? In [2] there are examples that
don
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
Dear all,
In Postgresql documentation we have an example of the directive archive_command
(for WAL) :
archive_command = 'cp -i %p /mnt/server/directory_archive/%f
37 matches
Mail list logo
