Please dont top-post.
On 14/9/19 9:41 π.μ., Ayub M wrote:
Yes I did set that, here is how pgbouncer looks like ---
-rwsrwsr-x. 1 root root 2087504 Sep 13 00:45 pgbouncer
If you had set the same password in the postgresql server for the user and in
the pgbouncer local unix user it should wo
Hi everyone,
My name is Natalia, I'm a PhD student and I'm currently looking into the
performance of queries on nested relations (expressed with arrays and UDT
in Postgres).
Now I'm trying to figure out the problem and find some good examples. If
you've ever had any problems with these kinds of q
On Sat, 14 Sep 2019 10:00:18 -0500, Ron
wrote:
>On 9/14/19 9:54 AM, Tom Lane wrote:
>[snip
>> The only mention of this feature in 38.1 "Overview of Trigger Behavior"
>> is
>>
>> UPDATE triggers*can* moreover be set to fire only if certain columns
>> are mentioned in the SET clause of t
on linux, pg11.3, i have a (declarative) partitioned table with a
deadlock that i do not understand. one process does a copy to the
partitioned table. another process is executing a jdbc batch of commands
to "atomically" replace one of the table partitions. it has the
following commands (autoco
On Mon, Sep 16, 2019 at 12:12:34AM -0400, Tom Lane wrote:
> stan writes:
> > On Sun, Sep 15, 2019 at 12:27:14PM -0700, Adrian Klaver wrote:
> >> On 9/15/19 10:46 AM, stan wrote:
> >>> So, my test tell me that the validity check is done BEFORE an attempt to
> >>> insert (thus firing the trigger) oc
I am using Postgresql's logical replication in my application with the
test_decoding plugin. I am trying to understand the difference between
replication protocol and replication functions provided by Postgresql.
Specifically, CREATE_REPLICATION_SLOT call returns a snapshot name, but
pg_create_logi
On 9/16/19 11:52 AM, stan wrote:
On Mon, Sep 16, 2019 at 12:12:34AM -0400, Tom Lane wrote:
stan writes:
On Sun, Sep 15, 2019 at 12:27:14PM -0700, Adrian Klaver wrote:
On 9/15/19 10:46 AM, stan wrote:
So, my test tell me that the validity check is done BEFORE an attempt to
insert (thus firing
On Mon, Sep 16, 2019 at 12:44:49PM -0700, Adrian Klaver wrote:
> On 9/16/19 11:53 AM, stan wrote:
> > On Sun, Sep 15, 2019 at 09:16:35PM -0700, Adrian Klaver wrote:
> > > On 9/15/19 6:04 PM, stan wrote:
> > > > On Sun, Sep 15, 2019 at 12:27:14PM -0700, Adrian Klaver wrote:
> > > > > On 9/15/19 10
Please don't cross-post your question to more than one list!
Ashkar Dev wrote:
> Can anyone explain the PostgreSQL License to me?
> Can I create a database with it and sell the database also preventing
> the buyer from reselling it?
> Can I change in the logos of the PostgreSQL system and its name
Hi all,
I've been debugging an intermittent foreign key insert error on our
single database / multi-tenant server. To help isolate traffic by
tenant, I've switched to using csvlog and for the duration and have set
log_min_duration_statement to 0 to get *everything*. Fortunately, daily
80G c
On 9/16/19 1:46 PM, Jeff Ross wrote:
Hi all,
I've been debugging an intermittent foreign key insert error on our
single database / multi-tenant server. To help isolate traffic by
tenant, I've switched to using csvlog and for the duration and have set
log_min_duration_statement to 0 to get *e
On 9/16/19 4:07 PM, Adrian Klaver wrote:
On 9/16/19 1:46 PM, Jeff Ross wrote:
The csvlog snip shows what I believe are 2 simultaneous but separate
sessions and the session that attempts to insert into the cargo_det
table is not the same session that inserted into the load_det table.
That's
On 9/16/19 12:55 PM, stan wrote:
On Mon, Sep 16, 2019 at 12:44:49PM -0700, Adrian Klaver wrote:
On 9/16/19 11:53 AM, stan wrote:
On Sun, Sep 15, 2019 at 09:16:35PM -0700, Adrian Klaver wrote:
On 9/15/19 6:04 PM, stan wrote:
On Sun, Sep 15, 2019 at 12:27:14PM -0700, Adrian Klaver wrote:
On 9
On 9/16/19 3:16 PM, Jeff Ross wrote:
On 9/16/19 4:07 PM, Adrian Klaver wrote:
On 9/16/19 1:46 PM, Jeff Ross wrote:
The csvlog snip shows what I believe are 2 simultaneous but separate
sessions and the session that attempts to insert into the cargo_det
table is not the same session that ins
Hi,
In order to do this, do I create a new stanza in config file which has
pg1-path point to the new/empty directory structure while still pointing to
the existing backup directory, and restore that stanza?
Thanks
--
Angular momentum makes the world go 'round.
Hi Team,
Not able to create the extension pldbgapi in cluster and if i run make and
make install it will going .sql file in /usr/share/pgsql/extension this
path but actually i need to create these files into below path,
How to create this one please advise
==> psql
psql (11.5)
Type "help" for
16 matches
Mail list logo
