Re: [GENERAL] Unable to upload backups

2017-04-19 Thread JP Jacoupy
Hi, Seems to me your role "ronb" doesn't have the rights to create schema on your database. Please refer to the GRANT command in the documentation. https://www.postgresql.org/docs/9.0/static/sql-grant.html Sent from [ProtonMail](https://protonmail.ch), encrypted email based in Switzerland. -

Re: [GENERAL] Handling psql lost connections

2017-03-29 Thread JP Jacoupy
Not a response to OP but this also occurs with libpq connections. The only thing I found at the moment is to lower the net.ipv4.tcp_retries2 value to 8 (instead of 15). This will lower the TCP timeout from kernel to around 100 seconds instead of 15 minutes. Sent from ProtonMail mobile ---

[GENERAL] Service configuration file and password security

2017-02-16 Thread JP Jacoupy
Hello, This might seem a pretty novice question but I can't find an answer. Can the password be stored in an encrypted way inside a service configuration file? -- Jacoupy Jean-Philippe Sent from [ProtonMail](https://protonmail.ch), encrypted email based in Switzerland.

Re: [GENERAL] Synchronous Commit, WAL archiving and statement_timeout

2017-02-03 Thread JP Jacoupy
Original Message Subject: Re: [GENERAL] Synchronous Commit, WAL archiving and statement_timeout Local Time: 3 février 2017 1:15 AM UTC Time: 3 février 2017 00:15 From: adrian.kla...@aklaver.com To: JP Jacoupy , pgsql-general@postgresql.org On 02/02/2017 09:15 AM, JP Jacoupy

[GENERAL] Synchronous Commit, WAL archiving and statement_timeout

2017-02-02 Thread JP Jacoupy
Hello, I noticed something strange and I would like to understand what's happening. I have the following environment: - 2 PostgreSQL instance running in hot-standby with synchronous commit activated. (further called Master & Slave) - The archiving of the WAL files is activated on the master runn