El 20/07/17 a las 16:57, Andreas Kretschmer escribió:
On 20 July 2017 21:46:09 GMT+02:00, "Leonardo M. Ramé"
wrote:
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)
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
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 - Griensu S.A.
Av. Coló
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 +5
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.or
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
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órdob
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)
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. 1
Total runtime: 36106.813 ms
(14 rows)
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
re 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@postgresql.org)
To make changes to
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.
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.org)
To
mydb=# 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-ge
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
nection '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 +
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
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
o
existe el archivo 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 -
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/sky
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.
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 it
I do to remove
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 you
2197
+--: 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(3
same 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.:
;.
And 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
mean when I do "select * from log" 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
--
S
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é"
To: "PostgreSql-general"
Sent: Saturday, 12 March, 2016 8:25:01 PM
Subject: [GENERA
hild servers,
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
X5000
El 26/02/16 a las 17:11, s d escribió:
On 26 February 2016 at 21:02, Leonardo M. Ramé 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é
mailto:l.r...@griensu.com>
<mailto:l.r...
El 26/02/16 a las 16:49, s d escribió:
On 26 February 2016 at 20:42, Leonardo M. Ramé 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 definitions?
I don't und
El 26/02/16 a las 16:33, s d escribió:
On 26 February 2016 at 20:19, Leonardo M. Ramé 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é
mailto:l.r...@griensu.com>
<mailto:l.r...
El 26/02/16 a las 16:18, s d escribió:
On 26 February 2016 at 20:02, Leonardo M. Ramé 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:
Hi, I created a Postgres_FDW table (TABLE_
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
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
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
$2
WHERE 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
--
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.
ot open 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 subs
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
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 yo
El 13/11/15 a las 10:49, Merlin Moncure escribió:
On Fri, Nov 13, 2015 at 7:20 AM, Leonardo M. Ramé wrote:
Hi, is there a way to get an array converted to json without brackets?.
I'm getting, for example [{"field": "value"}, {"field": "value&quo
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"}.
Regar
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?=" writes:
Hi, I'm trying to build the client library of PostgreSql 9.3.x using
this version of MinGW's gcc:
Nevermind, deleted my Min
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 "-I../../src/include/port
]: Leaving directory 'E:/postgresql-9.3.10/src'
GNUmakefile:11: recipe for target 'all-src-recurse' failed
mingw32-make: *** [all-src-recurse] 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
s already 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
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é" wrote:
DELETE From sessions WHERE SESSIONTIMESTAMP < '2010-01-01 10:02:02'
ERROR: column "sessiontimestamp" does not exist
LINE 1: DELETE Fro
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&q
El 26/03/15 a las 14:17, Ashesh Vashi escibió:
[Sent through mobile]
On Mar 26, 2015 10:43 PM, Leonardo M. Ramé mailto:l.r...@griensu.com>> wrote:
>
> Ok, I have this table:
>
> CREATE TABLE sessions
> (
> "SESSIONID" integer NOT NULL,
> "S
* Error **
ERROR: column "sessiontimestamp" does not exist
SQL state: 42703
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 quot
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 n
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 o
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 zo
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
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é
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
e 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
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
El 10/10/14 a las 14:50, vibhor.ku...@enterprisedb.com escibió:
On Oct 10, 2014, at 1:27 PM, 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
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 "mysq
ike "\insert for select * from table 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
>
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.
Av. Colón 636 - Piso 8 Of. A
X5000EPT -- Córdoba
Tel.: +54(351)4246
data directory was copied without problems.
At the end, 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)
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 To
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 see
o you
recommend?.
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
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(...)
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
e 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é
Medic
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
ers could have
been sent in utf8 ?.
If this is the case, the insert/update is done, but cannot be read from
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
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 - Griens
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é
> >mailto:l.r...@griensu.com>> wrote:
> >
> >Hi, I'm backing up a big database using the --exc
On 2014-02-19 10:08:19 -0800, bricklen wrote:
> On Wed, Feb 19, 2014 at 9:57 AM, Leonardo M. Ramé wrote:
>
> > 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, s
e we
don't 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)
be seamless, and one of the ways it tends to not be seamless is
> that you have to be willing to ignore harmless errors.
>
Ok, I understand your reasoning. Removing -c and --exit-on-error fixed
the issue.
BTW, I've used --exit-on-error because there were many errors, and I wanted
to fi
ards, tom lane
Tom, I've dropped the db, then createdb again, then removed the -c
option, now I get this error:
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 735; 2612 213488
PROCEDURAL LANGUAGE plpgsql postgres
pg_restore: [archiver (
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 \
>
documento DROP CONSTRAINT
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
Re
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
X50
rial?.
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
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
ut 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)
On 2013-07-30 10:26:39 -0700, bricklen wrote:
> On Tue, Jul 30, 2013 at 10:07 AM, Leonardo M. Ramé wrote:
>
> >
> > select pg_cancel_backend(pid) from pg_stat_activity where pid <>
> > pg_backend_pid();
> >
> > And it returned this:
> >
> > p
L Training, Services and Support
> giuseppe.brocc...@2ndquadrant.it | www.2ndQuadrant.it
>
Thanks to both, Giuseppe and Bricklen. As I have 9.2 I've used:
select pg_cancel_backend(pid) from pg_stat_activity where pid <>
pg_backend_pid();
And it returned this:
pg_cancel_backend
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 Of. A
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
On 2013-01-31 17:38:26 -0600, Merlin Moncure wrote:
> On Thu, Jan 31, 2013 at 8:47 AM, Leonardo M. Ramé wrote:
> > I'm using this:
> >
> > COPY( select field1, field2, field3 from table ) TO 'C://Program
> > Files/PostgreSql//8.4//data//output.dat' WITH
s file?
BTW: I 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-gener
e other is running 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,
--
Leonard
On 2012-10-03 16:51:59 +0200, Andreas Kretschmer wrote:
> Raymond O'Donnell 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
just 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.or
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,
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
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?
> >>
&g
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?
> >>
&g
; Arthur
>
> On 27 Sep 2012, at 7:46 PM, 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 reprodu
e,
then did this:
tar xvfz 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.
A
compile in 64 bits?.
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 c
1 - 100 of 102 matches
Mail list logo
