[GENERAL] JSONB Overlap Operator.

n that operator was not included on JSONB? Best regards, Eduardo Felipe. E3C Tecnologia

Re: [GENERAL] Storing files: 2.3TBytes, 17M file count

sh (Tiger Tree Hash often) of file content to allow multi peer to peer copy. > Regards, > Thomas Güttler > > > Related question at rsnapshot mailing list: > https://sourceforge.net/p/rsnapshot/mailman/rsnapshot-discuss/thread/57a1a2f3.5090...@thomas-guettler.de/ > -- >

Re: [GENERAL] postgres MultiXact 9.3 corruption resolved but advice needed

"MultiXactId NNN has not been created yet -- apparent wraparound". --- --- Eduardo Morras -- 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] Clustered index to preserve data locality in a multitenant application?

On Wed, 31 Aug 2016 17:33:18 +0200 Nicolas Grilly wrote: > Eduardo Morras wrote: > > > > Check BRIN indexs, they are "designed for handling very large > > tables in which certain columns have some natural correlation with > > their physical location within t

Re: [GENERAL] Clustered index to preserve data locality in a multitenant application?

ging Partner > +33 6 03 00 25 34 > www.vocationcity.com ? Recruitment & application tracking software > www.gardentechno.com ? Consulting & software engineering --- --- Eduardo Morras -- 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] Streaming Replica Master-Salve Config.

On Fri, 5 Aug 2016 12:43:43 -0700 John R Pierce wrote: > On 8/4/2016 9:15 AM, Eduardo Morras wrote: > > If you set max_connections too high, those connections will > > compete/figth for same resources, CPU processing, I/O to disks, > > Memory and caches, Locks, and postgres

Re: [GENERAL] Streaming Replica Master-Salve Config.

use a bouncer like pgbouncer. It can run on the same server. > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general --- --- Eduardo Morras -- Sent via pgsql-

Re: [GENERAL] Is it possible to use an EVENT TRIGGER to validate a TRIGGER?

Hi Álvaro, thanks for your reaponse. Can you please give me a small example showing how to do this, or more hints? Thanks in advance, Luis Lizardo On Jul 6, 2016 00:02, "Alvaro Herrera" wrote: > Luís Eduardo Oliveira Lizardo wrote: > > Hi, > > > > Is it poss

[GENERAL] Is it possible to use an EVENT TRIGGER to validate a TRIGGER?

Hi, Is it possible to use an EVENT TRIGGER to validate a TRIGGER definition? What I want is to guarantee that the trigger is fired AFTER a STATEMENT, on INSERT or UPDATE but not on DELETE, like the following example: CREATE TRIGGER mytrigger AFTER INSERT OR UPDATE ON mytable FOR EACH STAT

Re: [GENERAL] [HACKERS] Online DW

/docs/latest/tutorial-en.html#replication-config Read full documentation, above url cites point directly to the replication part but read full documentation. HTH > Thanks > Sridhar > Opentext --- --- Eduardo Morras -- Sent via pgsql-general mailing list (pgsql-general@postgr

Re: [GENERAL] [HACKERS] Online DW

/docs/latest/tutorial-en.html#replication-config Read full documentation, above url cites point directly to the replication part but read full documentation. HTH > Thanks > Sridhar > Opentext --- --- Eduardo Morras -- Sent via pgsql-general mailing list (pgsql-general@postgr

[GENERAL] Disconnected but query still running

no one on the other end of the tcp connection? Thanks. Eduardo -- 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] Ever increasing pg_clog disk usage v8.4

> which is the problem > > Does anyone know how I can reclaim the every growing ramdisk space? It may be a bug corrected in newer 8.4 versions, update. A fast hack will be close the application connected to PostgreSQL, it will close the transactions. Better, rewrite your app to op

Re: [GENERAL] large table

GB size tables with few rows and a permament 'IDLE in TRANSACTION' stops any autovacuum. --- --- Eduardo Morras -- 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] pg_dump slower than pg_restore

