Re: Is postgres_fdw "safe"?

Marcin Borkowski writes: > I noticed that the docs for postgres_fdw lack the clause about it being > "trusted". Does that mean that `create extension postgres_fdw` poses > any known security risks? If so, what should I do to minimize them? It's a definitional question I guess. We don't mark an

Re: Is postgres_fdw "safe"?

On 10/20/23 03:29, Marcin Borkowski wrote: Hello, I noticed that the docs for postgres_fdw lack the clause about it being "trusted". Does that mean that `create extension postgres_fdw` poses any known security risks? If so, what should I do to minimize them? I think a better question to ask

Is postgres_fdw "safe"?

Hello, I noticed that the docs for postgres_fdw lack the clause about it being "trusted". Does that mean that `create extension postgres_fdw` poses any known security risks? If so, what should I do to minimize them? TIA, -- Marcin Borkowski http://mbork.pl

Re: Is postgres_fdw "safe"?

On 10/20/23 01:29, Marcin Borkowski wrote: Hello, I noticed that the docs for postgres_fdw lack the clause about it being "trusted". Does that mean that `create extension postgres_fdw` poses any known security risks? If so, what should I do to minimize them? It allows connections to a databa

Re: PostgreSQL C++ Interface version 14.9 using static library instead of shared library

M Tarkeshwar Rao writes: > While compiling PostgreSQL C++ Interface version 14.9 . Found that libpq.so > is getting created with libssl.a and libcrypto.a instead of shared library > libssl.so and libcrypto.so. I don't see that happening here ... $ ldd libpq.so.5.14 linux-vdso.so.1 (0x

Re: A few questions about foreign tables

On 2023-10-18, at 18:14, Ron wrote: > And SELECT relnamespace::regnamespace::text, relname FROM pg_class > WHERE relkind='f'; tells you all of the foreign tables. > > Thus, this (untested) query generate all of the DROP FOREIGN TABLE statements: > SELECT format('DROP FOREIGN TABLE IF EXISTS %I.

Re: A few questions about foreign tables

On 2023-10-18, at 17:56, Laurenz Albe wrote: > On Wed, 2023-10-18 at 10:24 +0200, Marcin Borkowski wrote: >> How to revert the effect of "import foreign schema"? Is just dropping >> the imported tables enough? > > Running DROP FOREIGN TABLE ... for all imported tables is enough. > >> Also, how

Re: pgagent download link missing

On 10/20/23 04:04, B Liu wrote: Hi there, I tried to download latest pgagent for windows, but there is no link on this page, https://www.pgadmin.org/download/pgagent-windows/ Did I miss anything? Yes the below from the link you posted: "p

Re: pgagent download link missing

> On 20 Oct 2023, at 13:04, B Liu wrote: > I tried to download latest pgagent for windows, but there is no link on this > page, https://www.pgadmin.org/download/pgagent-windows/ This list is for general questions around postgres and the PostgreSQL project, and might not be monitored by pgadmin

pgagent download link missing

Hi there, I tried to download latest pgagent for windows, but there is no link on this page, https://www.pgadmin.org/download/pgagent-windows/ Did I miss anything? Thanks Bin

PostgreSQL C++ Interface version 14.9 using static library instead of shared library

Hi While compiling PostgreSQL C++ Interface version 14.9 . Found that libpq.so is getting created with libssl.a and libcrypto.a instead of shared library libssl.so and libcrypto.so. It is created like below: user@seli[postgres/14.9/lib]$ ldd libpq.so