Hello!
For CRL reloading we need to restart the PG In 9.6.
Now we have a new server with 11.x.
As I read it has a reload possibility without restart and dropping the
connections.
SELECT pg_reload_conf();
It's ok. But: the restart is a very good checking point.
If you did it, and after the serv
Hello all
I am a bit confused about how to design privileges properly around foreign
tables.
Here's the setup.
-- As superuser
create server s foreign data wrapper postgres_fdw options (host 'hhh.d',
dbname 'db1', port '5432');
grant usage on foreign server s... to public; -- This does not
On Mon, 2020-09-21 at 08:21 +, Niels Jespersen wrote:
> create user mapping for current_user server s... (user 'remoteuser', password
> 'remotepassword');
>
> create foreign table t ( a int) server s... options (table_name
> 't_remote');
>
> This works fine. Except only the user who c
Howdy,
First let me say thanks for the feedback! It is rare that we receive
detailed "user feedback" on these lists so it is good to hear from the
outside world. I am only going to address a few things as others have
addressed the rest.
> 2. pg_dump misinterprets non-ANSI values for the "--exclu
Durumdara writes:
> What will happen when onfly reload finds something bad (99% of the config
> is good, but 1 line in in the config file is wrong)?
For a CRL file, the file will be ignored and the old configuration will
remain, I believe.
> And the most important question: how do we know that P
