Re: [GENERAL] Out of memory condition

2014-12-11 Thread Carlos Henrique Reimer
bytes Max nice priority 00 Max realtime priority 00 Max realtime timeout unlimitedunlimited us [root@2-NfseNet-SGDB ~]# On Thu, Dec 11, 2014 at 6:01 PM, Tom Lane wrote: > Carlos Henrique Reimer writes: > > Yes,

Re: [GENERAL] Out of memory condition

2014-12-11 Thread Carlos Henrique Reimer
014 at 12:05 PM, Carlos Henrique Reimer > wrote: > > That was exactly what the process was doing and the out of memory error > > happened while one of the merges to set 1 was being executed. > > You sure you don't have a ulimit getting in the way? > -- Reim

Re: [GENERAL] Out of memory condition

2014-12-11 Thread Carlos Henrique Reimer
can be scripted. > > Given you got about 50% done before it failed, maybe even 4 sets of 6000 > tables each may work out. > -- Reimer 47-3347-1724 47-9183-0547 msn: carlos.rei...@opendb.com.br

Re: [GENERAL] Out of memory condition

2014-12-11 Thread Carlos Henrique Reimer
Slony version is 2.2.3 On Thu, Dec 11, 2014 at 3:29 PM, Scott Marlowe wrote: > Just wondering what slony version you're using? > -- Reimer 47-3347-1724 47-9183-0547 msn: carlos.rei...@opendb.com.br

Re: [GENERAL] Out of memory condition

2014-12-11 Thread Carlos Henrique Reimer
(-x) unlimited On Thu, Dec 11, 2014 at 1:30 PM, Tom Lane wrote: > Carlos Henrique Reimer writes: > > I've facing an out of memory condition after running SLONY several hours > to > > get a 1TB database with about 23,000 tables replicated. The error oc

[GENERAL] Out of memory condition

2014-12-11 Thread Carlos Henrique Reimer
GCC gcc (GCC) 4.4.6 20120305 (Red Hat 4.4.6-4) (1 row) Thank you! Carlos Reimer

Re: [GENERAL] Exit code -1073741819

2013-08-07 Thread Carlos Henrique Reimer
follow to identify the root cause in order to prevent it to happen again? Thank you! On Tue, Aug 6, 2013 at 9:14 PM, Sergey Konoplev wrote: > On Tue, Aug 6, 2013 at 4:17 PM, Carlos Henrique Reimer > wrote: > > I have tried to drop the index and the reindex procedure but both fail &g

Re: [GENERAL] Exit code -1073741819

2013-08-06 Thread Carlos Henrique Reimer
directory to the new box. Hope the error will not be propagated to the new box. Reimer On Mon, Aug 5, 2013 at 10:42 AM, Adrian Klaver wrote: > On 08/05/2013 06:24 AM, Carlos Henrique Reimer wrote: > >> Hi, >> >> Yes, I agree with you that it must be upgraded to a support

Re: [GENERAL] Exit code -1073741819

2013-08-05 Thread Carlos Henrique Reimer
, 2013 at 8:35 AM, Craig Ringer wrote: > On 08/04/2013 02:41 AM, Carlos Henrique Reimer wrote: > > Hi, > > > > I have a Windows box running Windows Server 2003 Enterprise Edition > > Service Pack 2 with PostgreSQL 8.2.23 and getting a server crash while > > trying

[GENERAL] Exit code -1073741819

2013-08-03 Thread Carlos Henrique Reimer
this related with a hardware problem or some operational system issue? Do a Windows reinstall or an windows upgrade fix the issue? Thank you in advance! -- Reimer

Re: [GENERAL]

2013-05-15 Thread Carlos Henrique Reimer
as source_t > , pg_type as target_t > ,pg_proc as proc > WHERE > ct.castsource = source_t.oid > and ct.casttarget = target_t.oid > and ct.castfunc = proc.oid > > I get 144 rows. > http://www.rummandba.com/2013/02/postgresql-type-casting-information.html > > &g

Re: [GENERAL]

2013-05-15 Thread Carlos Henrique Reimer
It works if I drop the functions but then the select trim(1) does not work; On Wed, May 15, 2013 at 5:38 PM, AI Rumman wrote: > Drop those functions and try again. > > > On Wed, May 15, 2013 at 4:22 PM, Carlos Henrique Reimer < > carlos.rei...@opendb.com.br> wrote: &g