there's nothing wrong. All transparent compressed objects stored in database, toast, lo, etc.. is transparently decompressed while pg_dump access them and then you gzip it again. I don't know why it doesn't dump the compressed data directly. > > Thanks, >

Re: [GENERAL] Upgrading from 9.2 to 9.3 causes performance degradation

n Times (average time of three executions, in seconds) > > ++---+---+ > | Server | 9.2 | 9.3 | > ++---+---+ > | Old| 129 | 216 | > ++---+---+ > | New| 118 | 275 | > ++---+---+ > > Thank

Re: [GENERAL] High Level Committers Wanted

to spare in funky threats ;) --- --- Eduardo Morras -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Re: [GENERAL] Help on ṕerformance

2013/10/2 Merlin Moncure > On Mon, Sep 30, 2013 at 10:03 AM, Carlos Eduardo Sotelo Pinto > wrote: > > > > I need a help on postgresql performance > > > > I have configurate my postgresql files for tunning my server, however it > is > > slow and cpu resources

Re: [GENERAL] upgrade from 9.2.x to 9.3 causes significant performance degradation

ics says so. b) Did you configure postgresql.conf on 9.3.0 for your server/load? Perhaps it has default install values. c) What does logs say? > thanks > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > htt

Re: [GENERAL] How to compare the results of two queries?

- Not sure about this one because uses COUNT on a hstore data column. > Thanks in advance. > Best regards from Cuba. --- --- Eduardo Morras -- 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] Call for design: PostgreSQL mugs

a cool idea? Please let us know. Either reply here or send > an email to pgeu-bo...@postgresql.org. CREATE OR REFILL mug{ id_owner INTEGER PRIMARY KEY, owner_name VARCHAR(40), CONSTRAINT id_owner PRIMARY KEY (mug), CONSTRAINT fk_content FOREIGN KEY (content) REFERENCES content (co

Re: [pgeu-general] [GENERAL] Call for design: PostgreSQL mugs

with "Elephant Inside" logo. --- --- Eduardo Morras -- 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] Call for design: PostgreSQL mugs

a cool idea? Please let us know. Either reply here or send > an email to pgeu-bo...@postgresql.org. A big yellow elephant? Perhaps with a nice smile? Oh it's already taken ;) > > > Thanks, --- --- Eduardo Morras -- Sent via pgsql-general mailing list (pgsql-general@p

Re: [GENERAL] new instance of postgres on windows

ith the configuration you want. Run. --- --- Eduardo Morras -- 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] Postgresql, sql client and I/O exceptions

if you might know the cause it would > help me tremendously. > If it's under Linux, check that Out of Memory Killer don't slain some postmaster process. Disable it and try again. > -- > Paul Anthony Maddock --- --- Eduardo Morras -- 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] Replication with Drop: could not open relation with OID

iew to the table that enforces current data version. Add new data using a new data version number. When you want to switch, update the view and delete old version data. You must add version column as the first index entry on the indexes you create. HTH > > Regards --- --- Eduardo M

Re: [GENERAL] Best way to reduce server rounds getting big BLOBs

fs that aren't in db or viceversa, images with different url in db and fs, etc...). -- >Many thanks in advance, and sorry if the question is too naive. >-- >Jorge Arevalo >Freelance developer -- Eduardo Morras -- 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] Storing small image files

ront-end developers to whip out some PHP > just to be safe. > > Thanks to all! --- --- Eduardo Morras -- 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] What's wrong with postgresql.org domain?

mirrors.postgresql.org Address: 217.196.149.50 In 87.238.57.232 (Sweeden) 98.129.198.126(San Antonio,TX) and 217.196.149.50(Saltzburg) i get lighttpd default page. Perhaps a miss configuration on my ISPs dns. I'll try with home connection this afternoon. Thanks --- --- Eduardo Morras

Re: [GENERAL] What's wrong with postgresql.org domain?

On Thu, 18 Apr 2013 18:40:40 +1000 Chris Angelico wrote: > On Thu, Apr 18, 2013 at 6:33 PM, Magnus Hagander wrote: > > On Thu, Apr 18, 2013 at 10:31 AM, Eduardo Morras wrote: > >> > >> > >> I get Godaddy's page saying it's free > > > >

