Hi,
So the basebackup pulls the data directory over from the master.
I am pulling over anther copy of the data directory using basebackup
On 07/01/2015 05:51 PM, Andy Erskine wrote:
> If i grep for errors i get some invalid page header in block 56072 of
> relation base/16385/77373
If i grep for errors i get some invalid page header in block 56072 of
relation base/16385/77373 errors.
But not sure what else to look for ?
On 2 July 2015 at 10:41, Adrian Klaver wrote:
> On 07/01/2015 05:20 PM, Andy Erskine wrote:
>
>> I initially populated the directory using ba
I initially populated the directory using basebackup and pulled the data
directory across from the master.
On 2 July 2015 at 10:13, Adrian Klaver wrote:
> On 07/01/2015 05:04 PM, Andy Erskine wrote:
>
>> the cmd you listed did work it didn't like the -d option
>>
&
348K./archive_status
79G .
On 1 July 2015 at 23:59, Adrian Klaver wrote:
> On 07/01/2015 06:56 AM, Andy Erskine wrote:
>
>> /opt/database on both servers has been assigned 250gb only postgres has
>> been installed on them.
>>
>> I cannot get the output you requeste
I have db of 123GB Currently and this is streaming to a secondary DB which
also shows a size of 123GB (Using pgAdmin)
The db's both reside on a 250GB directorys and on the Master i'm using 60%
of capacity which seems expected
On the secondary i am using 88% of the disks capacity. I assume this is
Cheers all.
On 30 June 2015 at 15:58, John R Pierce wrote:
> On 6/29/2015 10:55 PM, Andy Erskine wrote:
>
>> agreed there is an element of risk.
>>
>> however a backup of the master will be carried out prior (ok there could
>> potentially be a gap of data during d
t; On Tue, Jun 30, 2015 at 2:29 PM, Andy Erskine
> wrote:
>
>> Ok so a question i should have asked at the very beginning ..
>>
>> If i touch my trigger file - promoting the secondary to a master - will
>> that in anyway effect the master thats already running ?
&
i've finished and
run the basebackup process again to restore replication (and change
recovery.done - conf again.
thanks.
On 30 June 2015 at 15:22, Michael Paquier wrote:
>
>
> On Tue, Jun 30, 2015 at 1:39 PM, Andy Erskine
> wrote:
>
>> No i don't want a replica.
ing.
When i've finished testing - i want to reconfigure for streaming again.
On 30 June 2015 at 12:37, Tomas Vondra wrote:
> Hi,
>
> On 06/29/2015 09:27 AM, Andy Erskine wrote:
>
>> Thanks Jeff,
>>
>> I don't want a clone - i want to temporaily turn
eral mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
*Andy Erskine*
*JDS Australia*
*P* 1300 780 432 | *M* 0431919301 | *F* 03 90124578
*E:* *andy.ersk...@jds.net.au *
*W*: www.jds.net.au
Level 8, 2 Russell Street, Melbourne, VIC 3000
GPO Box 4777, Melbourne VIC 3001
[image: JDS Signature v1]
:50, Michael Paquier wrote:
>
>
> On Mon, Jun 29, 2015 at 3:34 PM, Andy Erskine
> wrote:
>
>> no snapshot available .. i don't mind running basebackup once i've
>> finished my test.
>>
>> So if someone could help with the steps to turn off replica
es up.
>
>
>
> --
> john r pierce, recycling bits in santa cruz
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
*Andy
m the master and set up streaming again.
Just need to be certain of the right steps so i don't effect the Master in
any way.
On 29 June 2015 at 15:52, Michael Paquier wrote:
> On Mon, Jun 29, 2015 at 2:42 PM, Andy Erskine
> wrote:
> > I'd like to turn off the streaming o
I'd like to turn off the streaming on my postgresdb (9.2) It is currently
setup to stream from master to a single secondary.
I want to shutdown the secondary and turn it into another master and
connect it to another application for testing - after which i want to
revert it back to a streaming seco
14 matches
Mail list logo
