Re: [GENERAL] streaming replication and archive_status

2017-04-18 22:46 GMT-03:00 Jeff Janes : > On Tue, Apr 18, 2017 at 5:20 AM, Luciano Mittmann > wrote: > >> >> >> Hi Jeff, >> >> **Does each file in pg_xlog/archive_status/ have a corresponding file >> one directory up? >> >> no correspond

Re: [GENERAL] streaming replication and archive_status

2017-04-17 20:04 GMT-03:00 Jeff Janes : > 2017-04-17 17:08 GMT-03:00 Jeff Janes : > >> On Mon, Apr 17, 2017 at 12:22 PM, Luciano Mittmann >> wrote: >> >>> Hi All, >>> >>> anyone knows why there are so many files in the director

Re: [GENERAL] streaming replication and archive_status

kB, estimate=226109 kB thanks, 2017-04-17 17:24 GMT-03:00 Luciano Mittmann : > Hi Jeff, > > checkpoint message on standby node: > > [ 2017-04-17 17:21:56 BRT] @ LOG: restartpoint complete: wrote 21475 > buffers (2.6%); 0 transaction log file(s) added, 0 removed, 0 recycled;

Re: [GENERAL] streaming replication and archive_status

PM, Luciano Mittmann > wrote: > >> Hi All, >> >> anyone knows why there are so many files in the directory >> pg_xlog/archive_status/ in replication server? >> >> # pg_xlog/archive_status/ | wc -l >> >> 75217 >> >> Is possible to clean th

[GENERAL] streaming replication and archive_status

Hi All, anyone knows why there are so many files in the directory pg_xlog/archive_status/ in replication server? # pg_xlog/archive_status/ | wc -l 75217 Is possible to clean this .done files or just don't need to worry ? It's not occurs on primary or standalone servers, just on replication. T

[GENERAL] Pgadmin access to Postgresql

i'm tryng to access to a db that is on a my server. The port is 5432 open and accept tcp/ip connections. Server doesn't listen The server doesn't accept connections: the connection library reports could not connect to server: Connection refused (0x274D/10061) Is the server running on host "I

[GENERAL]

I stop the postmaster service and then i copy the directory in an other place. Restart the postmaster and then test someting modifications. Then i stop the service and restore the saved data directory Now the postmaster dont start any more Wy?   Cucchi Luciano C.R.A.E.M. sncVia E.De Nicola

R: [GENERAL] find last day of month

ick is to split it into year and month, add 1 to the >> month, if that's > 12, jump to 1, and add a year. >> >> Based on those... Construct the first day of the NEXT month. Try this (my date is current_date): select date_trunc('month', current_date + '1 mont

R: [GENERAL] ANAL SEX FUCK my WHITE ASSHOLE

kick-off this piece of shit ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

R: [GENERAL] Count Issues

SELECT COUNT(*) from mytable --- Bastianello Luciano Software Consultant - Apprentice Sorcerer e-mail: [EMAIL PROTECTED] e-mail: [EMAIL PROTECTED] ICQ: 209754422 - MSN: [EMAIL PROTECTED