Hi,
I have a weird case when running a query on the pg_settings view.
I have two users, first one is the default user - postgres which is a
superuser and another one is a role which i had created, i called it
test_role and it's not a superuser.
When I run a select on pg_settings with these two us
Thank you Tatsuo for the Reply, I will post this in list you mentioned.
By Master-Master, I meant two pgpool servers both active accepting
connections from Application, If one Pgpool Server becomes unlavailable
other still accepting connections. At an Ideal time, both Pgpool instances
on each PgPo
Ronen Nofar wrote:
> I have a weird case when running a query on the pg_settings view.
> I have two users, first one is the default user - postgres which is a
> superuser
> and another one is a role which i had created, i called it test_role and it's
> not a superuser.
> When I run a select on p
Greetings,
* Laurenz Albe (laurenz.a...@cybertec.at) wrote:
> Ronen Nofar wrote:
> > I have a weird case when running a query on the pg_settings view.
> > I have two users, first one is the default user - postgres which is a
> > superuser
> > and another one is a role which i had created, i call
Does pg_basebackup on a remote machine follow the standard libpq protocol. I
am not able to force it to use ssl, despite having an entry in pg_hba.conf:
hostnossl all all all reject
>From the same remote machine, psql is forced to use ssl.
Makes me wonder whether pg_basebackup has a different p
Hello:
I have a problem with a record in a jsonb type table, I'm trying to
change the value of an attribute to null but it leaves me all the
content in null and not just the value, I show you an example first of
how to define the null attribute:
prueba=# select jsonb_build_object('v', null);
jso
> On 15 November 2017 at 22:54, RODRIGUEZ CORTES MARIO IGNACIO <
ignacio.cor...@inegi.org.mx> wrote:
>
> I have a problem with a record in a jsonb type table, I'm trying to
> change the value of an attribute to null but it leaves me all the
> content in null and not just the value
>
> prueba=# sele
Greetings,
Using PG 10.1.
In my .psqlrc I have:
\x auto
\pset linestyle 'unicode'
\pset unicode_header_linestyle double
and when the output is expanded, I do not see a double line for the first
record, but I do for all subsequent records. For example:
% select * from artist;
─[ RECORD 1 ]
I am not familiar with swarm cluster nor repmgr. So I wonder why you
wouldn't be able to get to the goal you are trying to achieve without
repmgr. Can you please elaborate more?
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.srao
Hi,
Thoughts and opinions on this please -
I have a db (data dir is 90gb) that I am trying to setup on a replication
slave. The slave is on a host which maintains latency over 300ms at all
times (wan link).
Other times I have done this setup, I have simply rsync'ed the data dir to
another host,
On 11/15/2017 6:02 PM, Rory Falloon wrote:
Right now I am trying to dump the database, gzip, move across, and
import into the new slave (which is configured as a master to perform
the initial setup). Ideally I do this dump, move and import during a
period of inactivity on the master so the ne
Thank you for that. Back to the drawing board!
On Wed, Nov 15, 2017 at 9:30 PM, John R Pierce wrote:
> On 11/15/2017 6:02 PM, Rory Falloon wrote:
>
>>
>> Right now I am trying to dump the database, gzip, move across, and import
>> into the new slave (which is configured as a master to perform th
On Tue, Nov 14, 2017 at 8:28 AM, Laurenz Albe
wrote:
> rakeshkumar464 wrote:
> > If pg_basebackup is run from a remote machine with compress option
> --gzip ,
> > compress level 9,
> > will the compression occur prior to the data being sent on the network or
> > after it has been received
> > at
Hi
2017-11-15 23:37 GMT+01:00 Matt Zagrabelny :
> Greetings,
>
> Using PG 10.1.
>
> In my .psqlrc I have:
>
> \x auto
> \pset linestyle 'unicode'
> \pset unicode_header_linestyle double
>
> and when the output is expanded, I do not see a double line for the first
> record, but I do for all subseq
I beleieve that every information system has the needs to send emails.
Currently PostgreSQL doesn't have a function which gets TEXT and return true if it's valid email address (x...@yyy.com / .co.ZZ)
Do you believe such function should exist in PostgreSQL or it's best to let every user to implement
15 matches
Mail list logo