Re: [GENERAL]

2013-05-15 Thread Carlos Henrique Reimer
issed that. > Which version of 9.2 you are working with? I am also at 9.2 and its > working fine. > Try out using > select 'teste'||1::int; > > See if it works or not. > > > On Wed, May 15, 2013 at 3:41 PM, Carlos Henrique Reimer < > carlos.rei...@opendb.co

Re: [GENERAL]

2013-05-15 Thread Carlos Henrique Reimer
1-to.html > > It'll work. > > > On Wed, May 15, 2013 at 3:17 PM, Carlos Henrique Reimer < > carlos.rei...@opendb.com.br> wrote: > >> Hi, >> >> Currently, our application is still using PG 8.2 and we are trying to use >> 9.2 but there are some

[GENERAL]

2013-05-15 Thread Carlos Henrique Reimer
acter: 15 Is there a way to make both selects work on PG 9.2 without explicit casts? Thank you in advace! -- Reimer 47-3347-1724 47-9183-0547 msn: carlos.rei...@opendb.com.br

[GENERAL] PG in cash till machines

2013-05-10 Thread Carlos Henrique Reimer
? Don't think so, but... Basically, the question is: is there a way to guaranty a reliable PG database in an untrusted and insecure environment? Maybe some kind of file system could give this guaranty, not sure.. -- Reimer

Re: [GENERAL] Runtime variations during day

2013-02-13 Thread Carlos Henrique Reimer
los Henrique Reimer wrote: > > > Anyway it does not seam related to statistics as the query plan > > is exactly the same for both scenarios, morning and evening: > > > Morning: > > > Index Scan using pagpk_aux_mes, pagpk_aux_mes, pk_cadpag, > > pk_c

Re: [GENERAL] Runtime variations during day

2013-02-13 Thread Carlos Henrique Reimer
ample that could help is this seqscan: explain analyze select sittrib8 from iparq.arript where sittrib8=33; In the evening: Fri Feb 8 14:00:01 BRST 2013 QUERY PLAN ---

[GENERAL] Runtime variations during day

2013-02-13 Thread Carlos Henrique Reimer
:smallint) AND (mes = 1::smallint) AND (codfunc = 29602::bigint) AND (seqfunc = 2::smallint) AND ((tipopgto)::text = ' '::text) AND (codpd > 0::smallint))) Total runtime: 20054.851 ms (5 rows) __ We initially suspected the reason could be that in the morning all data is in memory and in the evening not all is in memory but as database size is 40GB and memory 64GB I would eliminate this hypothesis . Another reason we rejected this hypothesis is that even if you run the query two times, both took almost the same time. Another possibility is a CPU bottleneck but as there is no indication of this condition in the performance data collected by sar, top, vmstat we assume the problem has another origin. How could we determine why this difference in the response time? Thank you in advance! Reimer

Re: [GENERAL] Differences when calling query inside and outside cursor

2013-02-13 Thread Carlos Henrique Reimer
= 2::smallint) AND ((tipopgto)::text > ' '::text)) OR ((ano = 2013::smallint) AND (mes = 1::smallint) AND (codfunc = 29602::bigint) AND (seqfunc = 2::smallint) AND ((tipopgto)::text = ' '::text) AND (codpd > 0::smallint))) (2 rows) Should it not be the same inside o

[GENERAL] Differences when calling query inside and outside cursor

2013-02-13 Thread Carlos Henrique Reimer
ANO ASC, MES ASC, CODFUNC ASC, SEQFUNC ASC, TIPOPGTO ASC, CODPD ASC; DECLARE CURSOR pgipm=# FETCH FORWARD 2 FROM CUR1; xmax | ano | mes | codfunc | seqfunc | tipopgto | codpd | hrspd | vlrpd | mesano | tipocalcferias | vlrbase --+--+-+-+-+------+---++-+++- 0 | 2013 | 1 | 29602 | 2 | R| 0 | 220.00 | 1743.28 | 12013 ||0.00 0 | 2013 | 1 | 29602 | 2 | R|53 | 14.67 | 116.22 | 12013 ||0.00 (2 rows) pgipm=# select current_time; timetz 10:51:39.748351-02 (1 row) pgipm=# rollback; ROLLBACK pgipm=# select current_time; timetz 10:52:13.202640-02 (1 row) pgipm=# Thank you! Reimer

