Re: Performance issues during backup

Dylan Luong wrote: > We perform nighty base backup of our production PostgreSQL instance. We have > a script that basically puts the instance > into back mode and then backs up (tar) the /Data directory and then takes it > out of backup mode. > Ie, > psql -c "SELECT pg_start_backup('${DATE}');" >

Re: Performance issues during backup

What about sending the backup to a different server? through ssh / rsync or something, that would save lots of IO activity 2018-02-20 2:02 GMT-06:00 Laurenz Albe : > Dylan Luong wrote: > > We perform nighty base backup of our production PostgreSQL instance. We > have a script that basically puts

Re: stored procedure call is not working with "select procedure()" option

On 02/19/2018 11:13 PM, Abhra Kar wrote: Hi ,          I have a stored procedure name "procedure()". Which I am calling by -- Session sess = (Session)entityManager.getDelegate(); //entityManager is javax.persistent.EntityManager[ Properly Initialise]               sess.createSQLQuery("sele

Re: stored procedure call is not working with "select procedure()" option

On 02/20/2018 07:35 AM, Abhra Kar wrote: Please also reply to list so more people can see and answer. Ccing list On Tue, Feb 20, 2018 at 8:46 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 02/19/2018 11:13 PM, Abhra Kar wrote: Hi ,           I have a st

Re: stored procedure call is not working with "select procedure()" option

On Tue, Feb 20, 2018 at 9:21 PM, Adrian Klaver wrote: > On 02/20/2018 07:35 AM, Abhra Kar wrote: > > Please also reply to list so more people can see and answer. > Ccing list > >> >> >> On Tue, Feb 20, 2018 at 8:46 PM, Adrian Klaver > > wrote: >> >> On 02/19/

Re: stored procedure call is not working with "select procedure()" option

On 02/20/2018 08:17 AM, Abhra Kar wrote: On Tue, Feb 20, 2018 at 9:21 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: Please provide me the list email.I don't know about it. The list email is the one you used already: pgsql-gene...@postgresql.org I suspect the problem is t

Re: stored procedure call is not working with "select procedure()" option

On Tue, Feb 20, 2018 at 9:52 PM, Adrian Klaver wrote: > On 02/20/2018 08:17 AM, Abhra Kar wrote: > >> >> >> On Tue, Feb 20, 2018 at 9:21 PM, Adrian Klaver > > wrote: >> > > >> >> Please provide me the list email.I don't know about it. >> > > The list email is the

Re: stored procedure call is not working with "select procedure()" option

> On 20 Feb 2018, at 8:13, Abhra Kar wrote: > > Hi , > I have a stored procedure name "procedure()". Which I am calling by > -- > > Session sess = (Session)entityManager.getDelegate(); //entityManager is > javax.persistent.EntityManager[ Properly Initialise] > sess.cr

Crear Una FUNTION usando ROW_NUMBER

Buen día, estoy intento crear un código concatenada a través de una función que haga lo siguiente: Tengo una base de datos postgresql que esta asociada a un software GIS. Basicamente es una tabla donde se guardan datos sobre centros poblados, estos centros poblados tienen datos que al concatenarl

Re: stored procedure call is not working with "select procedure()" option

On Tue, Feb 20, 2018 at 10:45 PM, Alban Hertroys wrote: > > > On 20 Feb 2018, at 8:13, Abhra Kar wrote: > > > > Hi , > > I have a stored procedure name "procedure()". Which I am > calling by -- > > > > Session sess = (Session)entityManager.getDelegate(); //entityManager is > javax.persi

Re: Performance issues during backup

Greetings, * Dylan Luong (dylan.lu...@unisa.edu.au) wrote: > We perform nighty base backup of our production PostgreSQL instance. We have > a script that basically puts the instance into back mode and then backs up > (tar) the /Data directory and then takes it out of backup mode. > Ie, > psql -c

Re: Crear Una FUNTION usando ROW_NUMBER

Hola Yeli Respondo entre lineas El 20 de febrero de 2018, 12:26, yeli escribió: > Buen día, estoy intento crear un código concatenada a través de una > función que haga lo siguiente: > > Tengo una base de datos postgresql que esta asociada a un software GIS. > > Basicamente es una tabla donde se

Re: query performance

On Sun, 18 Feb 2018 00:35:18 +0100 hmidi slim wrote: > Hi, > I have two tables: establishment which contains these columns: id, name, > longitude, latitude, geom (Geometric column) > Product contains: id, name, establishment_id > First of all I want to select the establishment within a radius. >

Re: Crear Una FUNTION usando ROW_NUMBER

Buen dia, ya corregui la primera parte, me fije después que envié el correo y lo Los datos en la tabla vargas, no necesariamente son solo de vargas, tenia la intención de hacer que, como estos datos son datos de producción la intención era que todo los datos que pertenecieran a la mismo Huso estuvi

Getting a primitive numeric value from "DatumGetNumeric"?

Hi, I’m writing a C extension for PostgreSQL. One possible input datatype for my function is a numeric array, e.g. ARRAY[[1.5,2.5],[3.5,4.5]]. I can use “DatumGetNumeric” to extract a “Numeric” data type from the data, but at some point I need to convert this to a number (e.g. double) so that I

Re: Getting a primitive numeric value from "DatumGetNumeric"?

Demitri Muna writes: > I’m writing a C extension for PostgreSQL. One possible input datatype for my > function is a numeric array, e.g. ARRAY[[1.5,2.5],[3.5,4.5]]. I can use > “DatumGetNumeric” to extract a “Numeric” data type from the data, but at some > point I need to convert this to a numbe