Re: FW: [GENERAL] PostgreSQL and iptables

2015-06-13 Thread José María Terry Jiménez
El 13/06/15 a las 10:58, Mephysto escribió: Thank you Holger, any suggestions? I'm using the same settings used for ssh connection to vm, and these work correctly Bye. Meph Hello Are PosgreSQL listening in the IP of the machine with (for example): listen_addresses = '*'# wh

Re: [GENERAL] Broken after upgrade

2016-07-06 Thread José María Terry Jiménez
El 7/7/16 a las 0:14, Devrim Gündüz escribió: Hi, Fedora packages have an executable (not sure about its name, but check a package called postgresql-upgrade or so). That will help you to finish the upgrade process. Regards, Devrim Hello Yes, the package is called postgresql-upgrade, and

Re: [GENERAL] Because PostgreSQL is compiling in old versions of OS?

2017-11-08 Thread José María Terry Jiménez
El 8/11/17 a las 20:28, DrakoRod escribió: > Hi everyone! > > I want to develop a installer for many purposes, but i have a question, when > I review the currently PostgreSQL versions, I see Ubuntu 5 or RHEL 4 , when > currently we have Ubuntu 16 or RHEL 7. for example: > > /PostgreSQL 9.6.0 on x

Re: [GENERAL] Performing upgrade to latest minor release using PGDG RPMs

2011-08-27 Thread José María Terry Jiménez
El 27/08/2011, a las 02:40, John Moran escribió: > I'm wondering how it's possible to upgrade my fedora system's pg to > the latest minor release. I'm using the PGDG RPMs. A "yum update" > leaves me on version 9.0.2. I'd expect it to put me on 9.0.4. What am > I doing wrong? I installed from pgdg

[GENERAL] How to reference a subquery column alias?

2010-08-09 Thread José María Terry Jiménez
Hello Yesterday a list user solved me a problem with a sententence with two subqueries. The solution was this: SELECT remota_id,min(hora),max(hora), (SELECT caudal FROM historicos WHERE remota_id=ooo.remota_id AND hora=min(ooo.hora)) as min_caudal, (SELECT caudal FROM historicos WHERE remota

Re: [GENERAL] How to reference a subquery column alias?

2010-08-09 Thread José María Terry Jiménez
, Sergey Konoplev escribió: Hi, Just wrap your expression with another SELECT and operate with the aliases like SELECT *, min_caudal + max_caudal AS diferencia FROM ( ...your expression... ) 2010/8/9 José María Terry Jiménez : Hello Yesterday a list user solved me a problem with a sententence

Re: [GENERAL] Error in crosstab using date_trunc

2009-12-06 Thread José María Terry Jiménez
Richard Broersma escribió: On Sat, Dec 5, 2009 at 11:11 AM, Jose Maria Terry Jimenez wrote: select distinct date_trunc('minute',"timestamp") as "timestamp" from historico order by "timestamp"; Notice the example from the documentation: http://www.postgresql.org/docs/8.4/interactive/f

Re: [GENERAL] Error in crosstab using date_trunc

2009-12-06 Thread José María Terry Jiménez
Scott Marlowe escribió: On Sat, Dec 5, 2009 at 12:11 PM, Jose Maria Terry Jimenez wrote: Hello all, I'm trying to do a crosstab from data that row names are times. These times are timestamps and i want to use they truncating to minutes this works for me: select distinct date_trunc('mi

Re: [GENERAL] Error in crosstab using date_trunc

2009-12-06 Thread José María Terry Jiménez
Alban Hertroys escribió: On 6 Dec 2009, at 4:13, Scott Marlowe wrote: On Sat, Dec 5, 2009 at 12:11 PM, Jose Maria Terry Jimenez wrote: Hello all, I'm trying to do a crosstab from data that row names are times. These times are timestamps and i want to use they truncating to minute

Re: [GENERAL] pgadmin save password

2010-01-09 Thread José María Terry Jiménez
glaucomag escribió: Hi, I've a problem with pgadmin. If I access to database with user X and I save password, when I access to database from shell (psql) password is not required. Of course pg_hba.conf is: local database X md5 If I don't save password in pgadmin, it's ok (psql required password