Re: [GENERAL] Running out of memory while making a join

2012-11-14 Thread Carlos Henrique Reimer
Hi Tom, Thank you for the analyzes! No problem, there is no problem to use "select wm_nfsp.*" but as my concern is to prevent this in the future I think I should apply the fix or is there a config parameter to abend the backend if it reaches some kind of storage limit? Thank you! R

Re: [GENERAL] Running out of memory while making a join

2012-11-12 Thread Carlos Henrique Reimer
ks; 8160 free (3 chunks); 32 used > > Copy and paste the entire block (including the bits I omitted from mine > because it's just an example to show you what it looks like). > > -- > Craig Ringer > -- Reimer 47-3347-1724 47-9183-0547 msn: carlos.rei...@opendb.com.br

Re: [GENERAL] Running out of memory while making a join

2012-11-10 Thread Carlos Henrique Reimer
Hi, How is the best way to attach a debugger to the SELECT and identify why is it exhausting server storage. Thank you in advance! On Fri, Nov 9, 2012 at 4:10 AM, Craig Ringer wrote: > On 11/08/2012 11:35 PM, Carlos Henrique Reimer wrote: > > Hi Craig, > > > > work_mem

Re: [GENERAL] Running out of memory while making a join

2012-11-08 Thread Carlos Henrique Reimer
abled triggers: tg_nfe BEFORE INSERT OR DELETE OR UPDATE ON "5611_nfarq".nfe FOR EACH ROW EXECUTE PROCEDURE fun_nfarq.nfe('5611', 'NFARQ') FiscalWeb=# On Thu, Nov 8, 2012 at 10:50 AM, Craig Ringer wrote: > On 11/08/2012 06:20 PM, Carlos Henrique Reimer wrote: >

[GENERAL] Running out of memory while making a join

2012-11-08 Thread Carlos Henrique Reimer
server results in an OUT OF MEMORY message stopping the backend but preventing the entire server to stop. The development team is going to change the SQL join command but my concern is with other similar SQL commands not yet identified. Is there a way to make PostgreSQL 8.3.21 server stop memory

[GENERAL] CPU move

2011-11-26 Thread Carlos Henrique Reimer
ch? Thank you! -- Reimer 47-3347-1724 47-9183-0547 msn: carlos.rei...@opendb.com.br

[GENERAL] Explain Analyze understanding

2011-08-24 Thread Carlos Henrique Reimer
http://www.opendb.com.br/v1/explain.txt in case some one could identify some improvement that could be done to the SQL or table structures in order to get better command performance. Thank you! -- Reimer 47-3347-1724 47-9183-0547 msn: carlos.rei...@opendb.com.br

Re: [GENERAL] Linux x Windows LOCALE/ENCODING compatibility

2010-11-08 Thread Carlos Henrique Reimer
quivalent in "UTF8" pg_dump: The command was: COPY brasil.cidade (gid, "municpio", "municpi0", uf, longitude, latitude, the_geom) TO stdout; pg_dump: *** aborted because of error How can I fix this error? Thank you! 2010/11/1 Filip Rembiałkowski > 2010/11/1 C

[GENERAL] Linux x Windows LOCALE/ENCODING compatibility

2010-11-01 Thread Carlos Henrique Reimer
N1252 and UTF8 New Linux box: Which --locale and --encoding options should I use for the INITDB command to have a compatible locale and encoding cluster? Which --encoding option should I use in the CREATEDB command to have a compatible encoding database? Thank you! Reimer

[GENERAL] Debugger log

2010-10-22 Thread Carlos Henrique Reimer
$libdir/plugins/plugin_debugger.dll' Is there a way to prevent these messages to happen? Thank you! -- Reimer

Re: [GENERAL] User function canceling VACUUMDB utility

2010-09-13 Thread Carlos Henrique Reimer
Hi, Yes, once correct schema was included in the search_path, VACUUM and ANALYZE run fine again. Thank you! On Fri, Sep 10, 2010 at 11:38 AM, Tom Lane wrote: > Carlos Henrique Reimer writes: > > Yes, you're right! I found out a functional index using this function and &g

Re: [GENERAL] User function canceling VACUUMDB utility

2010-09-10 Thread Carlos Henrique Reimer
ccb(codtab) "fk_tit_decb" FOREIGN KEY (codecb) REFERENCES "BRASIL".td_ecb(codtab) "fk_tit_drem" FOREIGN KEY (codrem) REFERENCES "BRASIL".td_rem(codtab) "fk_tit_rec" FOREIGN KEY (filrec, seqrec, parrec, subrec) REFERENCES "BRASIL "

[GENERAL] User function canceling VACUUMDB utility

2010-09-09 Thread Carlos Henrique Reimer
Hi, We are facing the following problem in a PG 8.2 server when trying to vacuum one of our databases: vacuumdb: vacuuming database "reimer" INFO: vacuuming "pg_catalog.pg_database" INFO: "pg_database": found 0 removable, 6 nonremovable row ve

Re: [GENERAL] Vacuum full progress

2010-09-05 Thread Carlos Henrique Reimer
needs to be manually done and as any manual operation exposed to errors. Maybe this changed in the new PG releases but it was this way in the past. Thank you! On Sun, Sep 5, 2010 at 4:46 PM, Scott Marlowe wrote: > On Sun, Sep 5, 2010 at 5:09 AM, Carlos Henrique Reimer > wrote: > &

Re: [GENERAL] Vacuum full progress

2010-09-05 Thread Carlos Henrique Reimer
think another approach. Maybe a CLUSTER can do the work. Will start a CLUSTER and see if I can check the progress looking the size of the new table relfilenode. It will probably have less than 102 GB. Thank you! 2010/9/5 Alban Hertroys > On 5 Sep 2010, at 12:13, Carlos Henrique Reimer wrote:

[GENERAL] Vacuum full progress

2010-09-05 Thread Carlos Henrique Reimer
finishes? Thank you! -- Reimer 47-3347-1724 47-9183-0547 msn: carlos.rei...@opendb.com.br

Re: [GENERAL] Restore referencial integrity

2010-08-30 Thread Carlos Henrique Reimer
-- and use this as a > base for > DELETE statement... > > 2010/8/30, George H : > > On Mon, Aug 30, 2010 at 5:30 AM, Carlos Henrique Reimer > > wrote: > >> Hi, > >> > >> We had by mistake dropped the referencial integrety between two huge > >&g

Re: [GENERAL] Restore referencial integrity

2010-08-29 Thread Carlos Henrique Reimer
Seq Scan on posicoes (cost=0.00..8064108.80 rows=380245580 width=4)" Will this work better that a pl/pgsql as you suggested? Or is there something even betther? Thank you! 2010/8/30 George H > On Mon, Aug 30, 2010 at 5:30 AM, Carlos Henrique Reimer > wrote: > > Hi, > >

[GENERAL] Restore referencial integrity

2010-08-29 Thread Carlos Henrique Reimer
ot; that has not corresponding row in table "posicoes". As these are huge tables, almost 100GB each, and the server hardware restricted (4GB RAM) I would like a suggestion of which command or commands should be used from the performance perspective. Column "protocolo" is "p

[GENERAL] to_date function

2010-07-07 Thread Carlos Henrique Reimer
2013-04-01 (1 row) template1=# select to_date('01/04/2013 23:59:59','DD/MM/ HH24:mI:SS') ; to_date 2009-04-01 (1 row) template1=# select to_date('01/04/2013 23:59:59','DD/MM/ hH24:MI:SS') ; to_date 2013-04-01 (1 row) -- Reimer

Re: [GENERAL] Low values for cached size

2009-09-25 Thread Carlos Henrique Reimer
25, 2009 at 3:28 PM, Carlos Henrique Reimer > wrote: > > Hi, > > > > We're facing performance problems in a Linux box running CentOS release 5 > > (Final) and PostgreSQL 8.2.4. I've done some basic checks in the > > configuration but everything looks fine to

[GENERAL] Low values for cached size

2009-09-25 Thread Carlos Henrique Reimer
d even so the values for cached size does not change. Any suggestions or directions I could follow to discover the reason? Reimer -- Reimer 47-3457-0881 47-9183-0547 msn: carlosrei...@hotmail.com skype: carlosreimer

[GENERAL] Track a function

2009-02-14 Thread Carlos Henrique Reimer
Hi, I've a plpgsql function that when called never ends and I would like to trace the internal function commands and see where is the problem. How can I trace what the function is doing? Thank you! Carlos -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make cha

[GENERAL] FATAL: bogus freespace amount

2008-03-31 Thread Carlos H. Reimer
) exited with exit code 1 2008-03-31 13:35:12 2: LOG: aborting startup due to startup process failure 2008-03-31 13:35:13 1: LOG: logger shutting down What can be done to bring the system up again? Thank you in advance! Reimer

