Re: Windows installation problem at post-install step

2024-07-22 Thread Ertan Küçükoglu
Adrian Klaver , 22 Tem 2024 Pzt, 23:18 tarihinde şunu yazdı: > It would seem to me the process would be: > > 1) Create Windows VM > > 2) Run the localizer tool in the VM to get the old locale name in place. > > 3) Run the installer. > I just tested that and failed at the same step. My understand

Re: Windows installation problem at post-install step

2024-07-22 Thread Ertan Küçükoglu
Adrian Klaver , 22 Tem 2024 Pzt, 22:56 tarihinde şunu yazdı: > > Why not use that? > There was already an installed PostgreSQL just failing to start. I used that localization tool and it started again. This was the production system where Windows update changed the name of the Turkish localizatio

Re: Windows installation problem at post-install step

2024-07-22 Thread Ertan Küçükoglu
Adrian Klaver , 22 Tem 2024 Pzt, 21:10 tarihinde şunu yazdı: > I am getting out of my depth here, but I am pretty sure that: > > ENCODING = 'UTF8' LOCALE_PROVIDER = libc LOCALE = 'Turkish_Turkey.1254' > > is not going to work. That you will need to change the locale to a > Turkish UTF8 name. > I

Re: Windows installation problem at post-install step

2024-07-22 Thread Ertan Küçükoglu
Adrian Klaver , 22 Tem 2024 Pzt, 20:37 tarihinde şunu yazdı: > What is the command you use to restore the pg_dumpall file? > within psql I run \i template1 should not be dropped in the pg_dumpall file. > > Is there output that shows that happening? > -- -- Databases -- -- -- Database "templat

Re: Windows installation problem at post-install step

2024-07-22 Thread Ertan Küçükoglu
Adrian Klaver , 22 Tem 2024 Pzt, 20:04 tarihinde şunu yazdı: > When you connect using psql do you see template0, template1 and postgres > when you do \l? > Yes postgres=# \l List of databases Name| Owner | Encoding | Locale Provide

Re: Windows installation problem at post-install step

2024-07-22 Thread Ertan Küçükoglu
Adrian Klaver , 22 Tem 2024 Pzt, 17:49 tarihinde şunu yazdı: > Provide the following info: > > 1) Linux distro and version. > > 2) How did you install Postgres? > > 3) Versions of Postgres that was dumped from and restored to. > > 4) How did you initdb the Postgres cluster? > > 5) Can you connect

Re: Windows installation problem at post-install step

2024-07-22 Thread Ertan Küçükoglu
Sandeep Thakkar , 22 Tem 2024 Pzt, 15:01 tarihinde şunu yazdı: > > When I checked the installation log shared by Ertan, I do see that the > locale passed to initcluster script is the same as returned by the > getlocales executable. > > Executing C:\Windows\System32\cscript //NoLogo "C:\Program > F

Re: Windows installation problem at post-install step

2024-07-22 Thread Ertan Küçükoglu
Adrian Klaver , 21 Tem 2024 Paz, 22:29 tarihinde şunu yazdı: > If the backup was done using pg_dump it should work. If you are talking > about a file level backup then it would not work. > Backup file is from a cluster backup taken using pg_dumpall. When I try to restore it on Linux, I get below

Re: Windows installation problem at post-install step

2024-07-21 Thread Ertan Küçükoglu
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

2024-07-21 Thread Ertan Küçükoglu
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

2024-07-21 Thread Ertan Küçükoglu
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

2024-07-21 Thread Ertan Küçükoglu
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

Windows installation problem at post-install step

2024-07-21 Thread Ertan Küçükoglu
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.”

No primary key table

2019-09-13 Thread Ertan Küçükoglu
Hello, We are using PostgreSQL 10.0 on a Windows VM. There is one database in that server. There are several tables that will be used for data warehouse purposes. There are daily inserts and relatively heavy bulk (whole month data at once) reads at end of months. Reads will be from several hun