Re: [GENERAL] Streaming Replication archive_command is really needed?

El 20/07/17 a las 16:57, Andreas Kretschmer escribió: On 20 July 2017 21:46:09 GMT+02:00, "Leonardo M. Ramé" <l.r...@griensu.com> wrote: Hi, I wonder if archive_mode=on and archive_command parameters in postgresql.conf are really needed for streaming replication between two

[GENERAL] Streaming Replication archive_command is really needed?

Hi, I wonder if archive_mode=on and archive_command parameters in postgresql.conf are really needed for streaming replication between two servers (master-slave). Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54

Re: [GENERAL] Foreign Data Wrapper for filesystem

nt. It's called 'rain'." -- Michael McClary, in alt.fusion Maranatha! <>< John McKown Well, I need to check the existence of a file from a query/procedure. After posting I remembered I could do this with plperlu, I'm installing it right now. Regards, -- Leonardo M. Ramé Medical IT - Gri

[GENERAL] Foreign Data Wrapper for filesystem

Hi, I'm looking for a FDW that allows listing a directory as a database table allowing me to check if file exists, does anyonke know if such FDW exists?. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351

Re: [GENERAL] Alter view with psql command line

El 10/02/17 a las 14:17, Adrian Klaver escribió: On 02/10/2017 09:09 AM, Leonardo M. Ramé wrote: Hi, is there a way to alter a view using *psql*?, something like what \ef does for functions. In 9.6: That's why in 9.1 I didn't find that command... https://www.postgresql.org/docs/9.6

[GENERAL] Alter view with psql command line

Hi, is there a way to alter a view using *psql*?, something like what \ef does for functions. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54 9 (011) 40871877

[GENERAL] [Off Topic] Visualizing grouping sets/cubes

Hi, I'm reading about Grouping Sets/Rollup/Cube and I wonder which js/html5 library allows displaying *easily* (without having to re-format it) the returned data from those functions. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel

Re: [GENERAL] Ajuda com definição

r_5) values(1234567, 123456); <-- ERROR insert into numbers(number_7, number_5) values(1234567, 12345); <-- OK Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54 9 (011)

[GENERAL] Add trigger to FDW table

Hi, I wonder if I can add a trigger to a Foreign Data Wrapper table. I can't create the trigger in the foreign database. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel

[GENERAL] Improving speed of query

ws) What strategy do you recommend for speeding up this query?. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54 9 (011) 40871877 -- Sent via pgsql-general mailin

Re: [GENERAL] 2.5TB Migration from SATA to SSD disks - PostgreSQL 9.2

