On Fri, Nov 1, 2019 at 01:58:10AM +0300, Олег Самойлов
wrote:
> Does anyone know PostgresQL proxy which can log queries with username,
> ip and affected rows for security reason. PostgresQL itself can log
> almost all, except affected rows.
You can use the server logs to get the non-row informatio
El día jueves, noviembre 07, 2019 a las 12:39:39p. m. +0100, Matthias Apitz
escribió:
>
> Hello,
>
> We're struggling with the following problem (here show in a simplified
> case).
>
> We have in a PG 11.4 database a table with two columns: SERIAL, VARCHAR(11).
>
> In the ESQL/C pgm the code
"Zwettler Markus (OIZ)" wrote on 2019/11/07
11:32:42 AM:
> From: "Zwettler Markus (OIZ)"
> To: Adrian Klaver , "pgsql-
> gene...@lists.postgresql.org"
> Date: 2019/11/07 11:33 AM
> Subject: [EXTERNAL] AW: AW: AW: broken backup trail in case of
> quickly patroni switchback and forth
>
> 3)
>
On Thu, 2019-11-07 at 13:52 +, Zwettler Markus (OIZ) wrote:
> we are using Patroni for management of our Postgres standby databases.
>
> we take our (wal) backups on the primary side based on intervals and
> thresholds.
> our archived wal's are written to a local wal directory first and moved
3)
Patroni does only failovers. Also in case of regular shutdown of the primary. A
failover is a promote of the standby + automatic reinstate (pg_rewind or
pg_basebackup) of the former primary.
Time: role site 1 - role site 2
12:00h: primary - standby
=> Some clients commite
On 2019-11-07 10:59:37 -0500, stan wrote:
> On Thu, Nov 07, 2019 at 07:52:14AM -0800, Adrian Klaver wrote:
> > On 11/7/19 7:45 AM, stan wrote:
> > > I am in the middle of a project, and it looks like version 12 is now what
> > > the Debian/Ubuntu package managers want to update to.
> >
> > This sh
On 11/7/19 7:47 AM, Zwettler Markus (OIZ) wrote:
I am heading out the door so I will not have time to look at below until
later. For those that get a chance before then, it would be nice to have
the Patroni conf file information also. The Patroni information may
answer the question, but it cas
On Thu, Nov 07, 2019 at 07:52:14AM -0800, Adrian Klaver wrote:
> On 11/7/19 7:45 AM, stan wrote:
> > I am in the middle of a project, and it looks like version 12 is now what
> > the Debian/Ubuntu package managers want to update to.
>
> This should be a dist-upgrade correct?
Correct.
>
> On a m
On Thu, 2019-11-07 at 10:45 -0500, stan wrote:
> I am in the middle of a project, and it looks like version 12 is now what
> the Debian/Ubuntu package managers want to update to.
>
> I of course, will do this first on a test machine, not the "production", or
> "develop,met" machines, but I though
On 11/7/19 7:45 AM, stan wrote:
I am in the middle of a project, and it looks like version 12 is now what
the Debian/Ubuntu package managers want to update to.
This should be a dist-upgrade correct?
On a my Ubuntu instance that just installed the Postgres 12 version and
started it(also auto s
1) 9.6
2)
$ cat postgresql.conf
# Do not edit this file manually!
# It will be overwritten by Patroni!
include 'postgresql.base.conf'
cluster_name = 'pcl_l702'
hot_standby = 'on'
hot_standby_feedback = 'True'
listen_addresses =
'localhost,tstm49003.tstglobal.tst.loc,pcl_l702.tstglobal.tst.loc
I am in the middle of a project, and it looks like version 12 is now what
the Debian/Ubuntu package managers want to update to.
I of course, will do this first on a test machine, not the "production", or
"develop,met" machines, but I thought i would solicit the group wisdom on
this.
Are there an
On 11/7/19 7:18 AM, Zwettler Markus (OIZ) wrote:
I already asked the Patroni folks. They told me this is not related to Patroni
but Postgresql. ;-)
Hard to say without more information:
1) Postgres version
2) Setup/config info
3) Detail if what happened between 12:00 and 12:10
- Markus
I already asked the Patroni folks. They told me this is not related to Patroni
but Postgresql. ;-)
- Markus
On 11/7/19 5:52 AM, Zwettler Markus (OIZ) wrote:
> we are using Patroni for management of our Postgres standby databases.
>
> we take our (wal) backups on the primary side based on inte
On Thu, 7 Nov 2019 16:02:21 +0100
Peter Eisentraut wrote:
> On 2019-11-05 17:05, Jehan-Guillaume de Rorthais wrote:
> >> I have simplified your reproduction steps from the previous message to a
> >> test case, and I can confirm that your proposed fix addresses the issue.
> >
> > Thanks for the
İlyas Derse schrieb am 07.11.2019 um 14:28:
> I'm trying to migration to PostgreSql from SQL Server. I have Stored
> Procedures what have output parameters and returning tables.But you
> know what, we can not returning tables in stored procedures in
> PostgreSql and we can not use output parameters
On 11/7/19 5:52 AM, Zwettler Markus (OIZ) wrote:
we are using Patroni for management of our Postgres standby databases.
we take our (wal) backups on the primary side based on intervals and thresholds.
our archived wal's are written to a local wal directory first and moved to tape
afterwards.
w
On 2019-11-05 17:18, Andres Freund wrote:
On 2019-11-05 16:02:51 +0100, Peter Eisentraut wrote:
$node_publisher->stop('fast');
+
+
+# TODO:
https://www.postgresql.org/message-id/flat/a9139c29-7ddd-973b-aa7f-71fed9c38d75%40minerva.info
+
+$node_publisher = get_new_node('publisher3');
+$node_pu
On 2019-11-05 17:05, Jehan-Guillaume de Rorthais wrote:
I have simplified your reproduction steps from the previous message to a
test case, and I can confirm that your proposed fix addresses the issue.
Thanks for the feedback and the test case. I wonder if ALTER SUBSCRIPTION
DISABLE/ENABLE is u
On 11/7/19 5:28 AM, İlyas Derse wrote:
I'm trying to migration to PostgreSql from SQL Server. I have Stored
Procedures what have output parameters and returning tables.But you know
what, we can not returning tables in stored procedures in PostgreSql and
we can not use output parameters in funct
I'm trying to migration to PostgreSql from SQL Server. I have Stored
Procedures what have output parameters and returning tables.But you know
what, we can not returning tables in stored procedures in PostgreSql and we
can not use output parameters in functions in PostgreSql.
So i did not find to s
we are using Patroni for management of our Postgres standby databases.
we take our (wal) backups on the primary side based on intervals and thresholds.
our archived wal's are written to a local wal directory first and moved to tape
afterwards.
we got a case where Patroni switched back and forth
On Wed, Nov 6, 2019 at 12:32 AM Matthias Apitz wrote:
> Hello,
>
> On our project roadmap to port our LMS (Library Management System) from
> Sybase/Oracle to PostgreSQL we are now in the phase of addressing the
> ESQL/C and C++ code parts (some million lines of code).
>
> I wrote a small ESQL/C te
Hello,
We're struggling with the following problem (here show in a simplified
case).
We have in a PG 11.4 database a table with two columns: SERIAL, VARCHAR(11).
In the ESQL/C pgm the code is:
EXEC SQL BEGIN DECLARE SECTION;
...
struct {
int ser;
Thanks. The problem is that the hunspell dictionary doesn't work with
unaccent so it is actually totally useless for languages with accents. If
one has to rely on stemming for words with accents, it is just a partial
solution and it is not the right solution.
Besides, the results returned by the h
25 matches
Mail list logo
