On 2/26/19 8:10 PM, Martin Mueller wrote:
Thank you for the prompt and clear answer. I work with a Mac (OS 10.4.3) and I
used the PostgresApp to install it. I am a very primitive user of Postgres and
think of it as Microsoft Access on Steroids. I access it via Aqua Data, Studio,
but I don't th
On 2/26/19 7:51 PM, Martin Mueller wrote:
I run Postgres 10.5. I understand that there is something called
tablefunc and it includes a crosstab function. On Stack Overflow I learn
that you import this function. But from where and how? The Postgres
documentation is quite clear and intelligib
On 2/26/19 6:10 PM, Martin Mueller wrote:
Thank you for the prompt and clear answer. I work with a Mac (OS 10.4.3) and I
used the PostgresApp to install it. I am a very primitive user of Postgres and
think of it as Microsoft Access on Steroids. I access it via Aqua Data, Studio,
but I don't th
Thank you for the prompt and clear answer. I work with a Mac (OS 10.4.3) and I
used the PostgresApp to install it. I am a very primitive user of Postgres and
think of it as Microsoft Access on Steroids. I access it via Aqua Data, Studio,
but I don't think that makes any difference
On 2/26/19,
> "Martin" == Martin Mueller writes:
Martin> I run Postgres 10.5. I understand that there is something
Martin> called tablefunc and it includes a crosstab function. On Stack
Martin> Overflow I learn that you import this function. But from where
Martin> and how? The Postgres documentation
On 2/26/19 5:51 PM, Martin Mueller wrote:
I run Postgres 10.5. I understand that there is something called
tablefunc and it includes a crosstab function. On Stack Overflow I learn
that you import this function. But from where and how? The Postgres
documentation is quite clear and intelligible
I run Postgres 10.5. I understand that there is something called tablefunc and
it includes a crosstab function. On Stack Overflow I learn that you import this
function. But from where and how? The Postgres documentation is quite clear
and intelligible to a retired English professor like me, bu
On 2/26/19 2:40 PM, Julie Nishimura wrote:
Hello everybody,
I've inherited big complicated postgresql kingdon with multiple servers
in it, some of them are replicated, some of them are not, and there is
Bunch of them.
What would you be your suggestion, how should I start my investigation
wha
Ouch. I'm sure others will have ideas to add but here are a few to start
with. I would start by cataloging the instances. I hope you at least have a
list of the servers - if not you may need to do network scans with nmap and
even then may not locate all of them.
On each instance I'd use some combi
Hello everybody,
I've inherited big complicated postgresql kingdon with multiple servers in it,
some of them are replicated, some of them are not, and there is Bunch of them.
What would you be your suggestion, how should I start my investigation what is
master, what is replicas, is there any slo
On Tue, Feb 26, 2019 at 10:04:35AM -0500, Tom Lane wrote:
> Peter Eisentraut writes:
>> I tried reproducing the issue locally, but the required OpenSSL version
>> is too old to be easily available.
>
> Hm, I've got buildfarm hosts with quite old OpenSSLs handy. What
> tests do you want done, exa
Thomas Munro writes:
> On Wed, Feb 27, 2019 at 3:57 AM Tom Lane wrote:
>> If pthread_is_threaded_np(), or something equivalent, is widely available
>> then it might be all right to try solving this going forward by switching
>> to libldap_r and seeing if anyone hits those cross-checks. I'd be af
On Wed, Feb 27, 2019 at 3:57 AM Tom Lane wrote:
> Thomas Munro writes:
> > Question
> > for the list: other stuff in the server needs libpthread (SSL, LLVM,
> > ...), so why are we insisting on using non-MT LDAP?
>
> The traditional reason for avoiding that is the risk of a server
> process becom
On Tue, Feb 26, 2019 at 2:39 AM Andres Freund wrote:
>
> > 2. base backup is transferred directly to new server using
> > pg_start_backup + rsync + pg_stop_backup.
>
I excluded contents of pg_xlog only. Exact command was:
# start script
psql -Xc "select pg_start_backup('mirror to $standby', true
On Mon, Feb 25, 2019 at 11:45 PM Stephen Frost wrote:
>
> Greetings,
>
> * Filip Rembiałkowski (filip.rembialkow...@gmail.com) wrote:
> > There is a large (>5T) database on PostgreSQL 9.0.23.
>
> First off, I hope you understand that 9.0 has been *long* out of
> support and that you *really* need
Peter Eisentraut writes:
> I tried reproducing the issue locally, but the required OpenSSL version
> is too old to be easily available.
Hm, I've got buildfarm hosts with quite old OpenSSLs handy. What
tests do you want done, exactly?
regards, tom lane
Thomas Munro writes:
> Question
> for the list: other stuff in the server needs libpthread (SSL, LLVM,
> ...), so why are we insisting on using non-MT LDAP?
The traditional reason for avoiding that is the risk of a server
process becoming multi-threaded. There are live bugs of that ilk
on Darwin
On 2019-02-22 06:28, Michael Paquier wrote:
>> Is that right? Won't we then just select nothing if the macro is not
>> defined?
> In the context of an SSL connection, the server would send both SCRAM
> and SCRAM_PLUS as valid mechanisms if it supports channel binding
> (HAVE_BE_TLS_GET_CERTIFICATE
On 26 February 2019 10:41:19 CET, Sonam Sharma wrote:
>Hi,
>
>Can we do master to master replication in Postgres.
>
Not in core, but with BDR.
Andreas
--
2ndQuadrant - The PostgreSQL Support Company
Greetings Mike,
* Mike Yeap (wkk1...@gmail.com) wrote:
> Hi Thomas, I see. guess I can't use LDAP authentication for now, :-(
If you're in an active directory environment, you should really be using
Kerberos for authentication and NOT LDAP anyway. LDAP-based
authentication involves sending t
> On Feb 26, 2019, at 9:41 AM, Sonam Sharma wrote:
>
> Hi,
>
> Can we do master to master replication in Postgres.
Look at https://bucardo.org/Bucardo/ , BDR (e.g.
https://www.2ndquadrant.com/en/resources/postgres-bdr-2ndquadrant/ ), RubyRep
or any of the other multimaster solutions at
ht
No - because there's no "out-of-the box" solution that creates two
replicas, both writable. It's said on
https://www.postgresql.org/docs/11/different-replication-solutions.html
Yes - because with current postgres features (logical rep, partitions,
foreign tables, ...) you can create solutions that
On Tue, Feb 26, 2019 at 9:11 PM Thomas Munro wrote:
> On Tue, Feb 26, 2019 at 8:17 PM Mike Yeap wrote:
> > Hi Thomas, does that mean the bug is still there?
> I haven't tried to repro this myself, but it certainly sounds like it.
> It also sounds like it would probably go away if you switched to
Hi,
Can we do master to master replication in Postgres.
Regards,
Sonam
Hi Thomas, I see. guess I can't use LDAP authentication for now, :-(
Hopefully this problem is solved in future version, thank you!
Regards,
Mike Yeap
On Tue, Feb 26, 2019 at 4:12 PM Thomas Munro wrote:
> On Tue, Feb 26, 2019 at 8:17 PM Mike Yeap wrote:
> > Hi Thomas, does that mean the b
Problem "solved".
"found" will be true of false depending on the trigger action.
update done -> found = true, update not done -> found=false.
But: The trigger sometimes allows updates where no data has been
changed! That is another problem to be solved :(
Regards
walter
Am 25.02.19 um 19:42 s
On Tue, Feb 26, 2019 at 8:17 PM Mike Yeap wrote:
> Hi Thomas, does that mean the bug is still there?
Hi Mike,
I haven't tried to repro this myself, but it certainly sounds like it.
It also sounds like it would probably go away if you switched to a
Debian-derived distro, instead of a Red Hat-deri
27 matches
Mail list logo
