Alban Hertroys writes:
> On 25 September 2015 at 13:08, Ramesh T wrote:
>> CREATE UNIQUE INDEX idx_load_pick ON pick (case picked when picked='y' then
>> load_id else null end );
>>
>> how can i convert case expressed to postgres..above it is
Ben Primrose writes:
> Iâm seeing some odd behavior from the extract function.
> Any idea why extract would think January 3rd of next year is the 53rd week
> of the year?
See the fine manual ...
All,
I’m seeing some odd behavior from the extract function.
Any idea why extract would think January 3rd of next year is the 53rd week
of the year?
Thanks
Ben
[bprimrose@primrose partitioning]$ psql
Null display is "¤".
Line style is unicode.
Output format is wrapped.
I'm trying to get support for PostgreSQL's listen/notify into a
development environment, but since it supports multiple database
backends: can anybody comment on how many other servers have a
comparable facility?
Minimal research has allowed me to code something for
Firebird/Interbase, but
Thanks. I'd taken some stabs at setting up Corosync/Pacemaker, but could never get the PostgreSQL portion to work properly. One difficulty is that I am using named replication slots, which don't appear to be supported. The other issue is that the system tended to try to start my secondary as
Well, those are two high-quality answers, and I appreciate them. Not
really the news I was hoping for, of course, though I suppose it's a
small consolation that the problem is not in the model, but the
implementation. That leaves the possibility open in principle, at
least, though the technical
Hello,
I am new to posgresql.
I've configured replication for my database . It li working fine, but I need
to test failover capabilities.
According to manual I have to kill completely Master and "touch" a trigger
to make Slave new Master.
Could you please recommend me a way to kill Master in
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Ramesh T
Sent: Friday, September 25, 2015 7:09 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] to pg
CREATE UNIQUE INDEX idx_load_pick ON pick (case picked when picked='y' then
load_id
On 09/25/2015 11:20 AM, yuryu wrote:
According to manual I have to kill completely Master and "touch" a trigger
to make Slave new Master.
You don't have to do anything in the master. If you have configured the
slave to check for a file, then it will become Read Write when that file
is
Surely just
CASE picked WHEN 'y' THEN load_id ELSE NULL END
or
CASE WHEN picked='y' THEN load_id ELSE NULL END
?
On 25 September 2015 at 12:08, Ramesh T
wrote:
> CREATE UNIQUE INDEX idx_load_pick ON pick (case picked when picked='y'
> then load_id else null
CREATE UNIQUE INDEX idx_load_pick ON pick (case picked when picked='y'
then load_id else null end );
how can i convert case expressed to postgres..above it is oracle.
any help appreciated...
On 25.9.2015 13:08, Ramesh T wrote:
> CREATE UNIQUE INDEX idx_load_pick ON pick (case picked when picked='y' then
> load_id else null end );
>
> how can i convert case expressed to postgres..above it is oracle.
>
> any help appreciated...
Hello.
And what about a partial unique index as
Ramesh T wrote:
> CREATE UNIQUE INDEX idx_load_pick ON pick (case picked when picked='y' then
> load_id else null end );
>
> how can i convert case expressed to postgres..above it is oracle.
CREATE TABLE pick (picked char(1), load_id integer);
CREATE FUNCTION picked_loadid(character, integer)
Israel,
I can't answer all your questions, but we've just set up a HA pair with *Hot
Standby using Corosync/Pacemaker*. However we haven't deployed this 'live'
yet.
We originally found a presentation from The PostgreSQL Conference PostgreSQL
High Availability with Corosync/Pacemaker
On 09/24/2015 04:29 PM, Sherrylyn Branchaw wrote:
I'm assuming based on the "SSL error" that you have ssl set to 'on'.
What's your ssl_renegotiation_limit? The default is 512MB, but setting
it to 0 has solved problems for a number of people on this list,
including myself.
I have also seen
On 25 September 2015 at 13:08, Ramesh T wrote:
> CREATE UNIQUE INDEX idx_load_pick ON pick (case picked when picked='y' then
> load_id else null end );
>
> how can i convert case expressed to postgres..above it is oracle.
Assuming that your queries are written in
On 09/24/2015 04:34 PM, Alvaro Herrera wrote:
Sherrylyn Branchaw wrote:
Moreover, the default has been set to 0, because the bugs both in our
usage and in OpenSSL code itself seem never to end. Just disable it.
Set it to 0 and did not help.
Likely will move all machines to have it =0 since I
17 matches
Mail list logo