Re: [GENERAL] Problem with partitioning

2016-08-03 Thread JotaComm
Hello, 2016-08-03 15:29 GMT-03:00 Adrian Klaver <adrian.kla...@aklaver.com>: > On 08/03/2016 11:24 AM, JotaComm wrote: > >> >> >> 2016-08-03 15:20 GMT-03:00 JotaComm <jota.c...@gmail.com >> <mailto:jota.c...@gmail.com>>: >> >> > &

Re: [GENERAL] Problem with partitioning

2016-08-03 Thread JotaComm
2016-08-03 15:20 GMT-03:00 JotaComm <jota.c...@gmail.com>: > > > 2016-08-03 15:15 GMT-03:00 JotaComm <jota.c...@gmail.com>: > >> Hello, >> >> 2016-08-03 14:21 GMT-03:00 David G. Johnston <david.g.johns...@gmail.com> >> : >> &

[GENERAL] Problem with partitioning

2016-08-03 Thread JotaComm
operation but the raise notice isn't printed on screen. Thank you. Best regards -- JotaComm http://jotacomm.wordpress.com

[GENERAL] Problems with timezone

2015-07-27 Thread JotaComm
PostgreSQL version is: 9.2.4 cat /etc/issue CentOS release 6.3 (Final) Kernel \r on an \m Could you help me? Thanks a lot. Best regards -- JotaComm http://jotacomm.wordpress.com

Re: [GENERAL] permission denied for relation

2014-01-30 Thread JotaComm
. Cheers, Ovid -- IT consulting, training, international recruiting http://www.allaroundtheworld.fr/. Buy my book! - http://bit.ly/beginning_perl Live and work overseas - http://www.overseas-exile.com/ Regards -- JotaComm http://jotacomm.wordpress.com

[GENERAL] Problems with vacuum

2013-09-04 Thread JotaComm
| 2738 current_query | autovacuum: VACUUM public.mensagem (to prevent wraparound) query_start | 2013-08-27 18:58:41.527238-03 Any idea? Any tips? Best regards -- JotaComm http://jotacomm.wordpress.com

Re: [GENERAL] WAL contains references to invalid pages

2013-05-24 Thread JotaComm
backup errors. I believe that my problem is described here. What do you think about it? On Thu, May 16, 2013 at 11:14 PM, JotaComm jota.c...@gmail.com wrote: Hello, Fabrízio 2013/5/16 Fabrízio de Royes Mello fabriziome...@gmail.com On Thu, May 16, 2013 at 11:12 AM, JotaComm jota.c

[GENERAL] WAL contains references to invalid pages

2013-05-16 Thread JotaComm
) doesn't work according my wish. Any idea? Thanks a lot. Regards -- JotaComm http://jotacomm.wordpress.com

Re: [GENERAL] WAL contains references to invalid pages

2013-05-16 Thread JotaComm
Hello, Fabrízio 2013/5/16 Fabrízio de Royes Mello fabriziome...@gmail.com On Thu, May 16, 2013 at 11:12 AM, JotaComm jota.c...@gmail.com wrote: [...] Yesterday I identified the following messages in my log file (slave): user=,db= WARNING: page 6629 of relation base/20449/24818

Re: [GENERAL] how to find which tables required indexes in postgresql

2013-04-10 Thread JotaComm
/**mailpref/pgsql-generalhttp://www.postgresql.org/mailpref/pgsql-general Regards -- JotaComm http://jotacomm.wordpress.com

Re: [GENERAL] Characters

2013-04-10 Thread JotaComm
client_encoding; and SHOW server_encoding; I am using Devart's 'PostgreSQL Data Access Components' to access PG from FreePascal. In my FreePascal code I do use AnsiStrings and I cast the database results/text 'UTF8ToAnsi(...)' Thanks for a hint! Cheers, P. Regards -- JotaComm http

Re: [GENERAL] ERROR: SERVER CLOSED THE CONNECTION UNEXPECTEDLY

2013-04-05 Thread JotaComm
mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- JotaComm http://jotacomm.wordpress.com

[GENERAL] Problems with PostgreSQL Replication (Log Shipping)

2013-03-12 Thread JotaComm
and I did this test, it was OK. Now, my cluster has about 160GB and I tried starting the replication and I have this problems. Some idea? Thank you. Best Regards João Paulo -- JotaComm http://jotacomm.wordpress.com