Re: [GENERAL] Problem with partitioning

Hello, 2016-08-03 15:29 GMT-03:00 Adrian Klaver : > On 08/03/2016 11:24 AM, JotaComm wrote: > >> >> >> 2016-08-03 15:20 GMT-03:00 JotaComm > <mailto:jota.c...@gmail.com>>: >> >> > >> ​When I create a trigger for each child table the tr

Re: [GENERAL] Problem with partitioning

2016-08-03 15:20 GMT-03:00 JotaComm : > > > 2016-08-03 15:15 GMT-03:00 JotaComm : > >> Hello, >> >> 2016-08-03 14:21 GMT-03:00 David G. Johnston >> : >> >>> On Wed, Aug 3, 2016 at 1:16 PM, Adrian Klaver >> > wrote: >&

[GENERAL] Problem with partitioning

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

[GENERAL] Problems with timezone

e 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

ATE, and > DELETE privileges on the "mydatabase" database. > > Can someone point me in the right direction? > > First: CREATE ROLE and CREATE DATABASE; After: CREATE TABLEs; Last: GRANT SELECT,INSERT,UPDATE and DELETE. > > 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

procpid | 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

end-of-backup point when no actual redo work is >required (Heikki Linnakangas) > >This mistake could result in incorrect "WAL ends before end of online > backup" errors. > > > I believe that my problem is described here. What do you think about it? > > &

Re: [GENERAL] WAL contains references to invalid pages

Hello, Fabrízio 2013/5/16 Fabrízio de Royes Mello > > On Thu, May 16, 2013 at 11:12 AM, JotaComm wrote: > >> >> [...] >> >> Yesterday I identified the following messages in my log file (slave): >> >> user=,db= WARNING: page 6629 of relation bas

[GENERAL] WAL contains references to invalid pages

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

Re: [GENERAL] Characters

is the result for these commands? SHOW 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/t

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

list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general> > Regards -- JotaComm http://jotacomm.wordpress.com

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

ION-UNEXPECTEDLY-tp5750563.html > Sent from the PostgreSQL - general 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)

rom file "pg_clog/0022" at offset 212992: Success. When I created the cluster 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