[GENERAL] current_query pg_stat_activity column

2008-02-22 Thread Carlos H. Reimer
',','),'X','.')) FROM TT_PRE PRE WHERE PRE.FILPRE = '001' AND PRE.CODPRE = '2' AND PRE.FILMAT = INT.FILMAT AND PRE.CODMAT = INT.CODMAT) ELSE 'Ver Grade' END END AS PRECO, CASE WHEN INT.PROMOC = 'Ver Grade' THEN ' _ Am I missing anything here? Thank you in advance! Reimer

RES: RES: [GENERAL] 8.2.4 selects make applications wait indefinitely

2007-10-11 Thread Carlos H. Reimer
> "Scott Marlowe" <[EMAIL PROTECTED]> writes: > > On 10/11/07, Carlos H. Reimer <[EMAIL PROTECTED]> wrote: > >> It=B4s "" but the "query_start" column is refreshed. > > > Then the query runs and finishes and the problem is so

RES: RES: [GENERAL] 8.2.4 selects make applications wait indefinitely

2007-10-11 Thread Carlos H. Reimer
> On 10/11/07, Carlos H. Reimer <[EMAIL PROTECTED]> wrote: > > > "Carlos H. Reimer" <[EMAIL PROTECTED]> writes: > > > > SELECT * or naming all the columns locks the client > > > application. Yesterday > > > > I´ve wrong