[GENERAL] What's wrong with postgresql.org domain?

I get Godaddy's page saying it's free --- --- Eduardo Morras -- 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] Backup advice

On Mon, 15 Apr 2013 19:54:15 -0700 Jeff Janes wrote: > On Tue, Apr 9, 2013 at 3:05 AM, Eduardo Morras > > > wrote: > > > On Mon, 8 Apr 2013 10:40:16 -0500 > > Shaun Thomas > 'stho...@optionshouse.com');>> wrote: > > > > > >

Re: [GENERAL] Backup advice

On Mon, 8 Apr 2013 10:40:16 -0500 Shaun Thomas wrote: > > Anyone else? > If his db has low inserts/updates/deletes he can use diff between pg_dumps (with default -Fp) before compressing. --- --- Eduardo Morras -- Sent via pgsql-general mailing list (pgsql-general@postgresq

Re: [GENERAL] PostgreSQL: CPU utilization creeping to 100%

dware errors) reconstructing the raidz should show what you say. Check the output of #zpool status when the "cpu storm" happens. c) If you do a simple #top -U postgres (or the user that executes your postgres server), what does the STATE column show? Check that to know the kernel st

Re: [GENERAL] Gitorious

tax and mysql tricks. > Elle > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general --- --- Eduardo Morras -- 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] pg_Restore

On Mon, 21 Jan 2013 22:16:00 +0530 bhanu udaya wrote: > Hello All, > Can we achieve this template or pg_Restore in less than 20 minutes time. Any > more considerations. Kindly reply. Thanks and RegardsRadha Krishna From: > udayabhanu1...@hotmail.com Perhaps you can use the ntfs snapshot featu

Re: [GENERAL] reducing number of ANDs speeds up query RESOLVED

state. > T. > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general --- --- Eduardo Morras -- 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] reducing number of ANDs speeds up query

stgreSQL to do first the initial "WHERE ... AND > ... AND" and then the last "AND b.value=..." on the (very small) result? > > Thank you and kind regards, > T. --- --- Eduardo Morras -- 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] UFS2 Snapshots and Postgres

At 15:16 25/06/2012, you wrote: On 6/25/2012 7:35 AM, Eduardo Morras wrote: Hi everyone, I'm using FreeBSD 9 for Postgres and want to know if these actions are safe for make a backup of the database: a) call pg_start_backup('b1') b) take an UFS2 snapshot of dat

[GENERAL] UFS2 Snapshots and Postgres

Hi everyone, I'm using FreeBSD 9 for Postgres and want to know if these actions are safe for make a backup of the database: a) call pg_start_backup('b1') b) take an UFS2 snapshot of data files c) call pg_stop_backup() d) change to the snapshot dir and rsync/dd/dump/transfer it to backup file

Re: [GENERAL] Backing up through a database connection (not pg_dump)

At 01:05 27/03/2012, Tim Uckun wrote: Is there a way to backup a database or a cluster though a database connection? I mean I want to write some code that connects to the database remotely and then issues a backup command like it would issue any other SQL command. I realize the backups would nee

Re: [GENERAL] Don't Thread On Me (PostgreSQL related)

At 00:32 27/01/2012, you wrote: There are cases where intraquery parallelism would be helpful. As far as I understand it, PostgreSQL is the only major, solid (i.e. excluding MySQL) RDBMS which does not offer some sort of intraquery parallelism, and when running queries across very large datab

Re: [GENERAL] Refine Form of My querry

At 11:11 29/12/2011, you wrote: Hi every1 how are u all??? Members i am new in postgres and want to work on pgrouting but i am facing some issue with it. Will u please help me??? I have loaded my line shapefile in pgadmin environment, which creates a table name 'Route', but when i made a query 'C

Re: [GENERAL] Hope for a new PostgreSQL era?

Sorry for delay, I wonder if the prioritisation could be done using nice - each backend is a separate process, so why not to do 'nice(10)' for low priority processes or something like that. Yes, to a limited degree you can prioritise queries using nice and ionice, but it's awkward because

