I believe that you can achieve what you want with the following configuration
parameters: log_connections and log_line_prefix
PostgreSQL: Documentation: 10: 19.8. Error Reporting and Logging
|
|
|
| | |
|
|
|
| |
PostgreSQL: Documentation: 10: 19.8. Error Reporting and Logging
|
Hi,I find the documentation about pg_basebackup misleading : the documentation
states that standalone hot backups cannot be used for point in time recovery,
however I don't get the point : if one has a combination of the nightly
pg_basebackup and the archived wals, then it is totally OK to do po
I believe you could use an event trigger in postgres to capture the fact that a
table was created:
https://www.postgresql.org/docs/current/static/event-triggers.html
In the trigger you would then have to code whatever is needed to notify the
external software (via a REST call or by posting somet
and brings the archives..
Thanks and regards,
Pierre
On Wednesday, June 20, 2018, 5:38:56 AM GMT+2, Michael Paquier
wrote:
Hi Pierre,
On Tue, Jun 19, 2018 at 12:03:58PM +0000, Pierre Timmermans wrote:
> Here is the doc, the sentence that I find misleading is "There are
> b
Hi Michael
On Thursday, June 21, 2018, 7:28:13 AM GMT+2, Michael Paquier
wrote:
>You should avoid top-posting on the Postgres lists, this is not the
>usual style used by people around :)
Will do, but Yahoo Mail! does not seem to like that, so I am typing the > myself
>Attached is a pat
Hello
What you are doing is called "log shipping", which means that when a wal
(write-ahead log) is filled in on the database server you ship it to a backup
server via rsync. It is fine but as you said the disadvantage is that the file
is shipped only when it is full, so you could have data loss
pgpool does just that: it enables you to use the standby database as a read
only while other queries are sent to the primary database only
(http://www.pgpool.net/). Good product and good support (on the list°
This looks a very interesting possibility, although it is more related to
automated fai
of pgpool and repmgr. People on pgpool
mailing list are very reactive and helpful and the doc on the project is
continuously improving.
Pierre
On Wednesday, February 14, 2018, 8:44:47 PM GMT+1, Melvin Davidson
wrote:
On Wed, Feb 14, 2018 at 2:27 PM, Pierre Timmermans wrote:
pgpool