ow how to do that, would you care to explain? Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54 9 (011) 40871877 -- Sent via pgsql-general mailing list (pgsql-general@postgres

Re: [GENERAL] Test letter

El 15/09/16 a las 11:57, Alex Sviridov escribió: Hi all, I have suspicions that my message don't get to pgsql-general mailing list. Please, someone, answer this message if this get the mailing list. Best regards, Alex Arrived ok. -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón

Re: [GENERAL] ERROR: could not read block 4 ...

indeed, I'm moving the Db to another server. -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54 9 (011) 40871877 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.or

[GENERAL] ERROR: could not read block 4 ...

b=# select oid, datname from pg_database; oid | datname ---+--- 1 | template1 12210 | template0 <--- Looks like this is the problematic db 12215 | postgres 16384 | mydb Two questions: 1) Is this caused by a bad block?, can fsck fix it?. 2) Is there a way to re-generat

Re: [GENERAL] londiste re-create leaf node

El 09/09/16 a las 10:53, Leonardo M. Ramé escribió: Hi, I had a londiste3 slave server that no longer works and I want to re-create. I dropped all the pgq and londiste schemas in the leaf node manually...now I want to create the node again, but I'm getting this error: londiste3 /home

[GENERAL] londiste re-create leaf node

on 'db': could not access file "$libdir/pgq_lowlevel": No such file or directory. This is weird, because master is working without issues. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788

Re: [GENERAL] Londiste3 - Ubuntu 16.04 - Postgresql 9.3

El 03/06/16 a las 16:29, Adrian Klaver escribió: On 06/03/2016 12:08 PM, Leonardo M. Ramé wrote: Hi again, I'm trying to create the root node using londiste3 from Ubuntu 16.04 connected to a PostgreSql 9.3 db, but I get this: londiste3 /home/leonardo/replication/pacsio_master.ini create-root

Re: [GENERAL] Londiste3 - Ubuntu 16.04 - Postgresql 9.3

El 03/06/16 a las 16:08, Leonardo M. Ramé escribió: Hi again, I'm trying to create the root node using londiste3 from Ubuntu 16.04 connected to a PostgreSql 9.3 db, but I get this: londiste3 /home/leonardo/replication/pacsio_master.ini create-root master_node "dbname=test host=127.

[GENERAL] Londiste3 - Ubuntu 16.04 - Postgresql 9.3

o el directorio P.S.: Here there's a suggestion of installing postgresql-9.4-pgq3, but as I have 9.3 I cannot install the recommended package (it will install 9.4 and start a new cluster). Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córd

Re: [GENERAL] pgFoundry down

El 03/06/16 a las 14:10, Adrian Klaver escribió: On 06/03/2016 08:42 AM, Leonardo M. Ramé wrote: Hi, I'm trying to download Skytools 3.2 but pgFoundry seems to be down, does anyone know another place to download it?. I just tried it and got through: http://pgfoundry.org/projects/skytools

[GENERAL] pgFoundry down

Hi, I'm trying to download Skytools 3.2 but pgFoundry seems to be down, does anyone know another place to download it?. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54

Re: [GENERAL] Londiste 3 pgq events_1_1 table huge

El 20/05/16 a las 10:19, Leonardo M. Ramé escribió: El 19/05/16 a las 12:39, Saiful Muhajir escribió: This has happened to us where we have dead or unmanaged consumer. Turns out londiste is keeping the event even if the consumer is unreachable. This is to ensure that the consumer gets what

Re: [GENERAL] Londiste 3 pgq events_1_1 table huge

move them?. -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54 9 (011) 40871877 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscrip

Re: [GENERAL] Londiste 3 pgq events_1_1 table huge

: node_esclavo (leaf) Tables: 146/0/0 Lag: 0s, Tick: 1112197 So, what if I manually delete old events?. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979

[GENERAL] Londiste 3 pgq events_1_1 table huge

size of the whole database), so I'm asking how can I clean up the events table without breaking the replication?. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54 9 (011

Re: [GENERAL] HELP! Uninstalled wrong version of postgres

nd everything should be fine again. P.S.: All those steps should be done as root. Regards, -- Leonardo M. Ramé http://leonardorame.blogspot.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Partition

uot; I'll get an *union* of new and old data?. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54 9 (011) 40871877 -- Sent via pgsql-general mailing list (pgsql-general@

Re: [GENERAL] Distributed Table Partitioning

El 13/03/16 a las 10:04, Peter J. Holzer escribió: On 2016-03-12 21:19:11 -0500, Melvin Davidson wrote: - Original Message - From: "Leonardo M. Ramé" <l.r...@griensu.com> To: "PostgreSql-general" <pgsql-general@postgresql.org> Sent:

[GENERAL] Distributed Table Partitioning

ervers, then return the "composed" dataset to the caller. I think this is called Distributed Horizontal Table Partitioning. Is there a way to do this without changing my application code?. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Cór

Re: [GENERAL] Update foreign table with trigger

El 26/02/16 a las 17:11, s d escribió: On 26 February 2016 at 21:02, Leonardo M. Ramé <l.r...@griensu.com <mailto:l.r...@griensu.com>> wrote: El 26/02/16 a las 16:49, s d escribió: On 26 February 2016 at 20:42, Leonardo M. Ramé <l.r...@griensu.

Re: [GENERAL] Update foreign table with trigger

El 26/02/16 a las 16:49, s d escribió: On 26 February 2016 at 20:42, Leonardo M. Ramé <l.r...@griensu.com <mailto:l.r...@griensu.com>> wrote: Then try to do the update on the remote db directly. In the meantime could you provide the table and trigger definiti

Re: [GENERAL] Update foreign table with trigger

