Hi, I am having difficulty removing a node from a BDR group (with nodes node1
through node5) then rejoin the group.
Prior to removing a node, the BDR is running fine, query on bdr.bdr_nodes table
shows all nodes having the status 'r'.
Here is what I have done for removing node5 and rejoining:
On 7/7/2017 8:22 AM, Terry Schmitt wrote:
You have the open source version installed. Now where it was installed
from is a different story.
if its a redhat/centos/fedora type system, try...
rpm -qa |grep ^postgres
if it was installed from rpm's, the full names of the rpms will clue you i
The setups were downloaded from postgresql site only.
On Jul 7, 2017 7:12 PM, "Adrian Klaver" wrote:
On 07/06/2017 11:13 PM, Mayank Agrawal wrote:
> No, windows has not been upgraded (Windows 7). Moreover, I think it is not
> related to windows version, because I tried the scenarios from scratc
On Fri, Jul 7, 2017 at 8:45 AM, Tom Lane wrote:
> "David G. Johnston" writes:
> > I'm using Ubuntu 16.04
>
> Hmph. Works for me on RHEL6. I'm betting that Ubuntu has put in some
> weird security restriction, possibly an overreaction to the "shellshock"
> bug which was in the exported-function
"David G. Johnston" writes:
> I'm using Ubuntu 16.04
Hmph. Works for me on RHEL6. I'm betting that Ubuntu has put in some
weird security restriction, possibly an overreaction to the "shellshock"
bug which was in the exported-functions feature.
regards, tom lane
--
S
You have the open source version installed. Now where it was installed from
is a different story.
EnterpriseDB Advanced Server will look like:
EnterpriseDB 9.5.5.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7
20120313 (Red Hat 4.4.7-16), 64-bit
T
On Fri, Jul 7, 2017 at 7:04 AM, Krithika
On Fri, Jul 7, 2017 at 8:19 AM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Fri, Jul 7, 2017 at 8:12 AM, David G. Johnston <
> david.g.johns...@gmail.com> wrote:
>
>> I'm using Ubuntu 16.04
>>
>>
> Seems to be a regression since this works on my 14.04 setup.
>
>
Sorry for the ap
On Fri, Jul 7, 2017 at 8:12 AM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> I'm using Ubuntu 16.04
>
>
Seems to be a regression since this works on my 14.04 setup.
David J.
On Fri, Jul 7, 2017 at 7:43 AM, Albe Laurenz
wrote:
> David G. Johnston wrote:
> >> It works for me on Linux with 9.6.3 psql:
> >
> > Except you haven't recreated the scenario I presented.
> >
> > You only are involving a single script and that script defines
> "testfunction" itself
> > (which
Albe Laurenz writes:
> David G. Johnston wrote:
>> Except you haven't recreated the scenario I presented.
> Am I missing something?
I wonder what platform David is using. This looks suspiciously like
a feature that macOS' SIP would be designed to break.
It would be interesting to capture the
On Fri, Jul 7, 2017 at 9:04 AM, Krithika Venkatesh <
krithikavenkates...@gmail.com> wrote:
> select version () gives me output something like this
>
> PostgreSQL 9.5.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.1.2
> 20080704 (Red hat 4.1.2-55), 64 bit.
>
> Is there any other way to find
>
>
David G. Johnston wrote:
>> It works for me on Linux with 9.6.3 psql:
>
> Except you haven't recreated the scenario I presented.
>
> You only are involving a single script and that script defines
> "testfunction" itself
> (which makes exporting pointless). In my example the script being exec
On 07/07/2017 07:04 AM, Krithika Venkatesh wrote:
select version () gives me output something like this
PostgreSQL 9.5.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.1.2
20080704 (Red hat 4.1.2-55), 64 bit.
Is there any other way to find
It depends on what you are trying to determine:
On Fri, Jul 7, 2017 at 7:04 AM, Krithika Venkatesh <
krithikavenkates...@gmail.com> wrote:
> select version () gives me output something like this
>
> PostgreSQL 9.5.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.1.2
> 20080704 (Red hat 4.1.2-55), 64 bit.
>
> Is there any other way to find
>
select version () gives me output something like this
PostgreSQL 9.5.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.1.2
20080704 (Red hat 4.1.2-55), 64 bit.
Is there any other way to find
On 07-Jul-2017 7:28 PM, "Adrian Klaver" wrote:
> On 07/07/2017 06:52 AM, Krithika Venkatesh wrote:
>
>
On Fri, Jul 7, 2017 at 3:49 AM, Patrick B wrote:
> I want this to work:
>
> WITH account_status AS (
> select
> CASE
> WHEN regdate = 1 THEN 'yes'
> WHEN regdate = 2 THEN 'no'
> end as status_a,
> count(t2.id) as t2_count
> from test1 as t1
> join test2 as t2 on t2.test1_id = t1.id
> end
On 07/07/2017 06:52 AM, Krithika Venkatesh wrote:
Hi,
I have postgreSQL 9.5 installed in the server. Is it possible to find
whether the installed postgresql is enterprise db or an open source
version through a query.
Not sure, but I would try:
select version();
Thanks in Advance.
--
A
On Fri, Jul 7, 2017 at 3:59 AM, Albe Laurenz
wrote:
> David G. Johnston wrote:
> > In hindsight I'm not surprised but couldn't find a ready explanation on
> the web and
> > figured I'd inquire here. In short: "export VAR" and "export -f
> functionname" behave
> > differently when psql is acting
Hi,
I have postgreSQL 9.5 installed in the server. Is it possible to find
whether the installed postgresql is enterprise db or an open source version
through a query.
Thanks in Advance.
On 07/06/2017 11:13 PM, Mayank Agrawal wrote:
No, windows has not been upgraded (Windows 7). Moreover, I think it is
not related to windows version, because I tried the scenarios from
scratch on a same machine and on a some windows version.
While working on this issue I notices something. Deta
David G. Johnston wrote:
> In hindsight I'm not surprised but couldn't find a ready explanation on the
> web and
> figured I'd inquire here. In short: "export VAR" and "export -f
> functionname" behave
> differently when psql is acting as a relay.
It works for me on Linux with 9.6.3 psql:
laur
2017-07-07 22:32 GMT+12:00 Thomas Markus :
> Hi,
>
> Am 07.07.17 um 12:16 schrieb Patrick B:
>
> Hi guys!
>
> I've got 2 tables, and I need to get some data between them.
>
> test1:
>
> WITH account_status AS (
> select
> CASE
> WHEN regdate = 1 THEN 'yes'
> WHEN regdate = 2 THEN 'no'
> from
Hi,
Am 07.07.17 um 12:16 schrieb Patrick B:
Hi guys!
I've got 2 tables, and I need to get some data between them.
test1:
WITH account_status AS (
select
CASE
WHEN regdate = 1 THEN 'yes'
WHEN regdate = 2 THEN 'no'
from test1
end as status_a
)
select
Hi guys!
I've got 2 tables, and I need to get some data between them.
test1:
WITH account_status AS (
select
CASE
WHEN regdate = 1 THEN 'yes'
WHEN regdate = 2 THEN 'no'
from test1
end as status_a
)
select status_a from account_status group by status_a
test2:
WITH user_status AS (
sele
Hi David,
Thanks, I have done so.
On Thu, Jul 6, 2017 at 5:05 PM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Thu, Jul 6, 2017 at 8:52 AM, Osahon Oduware
> wrote:
>
>> Hi All,
>>
>> I used the raster2pgsql tool to load a raster with overviews into a
>> PostGIS database using the
Hi Adrian,
Thanks for your response. I have already loaded the raster, but *I want to
rename the raster table and I am asking of how to do this **without
affecting the functionality of the raster/overviews*.
On Thu, Jul 6, 2017 at 6:27 PM, Adrian Klaver
wrote:
> On 07/06/2017 08:52 AM, Osahon O
26 matches
Mail list logo
