Machine learning top of db logs

Hi, Basically seems that data science and machine learning are going to be more and more popular at every field of life. I have considered to use machine learning top of logs generated by PostgreSQL servers. However before I start maybe someone already has done that and can share some experienc

Re: Download link for postgres 10.8 edb software

On Fri, Jul 12, 2019 at 05:57:10AM +, Nanda Kumar wrote: > Its my bad. Yes, currently we are using 9.6 version. Now we are > looking for 10.8 edb software for testing purpose . Kindly advise > where we can download the 10.8 edb software ? 10.9 is the latest version in the 10.X series: https:/

Re: Download link for postgres 10.8 edb software

Nanda Kumar schrieb am 12.07.2019 um 04:55: > Currently we are using postgres database 9.7 version. We need to test > our application in 10.8 edb version. So can you please share the > download link for PostgreSQL 10.8 edb software. This is required for > testing purpose . > The current minor rel

Re: Download link for postgres 10.8 edb software

On Fri, Jul 12, 2019 at 02:55:55AM +, Nanda Kumar wrote: > Currently we are using postgres database 9.7 version. You may be mistaken. There is a major release of PostgreSQL called 9.6, but after that we have jumped directly to 10, reducing the number of digits to mark a given minor version fr

Download link for postgres 10.8 edb software

Hello Team, Currently we are using postgres database 9.7 version. We need to test our application in 10.8 edb version. So can you please share the download link for PostgreSQL 10.8 edb software. This is required for testing purpose . Regards Nanda Kumar.M SmartStream Technologies Eastland Citad

Re: Postgresql and VBA - Connection Timeout

On 7/11/19 1:04 PM, Wayne Mell wrote: Can someone help me with executing a postgres function from VBA?  No matter what function I call, it always times out after exactly 30 seconds.  I've tried to use the statement_timeout a million different ways and always get an error that states "Cancelling

Re: Postgresql and VBA - Connection Timeout

On 11/07/2019 3:04 p.m., Wayne Mell wrote: Can someone help me with executing a postgres function from VBA?  No matter what function I call, it always times out after exactly 30 seconds.  I've tried to use the statement_timeout a million different ways and always get an error that states "Canc

Re: Postgresql and VBA - Connection Timeout

On 7/11/19 1:04 PM, Wayne Mell wrote: Can someone help me with executing a postgres function from VBA?  No matter what function I call, it always times out after exactly 30 seconds.  I've tried to use the statement_timeout a million different ways and always get an error that states "Cancelling

Postgresql and VBA - Connection Timeout

Can someone help me with executing a postgres function from VBA? No matter what function I call, it always times out after exactly 30 seconds. I've tried to use the statement_timeout a million different ways and always get an error that states "Cancelling statement due to statement timeout" in

Re: How to run a task continuously in the background

On Thu, 2019-07-11 at 11:19 -0500, Michael Nolan wrote: > A cron job will only run once a minute, not wake up every second. > But you could write a PHP program that does a one-second sleep before > checking if there's something to do, and a batch job that runs > periodically to see if the PHP prog

Re: Restore database into azure PostgreSQL

On 11/07/2019 17:29, Adrian Klaver wrote: > On 7/11/19 9:25 AM, mahesh ravilla wrote: >> Hi, when restore a on promises database into azure PostgreSQL. I am >> ge3a error please help ASAP. >> >> Could not connect to server :connection refused >> Is the server running on host " azure_server_name" (

Re: Restore database into azure PostgreSQL

On 7/11/19 9:25 AM, mahesh ravilla wrote: Hi, when restore a on promises database into azure PostgreSQL. I am ge3a error please help ASAP. Could not connect to server :connection refused Is the server running on host " azure_server_name" (000.000.000.00)  and accepting Tcp/ip connection on po

Restore database into azure PostgreSQL

Hi, when restore a on promises database into azure PostgreSQL. I am ge3a error please help ASAP. Could not connect to server :connection refused Is the server running on host " azure_server_name" (000.000.000.00) and accepting Tcp/ip connection on port 5432? Thanks Mahesh Ravilla

Re: How to run a task continuously in the background

A cron job will only run once a minute, not wake up every second. But you could write a PHP program that does a one-second sleep before checking if there's something to do, and a batch job that runs periodically to see if the PHP program is running, and if not, launch it. That's how I handle a jo

Re: DRY up GUI wiki pages

> I created the first one because the second one was full of old, stale, > useless things. I believe that everything valid on the second one was added > to the first one at the time. > > Also look at https://wiki.postgresql.org/wiki/Design_Tools and > https://wiki.postgresql.org/wiki/Documentation_

Re: Extensions

On 7/11/19 6:54 AM, bhargav kamineni wrote: Hi Team, I have a doubt regarding the extensions.My db has these many extensions >         Name ---  adminpack  btree_gist  dblink  file_fdw  fuzzystrmatch  hstore  insert_username  intarray  pageinspect  pg_buffercache  pg

Extensions

Hi Team, I have a doubt regarding the extensions.My db has these many extensions Name --- adminpack btree_gist dblink file_fdw fuzzystrmatch hstore insert_username intarray pageinspect pg_buffercache pg_freespacemap pg_repack pg_stat_statements pg_trgm pgcryp

Re: migrating from Oracle to PostgreSQL 11

On Thu, Jul 11, 2019 at 1:28 AM Hitesh Chadda wrote: > Hello, > The target is PostgreSQL 10.1. I would like to know possible approach that > can be followed for doing the migration. > > Regards > H.kumar > > 10.9 is the current release in Pg10 and contains multiple security fixes over 10.1. There

RE: How to run a task continuously in the background

pg_cron, perhaps? https://www.citusdata.com/blog/2016/09/09/pgcron-run-periodic-jobs-in-postgres/ I _think_ it ticks all three of your boxes. Steve. This email is confidential. If you are not the intended recipient, please advise us immediately and delete this message. The registered name o

Re: migrating from Oracle to PostgreSQL 11

On 11/07/2019 17:53, Hitesh Chadda wrote: Hello, The target is PostgreSQL 10.1. I would like to know possible approach that can be followed for doing the migration. Regards H.kumar On Wednesday, June 26, 2019, Hitesh Chadda > wrote: Hi PostgresSQL Supp

Re: migrating from Oracle to PostgreSQL 11

Hello, The target is PostgreSQL 10.1. I would like to know possible approach that can be followed for doing the migration. Regards H.kumar On Wednesday, June 26, 2019, Hitesh Chadda wrote: > Hi PostgresSQL Support, > > I have to migrate from Oracle 11g to PostgresSQL 11.4. Please suggest best

How to extract information from pg_ddl_command type

The function pg_event_trigger_ddl_commands() returns several columns, one of them being "command" that is of the type "pg_ddl_command". The manual[1] describes this column as: > A complete representation of the command, in internal format. > This cannot be output directly, but it can be passe