Re: Bloated pg_catalog.pg_largeobjects

You have to run vacuumlo to remove orphaned large objects. https://www.postgresql.org/docs/current/vacuumlo.html Regards, Priyanka On Sun, 21 Jul 2024 at 12:46 AM, wrote: > Hello All, > > I've got a cluster that's having issues with pg_catalog.pg_largeobject > getting massively bloated. Vacuum

Windows installation problem at post-install step

Hello, I am trying to install posgreql-16.3-2-windows-x64.exe on Windows 10 English VM with all updates installed and up to date. During installation I get an error message “Problem running post-install step. Installation may not complete correctly The database cluster initialization failed.”

Re: Windows installation problem at post-install step

On 7/21/24 09:16, Ertan Küçükoglu wrote: Hello, I am trying to install posgreql-16.3-2-windows-x64.exe on Windows 10 English VM with all updates installed and up to date. What is the host OS and version? What is the locale in the VM? During installation I get an error message “Problem run

Re: Windows installation problem at post-install step

Adrian Klaver , 21 Tem 2024 Paz, 20:04 tarihinde şunu yazdı: > On 7/21/24 09:16, Ertan Küçükoglu wrote: > > Hello, > > > > I am trying to install posgreql-16.3-2-windows-x64.exe on Windows 10 > > English VM with all updates installed and up to date. > > What is the host OS and version? > > What is

Re: Windows installation problem at post-install step

On 7/21/24 10:21, Ertan Küçükoglu wrote: Adrian Klaver >, 21 Tem 2024 Paz, 20:04 tarihinde şunu yazdı: On 7/21/24 09:16, Ertan Küçükoglu wrote: > Hello, > > I am trying to install posgreql-16.3-2-windows-x64.exe on Windows 10 > English V

Re: Windows installation problem at post-install step

Adrian Klaver , 21 Tem 2024 Paz, 20:34 tarihinde şunu yazdı: > > What happens if you set the VM to Türkiye and install? > Problem still exists even if I set everything to Türkiye and Turkish. 1- I tried to manually select default locale to "Turkey, Türkiye" 2- I tried to install using [Default lo

Re: Windows installation problem at post-install step

On 7/21/24 10:52, Ertan Küçükoglu wrote: Adrian Klaver >, 21 Tem 2024 Paz, 20:34 tarihinde şunu yazdı: What happens if you set the VM to Türkiye and install? Problem still exists even if I set everything to Türkiye and Turkish. 1- I tried to manually sel

Re: Windows installation problem at post-install step

Adrian Klaver , 21 Tem 2024 Paz, 21:48 tarihinde şunu yazdı: > I don't know enough about Windows locales and the EDB installer to be of > further help in that direction. > > Is it feasible to install a Linux VM and install Postgres there? > My main purpose was and still is to reach EDB people usi

Re: Windows installation problem at post-install step

On 7/21/24 12:00, Ertan Küçükoglu wrote: Adrian Klaver >, 21 Tem 2024 Paz, 21:48 tarihinde şunu yazdı: I don't know enough about Windows locales and the EDB installer to be of further help in that direction. Is it feasible to install a Linux VM

Re: Windows installation problem at post-install step

On Mon, Jul 22, 2024 at 7:29 AM Adrian Klaver wrote: > On 7/21/24 12:00, Ertan Küçükoglu wrote: > > My main purpose was and still is to reach EDB people using the forum and > > let them know about the problem. > > I believe it is something to be fixed for future installations. I would > > like to

Re: Windows installation problem at post-install step

Thomas Munro , 21 Tem 2024 Paz, 23:27 tarihinde şunu yazdı: > I guess this is where EDB installer issues should go: > > https://github.com/EnterpriseDB/edb-installers/issues Thanks. I just added a new issue there. 2. Some existing database clusters which had been installed with the > name "Tur

Re: Windows installation problem at post-install step

On Mon, Jul 22, 2024 at 11:58 AM Ertan Küçükoglu wrote: > Thomas Munro , 21 Tem 2024 Paz, 23:27 tarihinde şunu > yazdı: >> 2. Some existing database clusters which had been installed with the >> name "Turkish_Turkey.1254" became unstartable when the OS upgrade >> renamed that locale to "Turkish_

pgBackRest for multiple production servers

Hi list , I am exploring the PgBackRest tool for production deployment. ( My lab setup with one Database server and another Reposerver deployed working fine as in the official docs) Query: What may be the standard practice employed to backup multiple production servers to one RepoServer ? (

Re: Re. Select with where condition times out

On Sunday, 21 July, 2024 at 12:52:22 am IST, Michael Nolan wrote: On Thu, Jul 18, 2024 at 4:38 AM sivapostg...@yahoo.com wrote: > > Hello, > PG V11 > > Select count(*) from table1 > Returns 10456432 > > Select field1, field2 from table1 where field3> '2024-07-18 12:00:00' > Times out

Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc()

Hi , You can consider the pg_pathman extension. *Muhammad Imtiaz* *PostgreSQL Technical Support Lead * */ Pakistan R&D* *Mobile: +923345072521* *Email: imtia...@bitnine.net * On Fri, Jul 19, 2024 at 7:55 PM Durgamahesh Manne wrote: > > > On Fri, Jul 19, 2024 at 7:55 PM Christoph Berg wrote

Re: Re. Select with where condition times out

On Saturday, 20 July, 2024 at 10:55:30 pm IST, Francisco Olarte wrote: Hi: Please, avoid top posting, specially when replying to long mail with various points,m it makes it nearly impossible to track what you are replying to. OK On Sat, 20 Jul 2024 at 13:44, sivapostg...@yahoo.com