On Wed, Feb 14, 2018 at 07:47:55AM -0700, David G. Johnston wrote:
> Zero downtime is only possible by standing up a hot-standby then failing
> over to it. Same-server upgrade you can do via pg_upgrade but it does
> involve downtime. There are lots of material and options online, including
> the
On Sun, Feb 18, 2018 at 06:34:46PM -0600, Don Seiler wrote:
> Looking to use pgBackRest to take a backup from a hot standby. I'm reading
> that pgBackRest still needs to connect to the primary and copy some files.
> My questions are:
>
>
>1. What files does it need to copy? Config files? WAL
On Sun, Feb 18, 2018 at 06:48:30PM -0600, Don Seiler wrote:
> On Sun, Feb 18, 2018 at 6:43 PM, Michael Paquier wrote:
>> You may want to contact the maintainers directly through github where
>> the project is maintained:
>> https://github.com/pgbackrest/pgbackrest
>
>
On Mon, Feb 19, 2018 at 04:17:18PM -0500, Tom Lane wrote:
> Well, as far as I'm concerned the patch that was proposed there is
> far too fragile to be acceptable. We need to find out what the
> Microsoft-approved way of getting the information is. Assuming that
> we know the contents of non-expor
On Wed, Feb 21, 2018 at 07:56:38PM -0500, David Steele wrote:
> On 2/21/18 7:01 PM, Tom Lane wrote:
>> For pg_log, just put it somewhere else and set the appropriate
>> configuration option to say where to write the postmaster log files.
>> Or you could use a symlink, like the solution for pg_xlog,
On Thu, Feb 22, 2018 at 08:00:45PM -0500, Demitri Muna wrote:
> Ah, I wasn’t aware of implicit coercion. Yes, that solves the problem
> perfectly, thanks.
>
> Out of curiosity, how does one read a numeric type from within a C
> extension (i.e. get a number value out of the Datum type)? I ask as I
On Sun, Feb 25, 2018 at 09:06:39PM -0800, Adrian Klaver wrote:
> On 02/25/2018 08:36 PM, Konstantin Izmailov wrote:
>> I wonder if I'm not doing smth right, or libpq is not compatible with
>> openssl 1.1? Please help.
The answer to the second question is that libpq is compatible with
OpenSSL 1.1.0
On Mon, Feb 26, 2018 at 12:30:38AM -0700, Konstantin Izmailov wrote:
> Let me ask this differently: can Visual Studio 2013/2017 compile libpq with
> openssl 1.1 support? Under Windows?
The answer to this question should be yes. (Please note that no
Windows buildfarm machines use openssl 1.1.0 as
On Fri, Dec 06, 2024 at 04:44:29PM +0100, Erik Wienhold wrote:
> Another possibility is that the session just disabled compute_query_id:
> https://postgr.es/m/472115375.225506.1683812791906%40office.mailbox.org
Or possibly this uses a path where we're not aggressive enough the
query ID while we sh
On Mon, May 19, 2025 at 09:07:35AM +0200, Daniel Verite wrote:
> That looks normal. The unicity to expect is on
> (queryid, userid, dbid, toplevel).
>
> From https://www.postgresql.org/docs/current/pgstatstatements.html :
>
> This view contains one row for each distinct combination of database
On Tue, Jul 01, 2025 at 10:24:14AM +0300, Maksim Gorkov wrote:
> 2064869707185898531;'BEGIN;...' -- the full text in query1.sql attachment
> 2064869707185898531;'COMMIT;'
>
> there is another example, if required I can send it for review.
>
> Why does this happen and how can it be fixed?
Hard to
301 - 311 of 311 matches
Mail list logo