Re: [GENERAL] odbc_fdw

At 16:27 28/11/2011, you wrote: Hi there! I built the current PostgreSQL 9.1.1 sources under Ubuntu 11.04 (in a VMware under Win7). I followed the steps in this guide: www.thegeekstuff.com/2009/04/linux-postgresql-install-and-configure-from-source It seems to work (I can run the server and co

Re: [GENERAL] PostGIS in a commercial project

At 09:26 21/10/2011, Thomas Kellerer wrote: Hello, we are using PostgreSQL in our projects and would like to integrate PostGIS as well. Now PostGIS is licensed under the GPL and I wonder if we can use it in a commercial (customer specific) project then. The source code will not be made open

Re: [GENERAL] Searching for "bare" letters

At 01:25 02/10/2011, Reuven M. Lerner wrote: Hi, everyone. I'm working on a project on PostgreSQL 9.0 (soon to be upgraded to 9.1, given that we haven't yet launched). The project will involve numerous text fields containing English, Spanish, and Portuguese. Some of those text fields w

Re: [GENERAL] postgres for OLAP & data mining

At 16:12 30/09/2011, Dario Beraldi wrote: Hello, I'm looking for some information (guidelines, docs, tutorials, etc...) about using postgres for OLAP, data mining, data warehousing. The sort of questions I'm trying to answer are on the lines of - What tools/SQL commands are available? - How s

Re: [GENERAL] looking for a faster way to do that

At 18:18 26/09/2011, you wrote: Eduardo Morras wrote: >> >> At 08:04 25/09/2011, haman...@t-online.de wrote: >> >> > >> select * from items where regexp_matches(items.code,'(ABC) (DE1) >> > >> (any_substring)')<>{}; >>

Re: [GENERAL] looking for a faster way to do that

At 08:04 25/09/2011, haman...@t-online.de wrote: >> select * from items where regexp_matches(items.code,'(ABC) (DE1) >> (any_substring)')<>{}; >> Hi Eduardo, it is clear that scanning the table once with a list of matches will outperform rescanning the tabl

Re: [GENERAL] Speed of lo_unlink vs. DELETE on BYTEA

At 07:43 25/09/2011, Reuven M. Lerner wrote: Hi, everyone. Daniel Verite wrote: It would thus appear that there's a slight edge for dumping bytea, but nothing super-amazing. Deleting, however, is still much faster with bytea than large objects. The pro

Re: [GENERAL] looking for a faster way to do that

At 14:12 23/09/2011, haman...@t-online.de wrote: Eduardo Morras wrote: >> You can try these, i doubt they will use any index but its a >> different approach: >> >> select * from items where length(items.code)<>length(rtrim(items.code,'ABC')); >>

Re: [GENERAL] looking for a faster way to do that

At 09:45 23/09/2011, haman...@t-online.de wrote: A single anchored query select * from items where code ~ '^ABC'; does indeed use the index to retrieve data. So I wonder whether there might be a different approach to this problem rather than pattern matching. I recall I had a similar problem

Re: [GENERAL] Bit datatype performance?

ssed your mind. Maybe with some refinement, you can get to something more practical. But nonetheless (if I'm not missing something huge), the *where *statement you provided is just the wrong approach to tags. hope it helps, regards, eduardo On Wed, Sep 14, 2011 at 12:58 PM, Antonio Vieiro wrote: &

Re: [GENERAL] Re: Need help with what I think is likely a simple query - for each distinct val, return only one record with the most recent date.

the original, simpler (but flawed) query, which as it clearly shows computes val2's of 14, 15, 16, 23, 22 and 21, beging those last 3 (23, 22 and 21) from another date associated with val1 (which is not the max date, so they shouldn't have been considered at all). select val1, max(date),

Re: [GENERAL] Foreign key check only if not null?

using a varchar(100), well, it's your call. regards, eduardo On Mon, Sep 12, 2011 at 10:48 PM, Phoenix Kiula wrote: > Hi, > > I bet this is a simple solution but I have been racking my brains. > > I have a column in my table: > >user_id varchar(100) ; > > This

