Amol Inamdar writes:
> @Laurenz Albe
>> If you pre-create the data directory with the appropriate permissions,
>> what keeps you from giving ownership to the correct user too?
> Our NFS server is not a regular linux based server,
> it's on zOS (Mainframes) with AT-TLS security enabled,
> hence i
@Laurenz Albe
If you pre-create the data directory with the appropriate permissions,
what keeps you from giving ownership to the correct user too?
Our NFS server is not a regular linux based server,
it's on zOS (Mainframes) with AT-TLS security enabled,
hence it doesn't allow changing of ownershi
On Wed, Jul 16, 2025 at 9:25 AM Amol Inamdar wrote:
>
>1. NFS mount point is for /nfs-mount/postgres (and permissions locked
>down so that Postgres cannot create directories in here)
>2. Postgres data directory is /nfs-mount/postgres/db
>3.
>
>With secured NFS + AT-TLS setup P
On Wed, 2025-07-16 at 18:54 +0530, Amol Inamdar wrote:
> I would like to rephrase the question a little bit, below is how our setup
> going to be
> 1. NFS mount point is for /nfs-mount/postgres (and permissions locked down
> so
> that Postgres cannot create directories in here)
> 2.
On 7/16/25 00:40, Achilleas Mantzios wrote:
On 7/16/25 08:22, KK CHN wrote:
How? I am getting , connecting directly to postgresql, or pgpool, or
pgbouncer :
achill@smadevnu:~ % psql "postgresql://localhost:5432?statement_timeout=10"
psql: error: invalid URI query parameter: "statement_tim
Quoting Tom's earlier email:
"(But I too *would not use Postgres-over-NFS for any critical data*.
Too many moving parts. It's tough enough to ensure crash safety
with local storage.)"
You're going through a lot of security effort to implement a Worst Practice.
On Wed, Jul 16, 2025 at 9:25 AM Amo
Hi All,
I would like to rephrase the question a little bit, below is how our setup
going to be
1. NFS mount point is for /nfs-mount/postgres (and permissions locked
down so that Postgres cannot create directories in here)
2. Postgres data directory is /nfs-mount/postgres/db
3.
Wit
The cause has been identified. In my VB program, I was using the COPY command.
To prevent memory issues with large files, I changed the file reading method
from reading the entire file at once to reading it line by line, as shown
below.
However, this caused line breaks within the data to b
On 7/16/25 08:40, Achilleas Mantzios wrote:
On 7/16/25 08:22, KK CHN wrote:
Hi,
I am facing an issue with PgBouncer-Postgres setup,
*PgBouncer (PgBouncer 1.23.1 running on VM instance FreeBSD 14.2) and
PostgreSQL DB cluster on a virtual machine (PG version 16.0, RHEL
9.4) *.
My applica
There's an option to ignore parameters in pgbouncer's config. Here's an SO
answer that gives an example: https://stackoverflow.com/a/36911794
On Wed, 16 Jul 2025, 09:19 KK CHN, wrote:
> Hi,
>
> I am facing an issue with PgBouncer-Postgres setup,
>
> *PgBouncer (PgBouncer 1.23.1 running on VM ins
On 7/16/25 08:22, KK CHN wrote:
Hi,
I am facing an issue with PgBouncer-Postgres setup,
*PgBouncer (PgBouncer 1.23.1 running on VM instance FreeBSD 14.2) and
PostgreSQL DB cluster on a virtual machine (PG version 16.0, RHEL
9.4) *.
My application backend is nodeJS which throws the follow
Hi,
I am facing an issue with PgBouncer-Postgres setup,
*PgBouncer (PgBouncer 1.23.1 running on VM instance FreeBSD 14.2) and
PostgreSQL DB cluster on a virtual machine (PG version 16.0, RHEL 9.4) *.
My application backend is nodeJS which throws the following Error in the
nodejs console log:
12 matches
Mail list logo
