Re: [GENERAL] Tunning Server 9.1.

2016-08-04 Thread John R Pierce
On 8/4/2016 2:02 PM, Periko Support wrote: I read some sites on google that it was related to this settings. Can u share your experience on this logs? what you said earlier has nothing to do with what you're saying now. original: I have server that hras increase users and need to increase

Re: [GENERAL] Streaming Replica Master-Salve Config.

2016-08-04 Thread Ian Barwick
On 8/5/16 12:35 AM, Periko Support wrote: > Hi. > > I'm testing streaming replica with ubuntu 14 and psql9.3. > > I'm trying to understand how this works, my plan is to setup the > slave server for pentaho reports for queries only. > > Now, my master server it has 128GB max_connections =

Re: [GENERAL] Tunning Server 9.1.

2016-08-04 Thread Patrick B
@John R Pirce, on a 128GB ram system, I would probably have shared_buffers up around 4-8GB. I'm using shared_buffer = 52GB in a 128GB RAM server :O

Re: [GENERAL] Tunning Server 9.1.

2016-08-04 Thread Periko Support
I read some sites on google that it was related to this settings. Can u share your experience on this logs? On Thu, Aug 4, 2016 at 11:17 AM, John R Pierce wrote: > On 8/4/2016 6:01 AM, Periko Support wrote: >> >> This was my message: >> >> PDT FATAL: remaining connection

Re: [GENERAL] Question about wal files / pg_xlogs