El 26/02/16 a las 16:33, s d escribió: On 26 February 2016 at 20:19, Leonardo M. Ramé <l.r...@griensu.com <mailto:l.r...@griensu.com>> wrote: El 26/02/16 a las 16:18, s d escribió: On 26 February 2016 at 20:02, Leonardo M. Ramé <l.r...@griensu.

Re: [GENERAL] Update foreign table with trigger

El 26/02/16 a las 16:18, s d escribió: On 26 February 2016 at 20:02, Leonardo M. Ramé <l.r...@griensu.com <mailto:l.r...@griensu.com>> wrote: El 26/02/16 a las 15:55, John R Pierce escribió: On 2/26/2016 10:29 AM, Leonardo M. Ramé wrote: H

Re: [GENERAL] Possible bug in psql 9.4.4

El 26/02/16 a las 15:59, Leonardo M. Ramé escribió: It looks like psql 9.4.4 has a bug when trying to display table info using \d tablename. On 9.4.2 that command displays Indexes, Constraints, Triggers, etc. 9.4.4 only displays the table fields. Regards, Sorry, option \t (Tuples Only

Re: [GENERAL] Update foreign table with trigger

El 26/02/16 a las 15:55, John R Pierce escribió: On 2/26/2016 10:29 AM, Leonardo M. Ramé wrote: Hi, I created a Postgres_FDW table (TABLE_A) and need to do an update on that table. As TABLE_A has a trigger, and the trigger does an insert on another table (TABLE_B), I had to create another

[GENERAL] Possible bug in psql 9.4.4

It looks like psql 9.4.4 has a bug when trying to display table info using \d tablename. On 9.4.2 that command displays Indexes, Constraints, Triggers, etc. 9.4.4 only displays the table fields. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT

[GENERAL] Update foreign table with trigger

ctid = $1 PL/pgSQL function public.TABLE_A_update() line 4 at SQL statement Any hint?. Regards -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54 9 (011) 40871877 -- Sent via p

[GENERAL] Ubuntu 15.04 Installing Oracle_fdw

en extension control file "/usr/share/postgresql/9.4/extension/oracle_fdw.control": No such file or directory Any hint? -- Leonardo M. Ramé http://leonardorame.blogspot.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscript

Re: [GENERAL] Ubuntu 15.04 Installing Oracle_fdw

El 02/01/16 a las 12:51, Leonardo M. Ramé escribió: Hi, I compiled oracle_fdw.so on Ubuntu 15.04 Server 64bits and I'm getting the "No such file or directory" error when I try to create the oracle_fdw extension. After doing make and make install on Oracle fdw source oracle_fdw.s

[GENERAL] Could not connect to server: No buffer space available (0x00002747/10055)

elp me fix this?. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54 9 (011) 40871877 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your su

Re: [GENERAL] Could not connect to server: No buffer space available (0x00002747/10055)

El 02/12/15 a las 13:20, Adrian Klaver escribió: On 12/02/2015 07:53 AM, Leonardo M. Ramé wrote: Hi, I installed postgresql-x64-9.4 (installed from postgresql-9.4.5-2-windows-x64.exe) on a Windows Seven 64bits PC, and I'm getting the error "Could not connect to server: No buffer space avai

Re: [GENERAL] Array_to_json remove brackets

El 13/11/15 a las 10:49, Merlin Moncure escribió: On Fri, Nov 13, 2015 at 7:20 AM, Leonardo M. Ramé <l.r...@griensu.com> wrote: Hi, is there a way to get an array converted to json without brackets?. I'm getting, for example [{"field": "value"}, {"fiel

[GENERAL] Array_to_json remove brackets

Hi, is there a way to get an array converted to json without brackets?. I'm getting, for example [{"field": "value"}, {"field": "value"}] and I want to get this: {"field": "value"}, {"field": "value"}. Regards,

Re: [GENERAL] MinGW-W64 compile error

El 04/11/15 a las 00:05, Tom Lane escribió: "=?UTF-8?Q?Leonardo_M._Ram=c3=a9?=" writes: Hi, I'm trying to build the client library of PostgreSql 9.3.x using this version of MinGW's gcc: ... g++ -DFRONTEND -I../../src/include -I./src/include/port/win32 -DEXEC_BACKEND

Re: [GENERAL] MinGW-W64 compile error

El 04/11/15 a las 06:00, Leonardo M. Ramé escribió: El 04/11/15 a las 00:05, Tom Lane escribió: "=?UTF-8?Q?Leonardo_M._Ram=c3=a9?=" <l.r...@griensu.com> writes: Hi, I'm trying to build the client library of PostgreSql 9.3.x using this version of MinGW's gcc: Nevermind,

[GENERAL] MinGW-W64 compile error

e] Error 2 Does anyone know how can I get rid of this error?. Regards, -- Leonardo M. Ramé http://leonardorame.blogspot.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Compression function