RES: RES: [GENERAL] 8.2.4 selects make applications wait indefinitely

2007-10-11 Thread Carlos H. Reimer
> "Carlos H. Reimer" <[EMAIL PROTECTED]> writes: > > SELECT * or naming all the columns locks the client > application. Yesterday > > I´ve wrongly said that when naming all the columns instead of > using the * > > the applications did not lock. > &

RES: [GENERAL] 8.2.4 selects make applications wait indefinitely

2007-10-11 Thread Carlos H. Reimer
sue in the client, as I´m able to connect and do the select * in other 8.2.4 servers. Don´t know what kind of tests I should do to help fixing this problem. Any suggestions? Reimer ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

RES: [GENERAL] 8.2.4 selects make applications wait indefinitely

2007-10-11 Thread Carlos H. Reimer
all the other tests against the SUSE PG 8.2.4 production server. Reimer ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

RES: [GENERAL] 8.2.4 selects make applications wait indefinitely

2007-10-11 Thread Carlos H. Reimer
same "select *" into the SUSE and it locked, we discard the possibility of a problem with the ODBC driver. Reimer ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[GENERAL] 8.2.4 selects make applications wait indefinitely

2007-10-10 Thread Carlos H. Reimer
t;ndices:deposito". Apparently is a psql issue because if we query the pg_attribute the column name appears correctly as "codigo_deposito". I'm thinking to install the 8.2.5 to fix this issue. Am I thinking right? Would appreciate any other suggestions. Thank you very much in advance. Reimer

[GENERAL] PostgreSQL abnormally terminating with signal 5

2007-06-04 Thread Carlos H. Reimer
on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special) Is there anything I can do to help solve this problem? Thanks! Reimer

RES: [GENERAL] Order by behaviour

