Re: Question About PostgreSQL Extensibility

For the same reason that you can use python or perl in postgresql. It's just another language. I have .net code running on several sql servers and to change the database to postgresql I have to reprogram them. On Thursday, October 12, 2023 at 09:44:08 AM GMT-4, Laurenz Albe wrote: On Thu, 2

Re: Excel Source [24]] Error: System.Exception: SqlTruncateException: Numeric arithmetic causes

The numeric(19, 18) field type can only store numbers less than 10 with 18 decimal places. To save the number 36655.63 you need a numeric(12, 2) field type. On Thursday, February 29, 2024 at 10:00:10 AM GMT-5, Erik Wienhold wrote: cc'ing list. On 2024-02-29 07:16 +0100, Anthony Apoll

Re: Running psql in a docker container

In the docker-compose.yml file it can be passed in the environment variables. POSTGRES_INITDB_ARGS: "--encoding=UTF-8" On Thursday, July 11, 2024 at 10:58:14 AM GMT-4, H wrote: I used to successfully run psql server 13 in a CentOS 7 docker container with CentOS 7 as the host operating syst

The Amazon CloudFront distribution is configured to block access from your country.

I am trying to download the installer and I get this error. The same happens with binary files. --- 403 ERROR The request could not be satisfied. The Amazon CloudFront distribution is configured to block access from your countr

Re: The Amazon CloudFront distribution is configured to block access from your country.

Because it is the Postgresql installer. https://www.enterprisedb.com/downloads/postgres-postgresql-downloads On Saturday, April 10, 2021, 07:30:29 PM GMT-4, Ron wrote: On 4/10/21 2:00 PM, felix.quin...@yahoo.com wrote: > I am trying to download the installer and I get this error. The same ha

Re: The Amazon CloudFront distribution is configured to block access from your country.

I see no reason why ask elsewhere first, the link for the installer download is on the Postgresql website, not elsewhere. The most logical thing to do is ask here first. On Saturday, April 10, 2021, 08:07:15 PM GMT-4, Ron wrote: Then you should ask EDB, or Amazon, or use a VPN. On 4/10/

Re: The Amazon CloudFront distribution is configured to block access from your country.

The link https://www.postgresql.org/download/ in the PostgreSQL Downloads section, Windows, redirects to the page https://www.postgresql.org/download/windows/. There are only two links in it and both redirect to the EnterpriseDB site. At no time is it clarified that it is a third party, even th

Re: The Amazon CloudFront distribution is configured to block access from your country.

The entire enterprisedb site is blocked for me. It's an American company, so I imagine it's happening. In the end I ended up downloading it from www.download3k.es. I checked the installer certificate and it seems to be correct. Thank you very much to all On Sunday, April 11, 2021, 11:38:43 AM

Re: The Amazon CloudFront distribution is configured to block access from your country.

Unfortunately the official site for downloading the installer is blocked for me. I only had that option and trust what I am downloading. On Monday, April 12, 2021, 03:55:37 PM GMT-4, Condor wrote: On 12-04-2021 17:53, felix.quin...@yahoo.com wrote: > The entire enterprisedb site is blocked

Re: What are best practices wrt passwords?

Use the PGPASSWORD environment variable. Example: SET PGPASSWORD=P0stgres psql -h localhost -p 5432 -U postgres -d postgres -c "SELECT 1;'" https://www.postgresql.org/docs/current/libpq-envars.html On Wednesday, October 16, 2024 at 08:26:05 AM GMT-4, wrote: Hello all, I'd like to be able t

Re: Running docker in postgres, SHM size of the docker container in postgres 16

Docker databases do not perform well under heavy load. Everything can be configured to improve performance but going through the Docker disk access layer will significantly decrease performance. On Wednesday, November 20, 2024 at 06:06:36 AM GMT-5, Koen De Groote wrote: That explains a lot.