On Tue, Mar 10, 2020 at 12:23:49PM +0530, Sonam Sharma wrote:
> We have pg_read_all_stats role from v9.6. do we have a similar role for
> v9.5 and lower versions ?
No, and pg_read_all_stats has been introduced in Postgres 10, not 9.6:
https://www.postgresql.org/docs/10/release-10.html
--
Michael
Hello,
I have two servers connected to the same switch running postgres 11.5
I am trying to replicate one of those servers after a planned work on the
master, so the replica has been lost. It has always worked but now I get
this :
pg_basebackup: could not receive data from WAL stream: server clos
На пн, 9.03.2020 г. в 20:34 Andres Freund написа:
> You'd not have to take an ACCESS EXCLUSIVE. A lower level would
> suffice, e.g. SHARE UPDATE EXCLUSIVE, which still allows data changes.
>
> > There is nobody else doing DDLs except me - Mr. DBA, so I guess I am
> > safe on this side. ;)
>
> If
Now I have the same problem with a different message.
I´ve added a table on all schemas and did a refresh publication. when
postgres sees a new table on publisher he goes to replicamand trucates that
table to start copying. ok but I have 300 schemas, how can I know what
schema that table belongs to
Hello,
What returns when I run a query like this;
Select * from test where name like 'co_%';
I expect anything that starts with 'co_' and NOT 'co' only. Am I right? But I
get every names that starts with 'co'. Why ?
Happiness Always
BKR Sivaprakash
On Tue, Mar 10, 2020 at 12:49:01PM +, sivapostg...@yahoo.com wrote:
> Hello,
> What returns when I run a query like this;
> Select * from test where name like 'co_%';
> I expect anything that starts with 'co_' and NOT 'co' only. Am I right? But
> I get every names that starts with 'co'. Why
Hi,
an underscore matches a single character, any character. You'd have to
escape it and tell the query what the escape character is if you want
it to be treated as a standard character:
db=# create table t(t text);
CREATE TABLE
db=# insert into t(t) values ('fox'), ('fo_'), ('fo_x');
INSERT 0 3
Thanks. Got it.
On Tuesday, 10 March, 2020, 06:30:27 pm IST, Paul Foerster
wrote:
Hi,
an underscore matches a single character, any character. You'd have to
escape it and tell the query what the escape character is if you want
it to be treated as a standard character:
db=# create tab
On 3/10/20 5:16 AM, PegoraroF10 wrote:
Now I have the same problem with a different message.
I´ve added a table on all schemas and did a refresh publication. when
postgres sees a new table on publisher he goes to replicamand trucates that
table to start copying. ok but I have 300 schemas, how can
On 3/10/20 2:26 AM, Nicola Contu wrote:
Hello,
I have two servers connected to the same switch running postgres 11.5
I am trying to replicate one of those servers after a planned work on
the master, so the replica has been lost. It has always worked but now I
get this :
pg_basebackup: could
built in logical replication
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
Hi Team...I am trying to setup some monitoring over the PostgreSQL server
log. I am not clear which error I should be most concerned about. Could you
please share your thoughts on what pattern I should search in the log file?
On 2020-03-09 09:57:37 +0100, Laurenz Albe wrote:
> On Sun, 2020-03-08 at 21:13 +0100, Peter J. Holzer wrote:
> > But to be fair, a master/slave setup a la patroni isn't immune against
> > "writing junk" either: Not on the hardware level (either of the nodes
> > may have faulty hardware, and you ma
On 3/10/20 9:57 AM, Mageshwaran Janarthanam wrote:
Hi Team...I am trying to setup some monitoring over the PostgreSQL
server log. I am not clear which error I should be most concerned about.
Could you please share your thoughts on what pattern I should search in
the log file?
That really depe
On 3/10/20 8:42 AM, PegoraroF10 wrote:
built in logical replication
Well it does not do DDL replication so I am not sure how the new table
is getting to the replica?
It might help if you provide an start to end example of what you are doing.
--
Sent from: https://www.postgresql-archive.
On 3/10/20 8:17 AM, Nicola Contu wrote:
Please post to list also.
Ccing list.
What came immediately before the temporary file error?
2020-03-10 15:10:17 GMT [[local]] [28171]: [1-1]
db=postgres,user=postgres LOG: temporary file: path
"base/pgsql_tmp/pgsql_tmp28171.0", size 382474936
2020-0
16 matches
Mail list logo