Re: [GENERAL] feature request - update nowait

nctively use an equals over an in for a single record match, whatever the context is). Considering of course it is a pk. If multiple rows should be affected by the update, well an in would then be way, but I don't think it will be the case for me. Thanks again! Eduardo PS: Please feel free to mai

Re: [GENERAL] feature request - update nowait

I'm sorry, isn't it meant for table locks? I was talking about row level locking. Eduardo 2011/9/8 pasman pasmański > Try a command LOCK NOWAIT > > 2011/9/8, Eduardo Piombino : > > Hi, would it be possible to implement a *nowait *modifier to the > > *update*state

Re: [GENERAL] feature request - update nowait

Nice. Much more maintainable IMO and quite close to what I was looking for. Thanks a lot for the suggestion, I will definitely try it/implement it right away. Still has some redundancy compared to an hypothetical nowait modifier but I think it's the very best alternative so far. Eduardo O

[GENERAL] feature request - update nowait

forces me to do a select for update before every update on which I need the fastest response possible, and it would be great if it could be integrated into the command itself. Just an idea. Best regards, Eduardo.

Re: [GENERAL] Lock problem

t;b". SQL state: 55P03 Regarding my original question, I would like to know if this is a known issue/feature/bug/unwanted optimization consequence/or is it just a normal behavior that I should've had predicted. Best regards, Eduardo. On Wed, Sep 7, 2011 at 9:29 PM, Tom Lane wrote: &

[GENERAL] Lock problem

n T1 will prevent T2 from getting a row level lock on B. Does anyone have an explanation on why this happens? Thank you, Eduardo.

Re: [GENERAL] Vacuum as "easily obtained" locks

At 19:32 03/08/2011, you wrote: On 08/03/11 10:21 AM, Eduardo Morras wrote: One question, while you run your tests, does "IDLE IN TRANSACTION" messages happen? If you run your tests with a permanent connection to database, the tables are locked and autovacuum cannot work. its not t

Re: [GENERAL] Vacuum as "easily obtained" locks

At 16:35 03/08/2011, Michael Graham wrote: Yeah it said it last ran yesterday (and is currently running now), but I did I notice in the log: 2011-08-02 19:43:35 BST ERROR: canceling autovacuum task 2011-08-02 19:43:35 BST CONTEXT: automatic vacuum of table "traffic.public.logdata5queue" Which

Re: [GENERAL] Web Hosting

At 17:24 06/03/2011, you wrote: On 3/5/2011 4:08 PM, matty jones wrote: I already have a domain name but I am looking for a hosting company that I can use PG with. The few I have contacted have said that they support MySQL only and won't give me access to install what I need or they want way

Re: [GENERAL] select now() problem?

. But i'm not sure about the real gain of that. On Thu, Sep 2, 2010 at 2:56 PM, Tom Lane wrote: > Eduardo Piombino writes: > > Do you have any idea on what could be causing a SELECT NOW() to never > come > > back? > > That's truly bizarre. Can you attach to one

[GENERAL] select now() problem?

all connections to the database are dropped, and after that it doesnt present the problem anymore for at least a month). It has happened approximately 4 or 5 times already. Thank you, Eduardo.

Re: [GENERAL] searchable book database