2007-04-05 Thread Carlos H. Reimer
standards? Thanks in advance! > -Mensagem original- > De: Stephan Szabo [mailto:[EMAIL PROTECTED] > Enviada em: quarta-feira, 28 de março de 2007 19:23 > Para: Carlos H. Reimer > Cc: pgsql-general@postgresql.org > Assunto: Re: [GENERAL] Order by behaviour > > > On Wed

RES: [GENERAL] Order by behaviour

2007-03-29 Thread Carlos H. Reimer
han Szabo > Enviada em: quarta-feira, 28 de março de 2007 19:23 > Para: Carlos H. Reimer > Cc: pgsql-general@postgresql.org > Assunto: Re: [GENERAL] Order by behaviour > > > On Wed, 28 Mar 2007, Carlos H. Reimer wrote: > > > Hi, > > > > We have a PostgreSQL 8.0

[GENERAL] Order by behaviour

2007-03-28 Thread Carlos H. Reimer
lc_collate=pt_BR.UTF-8? Thank you in advance! Reimer

[GENERAL] Improve response time of a SQL command

2006-12-28 Thread Carlos H. Reimer
ctual time=0.089..0.092 rows=1 loops= 1) Index Cond: (("outer".codfil = ven.codfil) AND ("outer".sequen = ven.sequen)) -> Index Scan using i_uq_ior_ive on tt_ior ior (cost=0.00..3.93 rows=1 width=38) (actual time=8.524..8.528 rows=1 loops= 1) Index Cond: (("outer".codfil = ior.filive) AND ("outer".sequen = ior.seqive) AND ("outer".numite = ior.numive)) Total runtime: 6697.206 ms (53 rows) Reimer

[GENERAL] Bad performance in bulky updates

2006-10-30 Thread Carlos H. Reimer
Hi,   We have very bad performance issues in one of our customer PostgreSQL servers and we would like some suggestions to improve the performance for bulky updates.   When one of the biggest tables has all lines updated for example, it takes at about 30 minutes for processing. If we drop all

RES: RES: RES: RES: [GENERAL] Dates rejected

2006-10-16 Thread Carlos H. Reimer
da em: terça-feira, 17 de outubro de 2006 00:02 > Para: [EMAIL PROTECTED] > Cc: Pgsql-General@Postgresql.Org > Assunto: Re: RES: RES: RES: [GENERAL] Dates rejected > > > "Carlos H. Reimer" <[EMAIL PROTECTED]> writes: > > To discover if it works this way I´ve chan

RES: RES: RES: RES: [GENERAL] Dates rejected

2006-10-16 Thread Carlos H. Reimer
> Cc: Pgsql-General@Postgresql.Org > Assunto: Re: RES: RES: RES: [GENERAL] Dates rejected > > > "Carlos H. Reimer" <[EMAIL PROTECTED]> writes: > > To discover if it works this way I´ve changed the > /etc/localtime to relect > > the following timezone: &g

RES: RES: RES: [GENERAL] Dates rejected

2006-10-16 Thread Carlos H. Reimer
outubro de 2006 21:38 > Para: [EMAIL PROTECTED] > Cc: Andreas Kretschmer; Pgsql-General@Postgresql.Org > Assunto: Re: RES: RES: [GENERAL] Dates rejected > > > "Carlos H. Reimer" <[EMAIL PROTECTED]> writes: > > The problem is related with the to_timestamp func

RES: RES: [GENERAL] Dates rejected

2006-10-16 Thread Carlos H. Reimer
7 > Para: [EMAIL PROTECTED] > Cc: Andreas Kretschmer; Pgsql-General@Postgresql.Org > Assunto: Re: RES: [GENERAL] Dates rejected > > > "Carlos H. Reimer" <[EMAIL PROTECTED]> writes: > > select to_date('16/10/2006','DD/MM/'); > >t

RES: RES: [GENERAL] Dates rejected

