Not really...currently i am using oracle for hadoop to store metatdata
information about the hadoop services. We are planning to shift to postgres
and replace oracle as source db.
On Jan 24, 2018 9:21 AM, "Merlin Moncure" wrote:
> On Wed, Jan 24, 2018 at 1:07 AM, Azimuddin Mohammed
> wrote:
> >
I have a conditional after update trigger on a table that issues an update
statement on the same table. The trigger does not fire recursively, and I
know the rows are being updated, but the update is not happening in the
same way the statement does when run from outside the trigger.
--8<-
> On Jan 24, 2018, at 9:32 PM, Abhra Kar wrote:
>
> Thanks Rob.
>
> OS -- RHEL 6.7(Santiago)
> Postgres Version -- 9.5
> Location --/usr/pgsql-9.5/bin/psql
>
> Can you please guide me , how to stop all those connection manually(From psql
> prompt or linux shell or any .sh file with in postgre
Thanks Rob.
OS -- RHEL 6.7(Santiago)
Postgres Version -- 9.5
Location --*/usr/pgsql-9.5/bin/psql*
Can you please guide me , how to stop all those connection manually(From
psql prompt or linux shell or any .sh file with in postgres directory)
Regards,
Abhra
On Thu, Jan 25, 2018 at 9:36 AM,
> On Jan 24, 2018, at 9:57 AM, Abhra Kar wrote:
>
>
> Hi,
> I am getting the following error while running bunch of Junit test
> cases through “ant test” command
> Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A
> ResourcePool could not acquire a resour
I believe postgrest can, and you can always use jwt in your application, but
postgresql doesn't natively support them.
On January 24, 2018 4:27:23 PM EST, Julio Cesar Tenganan Daza
wrote:
>Hello,
>
>I would like to know if is possible to use Token (JWT) authentication
>mechanism in Postgres? In
Hello,
I would like to know if is possible to use Token (JWT) authentication mechanism
in Postgres? In order to authenticate users and also authorize access to
specific tables, This is in a multi-tenant application context where users can
create their own tables and share it if they want.
Is i
On 01/24/2018 01:38 PM, Adrian Klaver wrote:
On 01/24/2018 12:30 PM, Rob Sargent wrote:
I just ran a query (select myfunction() \g bad/filename) which took
almost an hour and a half then told me “no such file or directory”
since I had scrogged the path. Could this path not be checked prior
to
On 01/24/2018 12:30 PM, Rob Sargent wrote:
I just ran a query (select myfunction() \g bad/filename) which took almost an
hour and a half then told me “no such file or directory” since I had scrogged
the path. Could this path not be checked prior to actual execution of the
query?
Maybe?:
t
I just ran a query (select myfunction() \g bad/filename) which took almost an
hour and a half then told me “no such file or directory” since I had scrogged
the path. Could this path not be checked prior to actual execution of the
query?
ps sorry for the blank version of this same topic - or ma
Hi,
We are using PgSql 9.4 & 9.5 with repmgr 3.5.
Repmgr works properly and great in promoting a standby to Master when
automatic failover is enabled.
The issue we have is with the old master, if master was unavailable due to
network problem, though pgSql was up and running on it we end up with 2
On Wed, Jan 24, 2018 at 12:40 PM, Rob Sargent wrote:
>
>
> On 01/24/2018 10:22 AM, Merlin Moncure wrote:
>
>> On Wed, Jan 24, 2018 at 4:52 AM, Durumdara wrote:
>>
>>> Hello!
>>>
>>> Somewhere the system administrator (who don't know the PG really)
>>> installed
>>> a PGSQL server (10.x) with a d
On 01/24/2018 10:22 AM, Merlin Moncure wrote:
On Wed, Jan 24, 2018 at 4:52 AM, Durumdara wrote:
Hello!
Somewhere the system administrator (who don't know the PG really) installed
a PGSQL server (10.x) with a database.
He couldn't manage the server well.
Yesterday my colleague saw 21 databas
On Wed, Jan 24, 2018 at 4:52 AM, Durumdara wrote:
> Hello!
>
> Somewhere the system administrator (who don't know the PG really) installed
> a PGSQL server (10.x) with a database.
> He couldn't manage the server well.
>
> Yesterday my colleague saw 21 databases in this server with random names.
>
On Wed, Jan 24, 2018 at 1:07 AM, Azimuddin Mohammed wrote:
> Hello,
> Has anyone used postgres for hadoop. Of so what is the hardware
> configuration.
> Or can someone suggest a good hardware configuration or a way I can measure
> required hardware config for the db.
what is 'postgres for hadoop'
It is all documented here:
https://www.postgresql.org/docs/10/static/release-10.html#idm46428658049888
"...selecting from a sequence relation now returns only the three
fields named above."
And there's no way to keep portability from 9.x to 10.x
Thanks ;)
Enrico
--
Enrico Pirozzi
e.piro.
2018-01-24 14:52 GMT+01:00 Enrico Pirozzi :
> Yes the query is legal,but if you use pg_upgrade to upgrade from 9.6 to 10.x
> , pg_upgrade will fail .
>
> Enrico
>
>
>
> Il 24/01/2018 13:11, Vincenzo Romano ha scritto:
>>
>> Those queries are all legal. No warning is due.
>
>
> --
> Enrico Pirozzi
>
Yes the query is legal,but if you use pg_upgrade to upgrade from 9.6 to
10.x , pg_upgrade will fail .
Enrico
Il 24/01/2018 13:11, Vincenzo Romano ha scritto:
Those queries are all legal. No warning is due.
--
Enrico Pirozzi
e.piro...@nbsgroup.it
On 01/24/2018 02:52 AM, Durumdara wrote:
Hello!
Somewhere the system administrator (who don't know the PG really)
installed a PGSQL server (10.x) with a database.
He couldn't manage the server well.
Yesterday my colleague saw 21 databases in this server with random names.
He checked it with b
2018-01-24 13:10 GMT+01:00 Enrico Pirozzi :
> it's just to know why postgresql does not return a warning.
>
>
>
> Il 24/01/2018 13:06, Vincenzo Romano ha scritto:
>>
>> I haven't any v9 any more in my deployments. Sorry.
>>
>> What is the objective of that view?
>> If it's to hide the nextval() fun
it's just to know why postgresql does not return a warning.
Il 24/01/2018 13:06, Vincenzo Romano ha scritto:
I haven't any v9 any more in my deployments. Sorry.
What is the objective of that view?
If it's to hide the nextval() function, then the solution can be
similar to mine.
If it's to acce
2018-01-24 13:02 GMT+01:00 Enrico Pirozzi :
>
>> tmp1=# create sequence x;
>> CREATE SEQUENCE
>> Time: 69,857 ms
>> tmp1=# select * from x;
>> last_value | log_cnt | is_called
>> +-+---
>> 1 | 0 | f
>> (1 row)
>>
>> Maybe what you want to do is
>>
>> crea
tmp1=# create sequence x;
CREATE SEQUENCE
Time: 69,857 ms
tmp1=# select * from x;
last_value | log_cnt | is_called
+-+---
1 | 0 | f
(1 row)
Maybe what you want to do is
create view v_test_sequence as select nextval( 'test_sequence' );
Ciao.
Yes but
tmp1=# create sequence x;
CREATE SEQUENCE
Time: 69,857 ms
tmp1=# select * from x;
last_value | log_cnt | is_called
+-+---
1 | 0 | f
(1 row)
Maybe what you want to do is
create view v_test_sequence as select nextval( 'test_sequence' );
Ciao.
Yes bu
2018-01-24 12:52 GMT+01:00 Enrico Pirozzi :
> Hi, I was doing a test on a 9.6 and I've seen a strange thing
>
> if I run
>
> create sequence test_sequence;
> create view v_test_sequence as select * from test_sequence;
>
> PostgreSQL creates a view based on the sequence and the strange thing is
> t
Hi, I was doing a test on a 9.6 and I've seen a strange thing
if I run
create sequence test_sequence;
create view v_test_sequence as select * from test_sequence;
PostgreSQL creates a view based on the sequence and the strange thing
is that, among the various fields that are created in the vie
2018-01-24 12:18 GMT+01:00 Condor :
> On 24-01-2018 12:52, Durumdara wrote:
>>
>> Hello!
>>
>> Somewhere the system administrator (who don't know the PG really)
>> installed a PGSQL server (10.x) with a database.
>> He couldn't manage the server well.
>>
>> Yesterday my colleague saw 21 databases i
On 24-01-2018 12:52, Durumdara wrote:
Hello!
Somewhere the system administrator (who don't know the PG really)
installed a PGSQL server (10.x) with a database.
He couldn't manage the server well.
Yesterday my colleague saw 21 databases in this server with random
names.
He checked it with built
> 1.) PGAdmin IV bug?
> 2.) Their server is hacked/cracked from outside?
> 3.) A wrong configured tool, or an automation?
> 4.) "Alien invasion", etc.
> Did you see same thing anywhere?
Are their connections to the server? What does "netstat" tell you?
--
Meetings Coordinator, Michigan Associat
Hello!
Somewhere the system administrator (who don't know the PG really) installed
a PGSQL server (10.x) with a database.
He couldn't manage the server well.
Yesterday my colleague saw 21 databases in this server with random names.
He checked it with built in PGAdmin IV.
Today we checked it again
31 matches
Mail list logo