2016-08-04 Thread Patrick B
> > > And the time difference is on ALL slaves, or just the two in a different > country? > > > All of them! :(

Re: [GENERAL] Question about wal files / pg_xlogs

2016-08-04 Thread Melvin Davidson
On Thu, Aug 4, 2016 at 4:32 PM, Patrick B wrote: > >>> >> Just out of curiostity, are the slaves in the same physical location, or >> by some chance are they on a remote site? >> >> >> > two of them in the same physical location, and the other two different > country. >

Re: [GENERAL] Question about wal files / pg_xlogs

2016-08-04 Thread Patrick B
> > >> > Just out of curiostity, are the slaves in the same physical location, or > by some chance are they on a remote site? > > > two of them in the same physical location, and the other two different country.

Re: [GENERAL] Question about wal files / pg_xlogs

2016-08-04 Thread Melvin Davidson
On Thu, Aug 4, 2016 at 4:16 PM, Patrick B wrote: > >>> >> https://www.postgresql.org/docs/9.5/static/continuous-archiv >> ing.html#BACKUP-ARCHIVING-WAL >> >> "However, archive_command can be changed with a configuration file >> reload." >> >>

Re: [GENERAL] Question about wal files / pg_xlogs

2016-08-04 Thread Adrian Klaver
On 08/04/2016 01:16 PM, Patrick B wrote: https://www.postgresql.org/docs/9.5/static/continuous-archiving.html#BACKUP-ARCHIVING-WAL "However, archive_command can be changed with a

Re: [GENERAL] Question about wal files / pg_xlogs

2016-08-04 Thread Patrick B
> > >> > https://www.postgresql.org/docs/9.5/static/continuous-archiv > ing.html#BACKUP-ARCHIVING-WAL > > "However, archive_command can be changed with a configuration file reload." > > Cheers... I removed the IONICE command from the archive_command. However, did not

Re: [GENERAL] Question about wal files / pg_xlogs

2016-08-04 Thread Adrian Klaver
On 08/04/2016 12:55 PM, Patrick B wrote: @Adrian, Seems to me the settings for nice and ionice above would, on a busy machine, slow down the transfer. Has there always been a notable time difference in the transfer or has it gotten worse over time? Yep... I also thought about

Re: [GENERAL] Question about wal files / pg_xlogs

2016-08-04 Thread Patrick B
@Adrian, > Seems to me the settings for nice and ionice above would, on a busy > machine, slow down the transfer. Has there always been a notable time > difference in the transfer or has it gotten worse over time? > > Yep... I also thought about that. Specially because the master is constantly

Re: [GENERAL] Tunning Server 9.1.

2016-08-04 Thread John R Pierce
On 8/4/2016 6:01 AM, Periko Support wrote: This was my message: PDT FATAL: remaining connection slots are reserved for non-replication superuser connections you said you got a message about shared memory ?? thats nothing to do with this ? -- john r pierce, recycling bits in santa

Re: [GENERAL] Streaming Replica Master-Salve Config.

2016-08-04 Thread Eduardo Morras
On Thu, 4 Aug 2016 08:35:37 -0700 Periko Support wrote: > Hi. > > I'm testing streaming replica with ubuntu 14 and psql9.3. > > I'm trying to understand how this works, my plan is to setup the > slave server for pentaho reports for queries only. > > Now, my

[GENERAL] Streaming Replica Master-Salve Config.

2016-08-04 Thread Periko Support
Hi. I'm testing streaming replica with ubuntu 14 and psql9.3. I'm trying to understand how this works, my plan is to setup the slave server for pentaho reports for queries only. Now, my master server it has 128GB max_connections = 200 maybe I will add more. shared_memory=18GB. My slave

Re: [GENERAL] Question on table inheritance and privileges

2016-08-04 Thread Adrian Klaver
On 08/02/2016 09:35 PM, 윤기태 wrote: Dear pgsql-general, I found something strange with DROP TABLE CASCADE. Not really, explanation inline below. create role a login; grant all on database mydb to a; create role b inherit role a login; grant all on database mydb to b; The above leads to

Re: [GENERAL] Question about wal files / pg_xlogs

2016-08-04 Thread Adrian Klaver
On 08/03/2016 07:59 PM, Patrick B wrote: Both machines have same timezone? Yes! Shouldn't be showing 2 hours before.. I just checked and both server has the same date / timezone How fast are you generating WALs? Check below please checkpoint_segments = 64

Re: [GENERAL] upgrade to repmgr3

2016-08-04 Thread Ian Barwick
Hi On 08/04/2016 05:57 PM, Pekka Rinne wrote: hi! I have been using postgres 9.4 and repmgr2.0 combination and been doing replication (hot standby). Now I'd like to start doing slot based replication and have installed repmgr3 and exeuted the provided sql scripts and also added

Re: [GENERAL] Tunning Server 9.1.

2016-08-04 Thread Periko Support
This was my message: PDT FATAL: remaining connection slots are reserved for non-replication superuser connections Reading about, some points to max_connections because we have increase users on the network, I tought has sense. In 2 weeks will upgrade to ubuntu 14+psql 9.3 The docs say 25% of

[GENERAL] upgrade to repmgr3

2016-08-04 Thread Pekka Rinne
hi! I have been using postgres 9.4 and repmgr2.0 combination and been doing replication (hot standby). Now I'd like to start doing slot based replication and have installed repmgr3 and exeuted the provided sql scripts and also added use_replication_slots=1 into repmgr.conf. The question is that

Re: [SPAM] Re: [SPAM] Re: [GENERAL] WAL directory size calculation

2016-08-04 Thread Francisco Olarte
Hi Moreno: On Wed, Aug 3, 2016 at 1:07 PM, Moreno Andreo wrote: It's already been answered, but as it seems to be answering a chunk of my mail... > Should I keep fsync off? I'd think it would be better leaving it on, right? Yes. If you have to ask wether fsync should

Re: [GENERAL] Tunning Server 9.1.

2016-08-04 Thread John R Pierce
On 8/3/2016 10:13 PM, Periko Support wrote: This send me a message about shared_memory need to lower the value which default settings = 24MB. what message was this, exactly ? on a 128GB ram system, I would probably have shared_buffers up around 4-8GB. btw, postgres 9.1 is getting on in

Re: [GENERAL] Question about wal files / pg_xlogs

2016-08-04 Thread John R Pierce
On 8/3/2016 7:59 PM, Patrick B wrote: *postgresql.conf:* archive_command = 'exec nice -n 19 ionice -c 2 -n 7 archive_command.bash "%p" slave01 slave02' *archive_command.bash:* Basically we use TAR to ship through ssh: # we use tar over SSH as I don't fully trust scp's exit