On Thu, 19 Aug 2010 20:35:50 +0100 Miguel Vaz wrote: > Hi, > > I need to make a database of books. Several specific subject books > that are to be searchable. > > Is it viable to have the complete book text on a database and search > inside it? Or should i consider keeping only its metadata (na

Re: [GENERAL] Date with time zone

On Mon, Nov 30, 2009 at 7:22 AM, Martijn van Oosterhout wrote: > On Mon, Nov 30, 2009 at 01:51:33AM -0300, Eduardo Piombino wrote: > > Analysis of the extra complications added by DST's does not add anything, > > yet, to the point I'm trying to make, regardless th

Re: [GENERAL] Date with time zone

On Sun, Nov 29, 2009 at 8:23 PM, Adrian Klaver wrote: > On Sunday 29 November 2009 2:38:43 pm Eduardo Piombino wrote: > > On Sat, Nov 28, 2009 at 8:55 PM, Adrian Klaver > wrote: > > > On Saturday 28 November 2009 3:41:42 pm Eduardo Piombino wrote: > > > >

Re: [GENERAL] Date with time zone

On Sat, Nov 28, 2009 at 8:55 PM, Adrian Klaver wrote: > On Saturday 28 November 2009 3:41:42 pm Eduardo Piombino wrote: > > Hi Adrian, thanks for your answer. > > > > I see current criteria and all the SQL-standard compliance policy, but > > wouldn't it still

Re: [GENERAL] Date with time zone

ociated time zone, I think. Am I wrong on this? Apart from what SQL Standard may say, for instance. On Sat, Nov 28, 2009 at 4:00 PM, Adrian Klaver wrote: > On Saturday 28 November 2009 3:43:02 am Eduardo Piombino wrote: > > Hello list, this is my first msg here. I hope this is

[GENERAL] Date with time zone

cifying that that "date" actually corresponds to a specific timezone, but in the same manner that u dont need an extra column for time values (cause u have the "time with time zone"), you shouldn't be needing to create another one to host the time zone for the date. I don't know, am I crazy? Thanks a lot. Eduardo.

Re: [GENERAL] Postgresql Web Hosting

sn't a resource >intensive site. I use http://www.hub.org/ . They offer vps, web hosting and access to postgres 8.x and mysql databases. >Thanks, >Matt HTH Eduardo Morrás González Dept. I+D+i e-Crime Vigilancia Digital S21sec Labs Tlf: +34 902 2

Re: [GENERAL] WAL and master multi-slave replication

At 19:25 24/06/2009, you wrote: On Wed, Jun 24, 2009 at 11:22 AM, Eduardo Morras wrote: > Yes, there will be 3 masters recolleting data (doing updates, inserts and > deletes) for now and 5 slaves where we will do the searches. The slaves must > have all the data recollected by the 3

Re: [GENERAL] WAL and master multi-slave replication

At 19:05 24/06/2009, Alvaro Herrera wrote: Eduardo Morras wrote: Hi, > I'm currently building a Pg multiserver and have a question about the > possibility of working with WAL in a multislave environment. > > I have few master servers (write only) and multiple slave servers

[GENERAL] WAL and master multi-slave replication

EATE TABLE "WAL_Table" ( create_date timestamp with time zone NOT NULL, wal bytea, CONSTRAINT idx1 PRIMARY KEY (create_date) ) Thanks in advance ---- Eduardo Morrás González Dept. I+D+i e-Crime Vigilancia Digital S21sec Labs Tlf: +34 902 222 521 Mó

Re: [GENERAL] Postgres 8.2 Memory Tuning

At 08:56 16/06/2009, you wrote: Hi, I need to measure the memory used by postgres under various loads in my application.How to calculate the exact memory used by postgres for OS:Windows as well as linux ? Download ProcessXP from Microsoft (before it was from Sysinternals). There you

[GENERAL] Postgres Security Checklist

help me in this work. Tranks! Eduardo Henrique(Hitek) - www.eduardohitek.blogspot.com Desenvolvimento SoftSite - www.softsite.com.br

[GENERAL] error en createlang

Hola Lista: instale el postgres con el comando ./postgresql-8.3.4-1-linux-x64.bin instale la el postgres en /usr/local/... la base en /base/data como yo uso caracteres en español como los acentos y la ñ Ñ le puse es_ES.utf8 código 231 todo bien hasta que cree una base de datos con: -bash-3.2$ .

[GENERAL] Error al crear una base en español.....

hola quiero crear una base que soporte caracteres en español y le doy este comando pero no crea la base sino me manda este error: -bash-3.2$ ./createdb --encoding=LATIN1 sig_spa_prueba Password: createdb: database creation failed: ERROR: encoding LATIN1 does not match server's locale en_US.UTF-8

[GENERAL] Error en generar base espacial

Hola He instalado el: Porgressql 8.3 en /usr/local/postgres_8.3 Postgis 1.3 en /usr/local/ postgis_13 geos 3 en /usr/local/geos_3 proj46 en /usr/local/proj_46 creo la base de datos pero al momento de incorporar la parte espacial con el siguiente comedo: -bash-3.2$ ./psql -f /usr/local/postgis_13/s

[GENERAL] run postgres 8.3

I installed the 8.3 postgres the amount of giving the command: bash-3.2$ /usr/local/postgres_8.3/bin/initdb -D /base/data the result is: The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initial

[GENERAL] postgres/postgis

hello is campatible install postgresql-8.3.4-1-linux-x64 with postgis-1.3.3. postgis there for 64-bit architecture?? There are the libraries and proj4 GEOS arqitectura for 64-bit??

[GENERAL] failed to install posgrest

Hi I am trying to install the portgres of 64btis in centos 5.6 but at the next command ./postgresql-8.3.4-1-linux-x64.bin the results are as follows: [EMAIL PROTECTED] programas]# ./postgresql-8.3.4-1-linux-x64.bin Welcom