there. Regards, -- Leonardo M. Ramé http://leonardorame.blogspot.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Column does not exists?

El 26/03/15 a las 14:17, Ashesh Vashi escibió: [Sent through mobile] On Mar 26, 2015 10:43 PM, Leonardo M. Ramé l.r...@griensu.com mailto:l.r...@griensu.com wrote: Ok, I have this table: CREATE TABLE sessions ( SESSIONID integer NOT NULL, SESSIONTIMESTAMP character varying(45

Re: [GENERAL] Column does not exists?

El 26/03/15 a las 14:23, Francisco Olarte escibió: Hi Leonardo: On Thu, Mar 26, 2015 at 6:12 PM, Leonardo M. Ramé l.r...@griensu.com wrote: DELETE From sessions WHERE SESSIONTIMESTAMP '2010-01-01 10:02:02' ERROR: column sessiontimestamp does not exist LINE 1: DELETE From sessions WHERE

[GENERAL] Column does not exists?

Character: 28 But if I do: DELETE From sessions WHERE SESSIONTIMESTAMP '2010-01-01 10:02:02' It DOES work. Why the db doesn't recognize the name of the table without quotes?. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351

Re: [GENERAL] Column does not exists?

El 26/03/15 a las 14:18, Adrian Klaver escibió: On 03/26/2015 10:12 AM, Leonardo M. Ramé wrote: Ok, I have this table: CREATE TABLE sessions ( SESSIONID integer NOT NULL, SESSIONTIMESTAMP character varying(45) NOT NULL, SESSIONDATA character varying(200) DEFAULT NULL::character

Re: [GENERAL] Timezone mismatch

El 20/03/15 a las 12:38, Steve Crawford escibió: On 03/20/2015 08:29 AM, Leonardo M. Ramé wrote: Hi, I had to change the O.S. timezone and aparently PostgreSql continues using the old timezone, how can I force update it's time zone?. Using PostgreSql 8.4 on Ubuntu Server 12.04. To update

[GENERAL] Timezone mismatch

Hi, I had to change the O.S. timezone and aparently PostgreSql continues using the old timezone, how can I force update it's time zone?. Using PostgreSql 8.4 on Ubuntu Server 12.04. To update the OS timezone I used sudo dpkg-reconfigure tzdata Regards, -- Leonardo M. Ramé http

Re: [GENERAL] Timezone mismatch

El 20/03/15 a las 14:11, Leonardo M. Ramé escibió: El 20/03/15 a las 13:03, Adrian Klaver escibió: I am not sure what the exact issue is? How are you determining that the new time zone is not being used? What was the old time zone, what is the new one? I don't know if the new time zone

Re: [GENERAL] Sequences not created, bug in pg_dump?

El 19/03/15 a las 14:13, Adrian Klaver escibió: On 03/19/2015 10:02 AM, Leonardo M. Ramé wrote: El 19/03/15 a las 13:09, Adrian Klaver escibió: On 03/19/2015 08:43 AM, Leonardo M. Ramé wrote: Hi, I'm creating a database dump excluding one table and found only the sequences created

Re: [GENERAL] Timezone mismatch

El 20/03/15 a las 13:03, Adrian Klaver escibió: I am not sure what the exact issue is? How are you determining that the new time zone is not being used? What was the old time zone, what is the new one? I don't know if the new time zone is beign used, It just coincede with the old local time

Re: [GENERAL] Sequences not created, bug in pg_dump?

El 19/03/15 a las 13:09, Adrian Klaver escibió: On 03/19/2015 08:43 AM, Leonardo M. Ramé wrote: Hi, I'm creating a database dump excluding one table and found only the sequences created implicitly (using serial type) are created when I restore the dump. The command I use is: pg_dump -T

[GENERAL] Sequences not created, bug in pg_dump?

are not dumpled, but why I don't get any CREATE SEQUENCE command in my dump?. -- Leonardo M. Ramé http://leonardorame.blogspot.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Weight BLOB objects in postgreSQL? How?

Here's the answer. http://pdenya.com/2014/01/16/postgres-bytea-size/ El 04/03/15 a las 12:17, John R Pierce escibió: On 3/4/2015 7:03 AM, María Griensu wrote: I need to figure out how can I weight BLOB objects in a table of a DB, I'm not expert on this topics, so I appreciate any help you can

[GENERAL] psql generate insert command based on select

where id=xxx; this should create the insert command for the requested query. Is such a thing already present in psql?. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54 9

Re: [GENERAL] psql generate insert command based on select

El 10/10/14 a las 14:37, Adrian Klaver escibió: On 10/10/2014 10:27 AM, Leonardo M. Ramé wrote: Hi, today I needed to re-create certain records deleted from a mysql database, so I restored an old backup, opened a terminal and logged in to the old database using the mysql command line utility

Re: [GENERAL] psql generate insert command based on select

El 10/10/14 a las 14:50, vibhor.ku...@enterprisedb.com escibió: On Oct 10, 2014, at 1:27 PM, Leonardo M. Ramé l.r...@griensu.com wrote: Hi, today I needed to re-create certain records deleted from a mysql database, so I restored an old backup, opened a terminal and logged in to the old

[GENERAL] Error while upgrading from 8.4 to 9.3

, we got the error I mentioned at the beggining of this email. P.S.: pg_upgrade_utility.log attached. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54 9 (011) 40871877

Re: [GENERAL] Error while upgrading from 8.4 to 9.3

numbers from the conf files and then pg_upgrade is starting them on 50432. Sorry guys, one of the in-site tech support guys started the postgresql service while we were trying to do the upgrade. Looks like this was the cause of the failure. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A

[GENERAL] Pagination count strategies

?. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54 9 (011) 40871877 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Pagination count strategies

On 2014-04-03 10:00:18 -0400, Andrew Sullivan wrote: On Thu, Apr 03, 2014 at 10:34:32AM -0300, Leonardo M. Ramé wrote: What strategy for showing the total number of records returned do you recommend?. The best answer for this I've ever seen is to limit the number of rows you're

Re: [GENERAL] Pagination count strategies

On 2014-04-03 17:19:56 +0200, Torsten Förtsch wrote: On 03/04/14 15:34, Leonardo M. Ramé wrote: Hi, in one of our systems, we added a kind of pagination feature, that shows N records of Total records. To do this, we added a count(*) over() as Total field in our queries in replacement

Re: [GENERAL] Complex query

On 2014-03-31 18:48:58 +, Igor Neyman wrote: -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- ow...@postgresql.org] On Behalf Of Leonardo M. Ramé Sent: Monday, March 31, 2014 2:38 PM To: PostgreSql-general Subject: [GENERAL] Complex query

[GENERAL] Complex query

the StatusCode sequence was S followed by T. In this example, the query should only return task Nº 2: 2 R Registered 2 S Started 2 T Transcribed 2 F Finished Can anybody help me with this?. Regards, -- Leonardo M. Ramé Medical

Re: [GENERAL] Complex query

On 2014-03-31 11:46:28 -0700, David Johnston wrote: Leonardo M. Ramé-2 wrote Hi, I'm looking for help with this query. Table Tasks: IdTask StatusCode StatusName -- 1 R Registered 1 S Started 1 D

Re: [GENERAL] Complex query

On 2014-03-31 12:16:53 -0700, David Johnston wrote: Leonardo M. Ramé-2 wrote select lag.id, lag.idtask, lag.code, lag.lg from (select idtask, code, id, lag(code, -1) over () as lg from tasks_test) as lag First you want to include an ORDER BY in the OVER(...) clause, and probably

[GENERAL] Determine Client Encoding

Hi, we found characters with different enconding in our database. As our system is accessed by many PCs I would like to know if it's possible to know the encoding of each connection, without going to each PC to check its connection string. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A

Re: [GENERAL] Determine Client Encoding

another client. Right?. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54 9 (011) 40871877 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

[GENERAL] pg_dump/pg_restore issues

need blob data. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54 9 (011) 40871877 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] pg_dump/pg_restore issues

On 2014-02-19 10:08:19 -0800, bricklen wrote: On Wed, Feb 19, 2014 at 9:57 AM, Leonardo M. Ramé l.r...@griensu.comwrote: Hi, I'm backing up a big database using the --exclude-table option for two tables, say table1 and table2. Then another backup of only those tables, so, the final result

Re: [GENERAL] pg_dump/pg_restore issues

On 2014-02-19 10:23:58 -0800, Adrian Klaver wrote: On 02/19/2014 10:08 AM, bricklen wrote: On Wed, Feb 19, 2014 at 9:57 AM, Leonardo M. Ramé l.r...@griensu.com mailto:l.r...@griensu.com wrote: Hi, I'm backing up a big database using the --exclude-table option for two tables, say

[GENERAL] pg_restore issue

fkidturno; Why is this happening?, should I change the command I'm using to create the backup?. To backup the database I'm using: pg_dump -Fc -h 127.0.0.1 -U postgres mydb my_dump.backup P.S.: the original db is PostgreSql 8.4, the target is 9.2 Regards, -- Leonardo M. Ramé Medical IT - Griensu

Re: [GENERAL] pg_restore issue

On 2014-02-12 09:51:10 -0800, Adrian Klaver wrote: On 02/12/2014 09:41 AM, Leonardo M. Ramé wrote: Hi, I'm trying to restore a database dump using pg_restore with the following parameters: pg_restore -h 127.0.0.1 -U _postgresql \ -c -d postgres --exit-on-error \ my_dump.backup

Re: [GENERAL] pg_restore issue

; 2612 213488 PROCEDURAL LANGUAGE plpgsql postgres pg_restore: [archiver (db)] could not execute query: ERROR: language plpgsql already exists Command was: CREATE PROCEDURAL LANGUAGE plpgsql; -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel

Re: [GENERAL] pg_restore issue

--exit-on-error because there were many errors, and I wanted to fix each one of them. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54 9 (011) 40871877 -- Sent via

[GENERAL] Filtering queries by IP

Hi, I'm trying to find the cause of slow performance on some screens of an application. To do that, I would like to be able to log all the queries made by an specific IP addres, is this possible?. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT

[GENERAL] Londiste3 (SkyTools3)

M. Ramé http://leonardorame.blogspot.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] AutoVacuum Daemon

this on this page: http://www.postgresql.org/docs/8.4/static/routine-vacuuming.html#AUTOVACUUM P.S.: I'm on linux running PostgreSql 8.4 Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19

Re: [GENERAL] AutoVacuum Daemon

On 2013-12-30 13:45:43 +, Haribabu kommi wrote: On 30 December 2013 19:11 Leonardo M. Ramé wrote: Hi, I want know if I should run the auto-vacuum daemon (from /etc/init.d/) or it runs automatically and transparently if configured in postgres.conf?. If it must be configured manually

[GENERAL] Alter table never finishes

Hi, I need to do an alter table on a small table (~300 records), but it never ends. It may be because there are clients using that table. How can I force disconnect all clients to let me alter that table?. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8

Re: [GENERAL] Alter table never finishes

used: select pg_cancel_backend(pid) from pg_stat_activity where pid pg_backend_pid(); And it returned this: pg_cancel_backend --- t t (2 rows) But when I execute my update table command, it still never ends...Any hint?. -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón

Re: [GENERAL] Alter table never finishes

On 2013-07-30 10:26:39 -0700, bricklen wrote: On Tue, Jul 30, 2013 at 10:07 AM, Leonardo M. Ramé l.r...@griensu.comwrote: select pg_cancel_backend(pid) from pg_stat_activity where pid pg_backend_pid(); And it returned this: pg_cancel_backend --- t t (2

[GENERAL] Spellcheck function

Hi, I need to implement a spell cheker for a client-server application with a shared dictionary. I was thinking of implementing it as a Postgres function, but, before that I would like to know if it or something similar is already implemented. Regards, -- Leonardo M. Ramé Medical IT - Griensu

Re: [GENERAL] Parsing COPY ... WITH BINARY

On 2013-01-31 17:38:26 -0600, Merlin Moncure wrote: On Thu, Jan 31, 2013 at 8:47 AM, Leonardo M. Ramé l.r...@griensu.com wrote: I'm using this: COPY( select field1, field2, field3 from table ) TO 'C://Program Files/PostgreSql//8.4//data//output.dat' WITH BINARY To export some fields

[GENERAL] Parsing COPY ... WITH BINARY

cannot export as CSV, because the binary data is modified when I do that. -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54 9 351 6629292 -- Sent via pgsql-general mailing list

[GENERAL] pg_dump problem

a PostgreSql version. I must point out this is not my case, both sides are running PostgreSql versions, the Linux side is running the one from the official repository, and the Windows one is running an old 8.3 version downloaded from postgresql.org. Any hint?. Regards, -- Leonardo M. Ramé Medical

[GENERAL] Upgrading 8.3-rc1 to 8.3.20

overwrite the 8.3-rc1 directory?. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54 9 351 6629292 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] Upgrading 8.3-rc1 to 8.3.20

On 2012-10-03 16:51:59 +0200, Andreas Kretschmer wrote: Raymond O'Donnell r...@iol.ie wrote: On 03/10/2012 15:21, Leonardo M. Ramé wrote: I want to upgrade an 8.3-rc1 to 8.3.20 Win32 server (I cannot upgrade to 8.4 nor 9.1 because the client app doesn't support them). The question