2006-10-16 Thread Carlos H. Reimer
. Thanks in advance! Carlos > -Mensagem original- > De: Tom Lane [mailto:[EMAIL PROTECTED] > Enviada em: segunda-feira, 16 de outubro de 2006 16:27 > Para: [EMAIL PROTECTED] > Cc: Andreas Kretschmer; Pgsql-General@Postgresql.Org > Assunto: Re: RES: [GENERAL] Dates rej

RES: [GENERAL] Dates rejected

2006-10-16 Thread Carlos H. Reimer
w can we explain the 01:00:00 hour that the to_date function returns for date 15/10/2006? Thank you! Carlos > -Mensagem original- > De: Andreas Kretschmer,,, [mailto:[EMAIL PROTECTED] nome de > Andreas Kretschmer > Enviada em: segunda-feira, 16 de outubro de 2006 13:41 &

[GENERAL] Dates rejected

2006-10-16 Thread Carlos H. Reimer
tt_teste (datfis) VALUES ( to_date('15/10/2006','DD/MM/') ); ERROR:  new row for relation "tt_teste" violates check constraint "tt_teste_datfis_check" I´ll appreciate any help!   Thanks in advance! Carlos Reimer  

[GENERAL] Mobile servers replication

2006-07-09 Thread Carlos H. Reimer
about this issue. Reimer ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

RES: [GENERAL] Phantom groups

2006-07-05 Thread Carlos H. Reimer
ira, 5 de julho de 2006 00:42 > Para: [EMAIL PROTECTED] > Cc: pgsql-general@postgresql.org > Assunto: Re: [GENERAL] Phantom groups > > > Carlos H. Reimer wrote: > > Hi, > > > > I´m planning to migrate from 7.4 to 8.0.7 and I discovered some strange > > behavi

[GENERAL] Phantom groups

2006-07-03 Thread Carlos H. Reimer
could I fix it? Reimer ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[GENERAL] Lock contention during inserts

2006-06-20 Thread Carlos H. Reimer
Hello, During mass inserts, we have some locking contention in tables referenced by foreign keys. It´s a 8.0.3 box and I know that 8.1 solved this but I would like to know if there is an easy and safe way to only apply this patch to 8.0.3? Reimer ---(end of broadcast

RES: [GENERAL] XID comparations

2006-06-13 Thread Carlos H. Reimer
in the future and not visible to my XID? Thanks in advance! Reimer ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[GENERAL] XID comparations

2006-06-13 Thread Carlos H. Reimer
one will be 3 (1 and 2 are reserved). In this case, we could have have lines with cmin 4.294.967.295 and lines with cmin 3. How are they compared to determine that rows with cmin 3 are newer than rows with cmin 4.294.967.295? Thanks in advance, Reimer ---(end of broadcast

Re: [GENERAL] PostgreSQL x Sybase

2006-04-05 Thread Reimer
Sorry, maybe I was not clear. No, it´s not Peoplesoft ERP, it´s a small brazilien ERP software house. - Original Message - From: "Bruno Wolff III" <[EMAIL PROTECTED]> To: "Reimer" <[EMAIL PROTECTED]> Cc: "Mark Aufflick" <[EMAIL PROTECTE

Re: [GENERAL] PostgreSQL x Sybase

2006-03-31 Thread Reimer
change to the Sybase ERP system, comparing only the database features. Many thanks! Reimer - Original Message - From: "Mark Aufflick" <[EMAIL PROTECTED]> To: "Reimer" <[EMAIL PROTECTED]> Cc: Sent: Thursday, March 30, 2006 10:48 AM Subject: Re: [GENERA

[GENERAL] Comparing 7.4 with 8.0

2006-03-29 Thread Reimer
document with all enhancements they will have if they migrate to 8.0.6.   Where could I find some documents to help me?   Are 7.4.6 vulnerable in some area? Security?   Many thanks in advance!   Reimer  

[GENERAL] PostgreSQL x Sybase

2006-03-29 Thread Reimer
Hi,   Does anyone know of any recent comparisons of postgres vs Sybase?   Thanks in advance!   Reimer

Re: [GENERAL] URGENT! could not access status of transaction

2006-03-24 Thread Reimer
ok, I fixed it using the dd command and the pg_dump is not complaining anymore, but can I trust in my database now? Thanks in advance! - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Reimer" <[EMAIL PROTECTED]> Cc: Sent: Friday, Ma

Re: [GENERAL] URGENT! could not access status of transaction

2006-03-24 Thread Reimer
I forgot to mention postgreSQL version: 7.4.6   Thanks! - Original Message - From: Reimer To: pgsql-general@postgresql.org Sent: Friday, March 24, 2006 10:41 AM Subject: [GENERAL] URGENT! could not access status of transaction Hello,   We had some

[GENERAL] URGENT! could not access status of transaction

2006-03-24 Thread Reimer
ontents of table "tt_fin" failed: PQendcopy() failed.pg_dump: Error message from server: ERROR:  could not access status of transaction 1768711534DETAIL:  could not open file "/usr/local/pgsql/data/pg_clog/0696": Arquivo ou diretório não encontradopg_dump: The command was

[GENERAL] Is the pg_locks been used?

2006-02-23 Thread Carlos Henrique Reimer
Hi,   When the pg_locks view is used the internal lock manager data structures are momentarily locked and that is why I would like to know if some application is reading the pg_locks view and how many times.   Is there a way to discover it?   Thanks in advance!   Reimer Yahoo! Acesso

[GENERAL] pg_dump warning with -Fc option

2006-02-23 Thread Carlos Henrique Reimer
Hello,   Pg_dump complains when I use the -Fc option with:   pg_dump: [archiver] WARNING: requested compression not available in this installation -- archive will be uncompressed and the dump is not compressed... searching in the list I´ve found that there is something related with the zlib.

[GENERAL] How much clustered?

2006-02-16 Thread Carlos Henrique Reimer
Hi,   I would like to know how much clustered is a table related to some index How can I discover?   Reimer Yahoo! doce lar. Faça do Yahoo! sua homepage.

[GENERAL] Date last vacuum

2006-02-15 Thread Carlos Henrique Reimer
Hello,   Is there a way do discover when was the last time a table or database vacuumed?   Thanks in advance!   Reimer Yahoo! Acesso Grátis Internet rápida e grátis. Instale o discador agora!

Re: [GENERAL] locale and encoding

2005-09-10 Thread Carlos Henrique Reimer
I would like to change to C because it will give us better performance. As it is per-cluster I would have to initib again but what will happen when the dump will be reloaded?   Some characters that we have today in the SQL_ASCII database probably can not be loaded in a LATIN1 database. Am I right

[GENERAL] Messages doesn´t appear

2005-08-31 Thread Carlos Henrique Reimer
Hi,   I´m trying to post messages in the performance list but they don´t appear in the list.   Whan can be wrong?   Reimer__Converse com seus amigos em tempo real com o Yahoo! Messenger http://br.download.yahoo.com/messenger/

Re: [GENERAL] Postgresql replication

2005-08-26 Thread Carlos Henrique Reimer
the rule system to make updates go to the base table too (the master piece) like the inserts? 3. Is there not some peformance issues related with the fact of using a table that is an union instead a normal table? Thanks in advance!   Reimer Jeff Davis <[EMAIL PROTECTED]> escreveu: Chris Browne

Re: [GENERAL] Postgresql replication

2005-08-25 Thread Carlos Henrique Reimer
ExactlyJeff Davis <[EMAIL PROTECTED]> escreveu: Jim C. Nasby wrote:> Or, for something far easier, try> http://pgfoundry.org/projects/pgcluster/ which provides syncronous> multi-master clustering.> He specifically said that pgcluster did not work for him because thedatabases would be at physica

Re: [GENERAL] Postgresql replication

2005-08-24 Thread Carlos Henrique Reimer
I read some documents about replication and realized that if you plan on using asynchronous replication, your application should be designed from the outset with that in mind because asynchronous replication is not something that can be easily “added on” after the fact.   Am I right?   Reimer

[GENERAL] Postgresql replication

2005-08-24 Thread Carlos Henrique Reimer
Hello,   Currently we have only one database accessed by the headquarter and two branches but the performance in the  branches is very poor  and I was invited to discover a way to increase it.   One possible solution is replicate the headquarter DB into the two branches.   I read about slony-i, but

[GENERAL] Error during restore

2005-02-18 Thread Carlos Henrique Reimer
created somewhere after this commands. It´s like the execution order is wrong.   I used pg_dumpall withou any options to create the dump.   What could be wrong?   Reimer   Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador do Yahoo! agora.

Re: [GENERAL] I'm trying change to Linux & PostgreSQL. Do you can help me?

2000-03-12 Thread Fred Reimer
I thought I just answered this a day or two ago. Check out freshmeat.net for pgaccess. It's a TCL program that looks real similar to MS Access but is for contacting PostgreSQL databases. Runs on Unix and Windows. HTH, Fred Reimer On Fri, 11 Apr 2036, "Germán" Largo Urr