Re: [GENERAL] Problem with copy

Nevermind. It was a problem with the encoding type of the file. --- Eduardo Muñoz <[EMAIL PROTECTED]> escribió: > Hi, I'm trying to copy information from a csv file > using pgadminIII. I run the following command: > > copy cliente from '/path/file.csv' wi

[GENERAL] Problem with copy

Hi, I'm trying to copy information from a csv file using pgadminIII. I run the following command: copy cliente from '/path/file.csv' with csv; The command runs and i get no output. I thought the process could be taking a lot to complete, but i don't think so. I'm trying with just a few records an

[GENERAL] Problem with Transaction

Hi, I'm trying to make a PL/pgSQL function to update or insert if the row is not present. I tested the function and it works fine, but when I call it through JDBC, it executes, but the row is not inserted or updated. This is my JDBC code. try{ connection.setTransactionIsolation

[GENERAL] Problem with function that returns a cursor

I'm new to pgSQL and I'm having some trouble with a function. I keep getting the following error: org.postgresql.util.PSQLException: ERROR: cursor "" does not exist This is the function: CREATE OR REPLACE FUNCTION ret_user(pusername "varchar") RETURNS refcursor AS $BODY$ DECLARE ccursor re

[GENERAL] Problem with Function

Hi, I'm new with pgSQL and I'm not sure why, but I keep getting the same error. I want to call a function that returns a cursor and I keep getting the following exception: org.postgresql.util.PSQLException: ERROR: cursor "" does not exist I would appreciate any help with this problem. This is my

Re: [GENERAL] querying while copying into a table and optimizations

/populate.html > Thank you. A lot of stuff I can't grab yet. Guess I need some more experience administering databases. Sorry about the double mail, I didn't realize I hadn't replied to the list. Lest this be archived. -- David Eduardo Gómez Noguera <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Dump and Restore

I am using pg_dump. It means that I can't restore to a different name database?? Eduardo S. Fontanetti --- Paul Thomas <[EMAIL PROTECTED]> escreveu: > > On 24/08/2004 14:40 Eduardo S. Fontanetti wrote: > > How can I do a test if my dumping is really > working, I &

Re: [GENERAL] INSERT ON DUPLICATE KEY UPDATE

On 2004-06-18 17:19:40 UTC, Duane Lee - EGOVX wrote: > I would suspect you would need to write a trigger to do this. It seems the mysql way of doing this is easier and safer. Why is that not implemented in postgresql? Is it better done with a trigger or with any other way? Edua

[GENERAL] INSERT ON DUPLICATE KEY UPDATE

How may I do a INSERT ON DUPLICATE KEY UPDATE like in mysql: http://dev.mysql.com/doc/mysql/en/INSERT.html ? Eduardo ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] Storing a file hash as primary key

I was wondering what the best way is to store a file hash (MD5 or SHA1) and make it primary key indexed. I have seen some people storing the hexadecimal encoded MD5 in a CHAR(32) but it may be a better idea to use a CHAR(16) without encoding the string, but that may cause some problems. What do yo