Hello,
I am trying to use the INSERT ON CONFLICT syntax to build an SCD 2 table
loader.
here are the behaviors I need to achieve:
SCD 2 table: TAB_OUT
new candidate records: TAB_IN
The table TAB_IN contains the new candidate records to be submitted to
TAB_OUT.
*Case 1*: The record presented by T
John R Pierce wrote:
> On 2/12/2016 5:20 AM, Lesley Kimmel wrote:
>> Thanks for the reply Laurenz. Of course the first thing that I thought
>> of to prevent man-in-the-middle was SSL. However, I also like to try
>> to address the issue in a way that seems to get at what they are
>> intending. It se
LJK, Firstly thanks for bring this topic up. As many companies have to handle
attacks on their network.
Adrian thanks for the links specially the one covering connection pooling in
the first link. Answered by Pavel Stehule .
Definitely something to avoid.
I have done a fair bit of work on se
It installed poppler successfully but still gives the same error. I did
notice that it installed libpoppler 37 and the postgis2_93 install error
seems to be looking for version 5
[root@ip-user]# ls /usr/lib64/libpo*
/usr/lib64/libpoppler-cpp.so/usr/lib64/libpoppler.so
/usr/lib64/libpoppler
Tom Lane wrote:
> Alvaro Herrera writes:
> > Mart�n Marqu�s wrote:
> >> This really gives little use for recovery_target_xid. :(
>
> > Hmm, you can still use pg_xlogdump to figure it out from the actual WAL,
> > which has the correct XIDs. It's obviously a worse solution though from
> > the user
Hello,
Are u sur that it's not a network issue ?
Maybe just try to telnet or check your ec2 security group.
Pierre
*Pierre HILBERT*
*Database Responsible | Decatec*
*Phone : +33 6 67 63 54 87*
On Sun, Feb 7, 2016 at 10:35 PM, Augori wrote:
> Thanks for the reply. Yes, it seems that you're r
Some years ago, while working at Computer Associates as a tech support
specialist for the Ingres database, I wrote a short article to explain the
proper use of Group and Userss in the database. I thought it would be
worthwhile to do the same for PostgreSQL, as I've seen a lot of cases where
this wa
Two quick questions
1. How do you determine if you have a healthy database?
2. It needs to be healthy before rebooting correct?
Thanks
Greg
Greg Thompson
Sr. Database Administrator
Redflex Traffic Systems, Inc.
4402 W. Calle Lejos
Glendale, AZ 85310 USA
Ph: +1 (623) 207-2227
Ce
Hello Everyone,
I want to upgrade PostgreSQL 9.1 to PostgreSQL 9.4, currently my database
hold millions of records, shall anyone please help me the recommend steps to
upgrade my servers without any technical impact.
Thanks In Advance.
--
View this message in context:
http://postgresql.nabble
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Sterpu Victor
Sent: Friday, February 12, 2016 10:38 AM
To: PostgreSQL General
Subject: [GENERAL] Windows performance
Hello
Why is Postgres so slow on Windows compared to linux?
Can I do something
I was able to create all the domains, tables, views, etc, but I have
trouble creating stored procedures and triggers. Also, a question, does
Postgres support events, for example in Firebird I could do something like
this and then receive the event in the GUI:
if ((NEW.MUSED_M_>=NEW.MLIMIT_M_) an
On Tue, Feb 9, 2016 at 1:57 AM, subhan alimy wrote:
> Hello Everyone,
>
> I want to upgrade PostgreSQL 9.1 to PostgreSQL 9.4, currently my database
> hold millions of records, shall anyone please help me the recommend steps
> to
> upgrade my servers without any technical impact.
>
> Thanks In Adv
On 02/08/2016 04:28 PM, Gregery L. Thompson wrote:
Two quick questions
1.How do you determine if you have a healthy database?
I would say start by looking at the database logs. If you are seeing
FATAL and PANIC errors something is not happy.
A lot of this depends on what you consider health
2016-02-15 15:40 GMT-02:00 Melvin Davidson :
>
>
> On Tue, Feb 9, 2016 at 1:57 AM, subhan alimy wrote:
>
>> Hello Everyone,
>>
>> I want to upgrade PostgreSQL 9.1 to PostgreSQL 9.4, currently my database
>> hold millions of records, shall anyone please help me the recommend steps
>> to
>> upgrade
On 02/15/2016 01:54 AM, Johann Kerdal wrote:
Hello,
I am trying to use the INSERT ON CONFLICT syntax to build an SCD 2 table
loader.
here are the behaviors I need to achieve:
SCD 2 table: TAB_OUT
new candidate records: TAB_IN
The table TAB_IN contains the new candidate records to be submitted
Hi;
Today I ran into a question from a client as to why an index was not used.
The index had been freshly created and was on a relatively small table (16k
live rows, but 300k dead tuples). The resulting sequential scan was taking
half a second.
I found that even when setting enable_seqscan to of
Hi,
Just checked my RHEL 6 and RHEL 7 boxes. RHEL 6 provides libpoppler.so.5, and
RHEL 7 provides libpoppler.so.46 . I cannot find any reference to .37 :( Where
did you get it from?
I am not an Amazon AMI user -- is your version based on RHEL 6 or RHEL 7?
Regards, Devrim
On Mon, 2016-02-15 at
Hi Devrim,
I was told that "The amazon linux is compatible with Centos 6.x". Does
that correspond to RHEL 6? Is there a command I could use to find
out?
Is there a way I can force yum to install the RHEL 6 version?
Thank you,
Augori
On Mon, Feb 15, 2016 at 3:26 PM, Devrim GÜNDÜZ wrote:
Hi All,
I have managed to make npgsql with EF6 to work under asp.net5.
Let me if you needs the info as to how to set it up.
Best Regards
Farjad
On 2/15/2016 12:41 PM, Augori wrote:
I was told that "The amazon linux is compatible with Centos 6.x".
Does that correspond to RHEL 6? Is there a command I could use to
find out?
Is there a way I can force yum to install the RHEL 6 version?
I saw .el6. in several of your RPMs on an ea
I was told that "The amazon linux is compatible with Centos 6.x". Does that
correspond to RHEL 6? Is there a command I could use to find out?
Not quite.
Amazon Linux is RHEl/CentOS/Fedora derived, but it's not based on exactly
RHEl/CentOS 6 or
exactly RHEl/CentOS 7.
This is its current
Hello all,
I can't find any clear description of how to reliably figure and/or
enforce specific row (locking) order within UPDATE and SELECT FOR UPDATE
statements dealing with multiple rows.
I'd like to get rid of some deadlocks (caused by share locks). While the
manual explains locks and dead
On 02/15/2016 02:17 PM, Nikolai Zhubr wrote:
Hello all,
I can't find any clear description of how to reliably figure and/or
enforce specific row (locking) order within UPDATE and SELECT FOR UPDATE
statements dealing with multiple rows.
I'd like to get rid of some deadlocks (caused by share locks
On Mon, Feb 15, 2016 at 3:17 PM, Nikolai Zhubr wrote:
> Hello all,
>
> I can't find any clear description of how to reliably figure and/or
> enforce specific row (locking) order within UPDATE and SELECT FOR UPDATE
> statements dealing with multiple rows.
SQL is a set-oriented language. Sets d
On 2/15/16, Nikolai Zhubr wrote:
> Hello all,
>
> I can't find any clear description of how to reliably figure and/or
> enforce specific row (locking) order within UPDATE and SELECT FOR UPDATE
> statements dealing with multiple rows.
> I'd like to get rid of some deadlocks (caused by share locks).
Hello all,
16.02.2016 2:41, Vitaly Burovoy:
[...]
UPDATE deals with rows in order they are fetched from a heap. In a
common case it can be considered as unordered.
[...]
However SELECT can fetch rows in a specific order and locking by FOR
UPDATE clause is applied _after_ sorting. Then you can u
26 matches
Mail list logo