Re: [GENERAL] Linux PowerPC 64bits issue

postgresql-9.1.5.tar.gz cd postgresql-9.1.5 ./configure make make install This, apart from copying the server files, created the /usr/local/pgsql/lib directory, where I have libpq.so and many more shared libraries. -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT

Re: [GENERAL] Linux PowerPC 64bits issue

, Leonardo M. Ramé wrote: On 2012-09-27 11:51:46 +0800, a...@hsk.hk wrote: Hi, Could you provide the steps and commands you used to compile 9.1? I want to reproduce your case in my machine Regards Arthur Yes, I downloaded postgresql-9.1.5.tar.gz from the PostgreSql web

Re: [GENERAL] Linux PowerPC 64bits issue

On 2012-09-27 06:53:57 -0700, Adrian Klaver wrote: On 09/27/2012 04:46 AM, Leonardo M. Ramé wrote: On 2012-09-27 11:51:46 +0800, a...@hsk.hk wrote: Hi, Could you provide the steps and commands you used to compile 9.1? I want to reproduce your case in my machine Regards Arthur Yes

Re: [GENERAL] Linux PowerPC 64bits issue

On 2012-09-27 06:53:57 -0700, Adrian Klaver wrote: On 09/27/2012 04:46 AM, Leonardo M. Ramé wrote: On 2012-09-27 11:51:46 +0800, a...@hsk.hk wrote: Hi, Could you provide the steps and commands you used to compile 9.1? I want to reproduce your case in my machine Regards Arthur Yes

Re: [GENERAL] Linux PowerPC 64bits issue

On 2012-09-27 11:02:48 -0300, Leonardo M. Ramé wrote: On 2012-09-27 06:53:57 -0700, Adrian Klaver wrote: On 09/27/2012 04:46 AM, Leonardo M. Ramé wrote: On 2012-09-27 11:51:46 +0800, a...@hsk.hk wrote: Hi, Could you provide the steps and commands you used to compile 9.1? I want

Re: [GENERAL] Linux PowerPC 64bits issue

On 2012-09-27 11:21:04 -0300, Leonardo M. Ramé wrote: On 2012-09-27 11:02:48 -0300, Leonardo M. Ramé wrote: On 2012-09-27 06:53:57 -0700, Adrian Klaver wrote: On 09/27/2012 04:46 AM, Leonardo M. Ramé wrote: On 2012-09-27 11:51:46 +0800, a...@hsk.hk wrote: Hi, Could you provide

[GENERAL] Linux PowerPC 64bits issue

?. Regards, -- Leonardo M. Ramé Medical IT - Griensu S.A. Av. Colón 636 - Piso 8 Of. A X5000EPT -- Córdoba Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19 Cel.: +54 9 351 6629292 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

  1   2   >