he new master in the next step)?
>
>
Unfortunately no because on 9.1 version we don't have support for logical
replication yet. We start supporting it since 9.4 using pglogical
extension. As I said before you should consider use one external
replication tool like Slony to do this job.
Rega
at or near "verbose"
> ZEILE 1: reindex verbose database 'gnumed_v21';
>^
> gnumed_v21=>
>
> Does this constitute a bug in the documentation or in the Debian version of
> PG ?
>
You forgot to add the "(" and "
of this cluster
2) in your postgresql.conf set 'zero_damaged_pages = on' [1]
3) start your cluster
I really don't know if it will work, but you can try... :-)
Regards,
[1]
http://www.postgresql.org/docs/9.2/static/runtime-config-developer.html#GUC-ZERO-DAMAGED-PAGES
--
Fabrízio de Royes Mello
On Thu, Apr 25, 2013 at 1:17 AM, Darren Duncan dar...@darrenduncan.netwrote:
On 2013.04.24 7:16 PM, � wrote:
Maybe you must see this extension [1] ;-)
[1]
http://pgxn.org/dist/session_**variables/http://pgxn.org/dist/session_variables/
Fabrízio de Royes Mello
Thanks for your response
a temporary table for every session?
Hi,
Maybe you must see this extension [1] ;-)
[1] http://pgxn.org/dist/session_variables/
http://pgxn.org/dist/session_variables/--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
Blog sobre TI: http://fabriziomello.blogspot.com
Perfil Linkedin
integer AS
$$
INSERT INTO foo_track(foo_row) VALUES ($1) RETURNING (foo_row).id
$$
LANGUAGE sql;
CREATE VIEW v_foo AS SELECT foo.*, foo_track_func(foo.*) FROM foo;
SELECT * FROM v_foo;
SELECT * FROM foo_track;
COMMIT;
Regards,
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
Blog
to aggregate comments into a single line... is
it? If yes then you can try this:
SELECT article_id, string_agg(comments, ' ') FROM your_table GROUP BY
article_id;
Best regards,
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
Blog sobre TI: http://fabriziomello.blogspot.com
Perfil
you mean with more tasks in the database ? What kind of tasks run
on your database overnight?
Best regards,
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
Blog sobre TI: http://fabriziomello.blogspot.com
Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
Twitter: http
/blogs/pgblog/2013.html#January_23_2013
[2] http://momjian.us/main/blogs/pgblog/2013.html#January_7_2013
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
Blog sobre TI: http://fabriziomello.blogspot.com
Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
Twitter: http://twitter.com
.
Regards,
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
Blog sobre TI: http://fabriziomello.blogspot.com
Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
Twitter: http://twitter.com/fabriziomello
historical data *OR* make your audit tables partitioned...
regards,
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
Blog sobre TI: http://fabriziomello.blogspot.com
Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
Twitter: http://twitter.com/fabriziomello
[1].
[1] http://wiki.postgresql.org/wiki/Lock_Monitoring
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
Blog sobre TI: http://fabriziomello.blogspot.com
Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
Twitter: http://twitter.com/fabriziomello
/interactive/runtime-config-logging.html#GUC-LOG-STATEMENT
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
Blog sobre TI: http://fabriziomello.blogspot.com
Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
Twitter: http://twitter.com/fabriziomello
?
Has it moved somewhere else?
Hi,
Look at the pldebugger git repository in [1].
[1] http://git.postgresql.org/gitweb/?p=pldebugger.git;a=summary
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
Blog sobre TI: http://fabriziomello.blogspot.com
Perfil Linkedin: http://br.linkedin.com
2012/5/22 Gugu Nomcebo Mthimkhulu hlubelihle.m...@yahoo.com
stop sending mail
You must access the link [1] to unsubscribe from this mailing list.
[1] http://www.postgresql.org/mailpref/pgsql-general
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
Blog sobre TI: http
is 16MB (16777216 bytes), so you can save
this information using archive_command. Ex:
archive_command = 'du -b %p /tmp/xlogsize_history.txt'
Regards,
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
Blog sobre TI: http://fabriziomello.blogspot.com
Perfil Linkedin: http
=f70f095c9096d5e2689e8d79172b37b57a84e51b
Can we back-patch it on previous versions like 9.0 and 9.1? Or exist some
reason to don't do that?
Regards,
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
Blog sobre TI: http://fabriziomello.blogspot.com
Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
Twitter
to
vacuum_defer_cleanup_age in my case?
Tell me if you recommend changes in other parameter.
Which the value of the parameter statement_timeout ?
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
Blog sobre TI: http://fabriziomello.blogspot.com
Perfil Linkedin: http://br.linkedin.com
postgresql.conf or in your session
using SET statement.
[1] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
Blog sobre TI: http://fabriziomello.blogspot.com
Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
Blog sobre TI: http://fabriziomello.blogspot.com
Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
Twitter: http://twitter.com/fabriziomello
://www.postgresql.org/docs/current/interactive/functions-array.html
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
Blog sobre TI: http://fabriziomello.blogspot.com
Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
Twitter: http://twitter.com/fabriziomello
on
2010-10-06 12:39:04
(1 linha)
--
Fabrízio de Royes Mello
Blog sobre TI: http://fabriziomello.blogspot.com
Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
();
INSERT INTO person VALUES (1, 'Fabrizio', 'Mello', '1979-08-08');
This example works more then one version of PostgreSQL.
Best regards,
--
Fabrízio de Royes Mello
Blog sobre TI: http://fabriziomello.blogspot.com
23 matches
Mail list logo