Re: Windows installation problem at post-install step

On Mon, Jul 22, 2024 at 11:51 PM Sandeep Thakkar wrote: > EDB's windows installer gets the locales on the system using the > https://github.com/EnterpriseDB/edb-installers/blob/REL-16/server/scripts/windows/getlocales/getlocales.cpp > and then substitute some patterns > (https://github.com/Ente

Re: Windows installation problem at post-install step

On 7/22/24 13:34, Ertan Küçükoglu wrote: 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)

Re: Windows installation problem at post-install step

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

On 7/22/24 13:15, Ertan Küçükoglu wrote: 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 prod

Re: Windows installation problem at post-install step

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

On 7/22/24 11:48, Ertan Küçükoglu wrote: 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 goi

Re: Windows installation problem at post-install step

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

On 7/22/24 10:51 AM, Ertan Küçükoglu wrote: 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.

Re: Windows installation problem at post-install step

We On Mon, Jul 22, 2024, 1:51 PM Ertan Küçükoglu wrote: > 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

Re: Windows installation problem at post-install step

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: Unsuscribe

On 7/22/24 10:45 AM, Dunia Ramazani wrote: Unsuscribe Follow instructions here: https://lists.postgresql.org/unsubscribe/ -- Adrian Klaver adrian.kla...@aklaver.com

Unsuscribe

Unsuscribe

Re: Windows installation problem at post-install step

On 7/22/24 10:09 AM, Ertan Küçükoglu wrote: 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                              

Re: Windows installation problem at post-install step

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

On 7/22/24 09:51, Ertan Küçükoglu wrote: 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

Re: Windows installation problem at post-install step

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: Fwd: lost master password

On 7/22/24 06:32, Afa Jamal wrote: master Read: https://www.pgadmin.org/docs/pgadmin4/8.9/master_password.html Sent from Gmail Mobile On Mon, Jul 22, 2024 at 9:30 AM Laurenz Albe > wrote: On Fri, 2024-07-19 at 11:59 -0400, Afa Jamal wrote: > can

Re: Windows installation problem at post-install step

On 7/22/24 03:10, Ertan Küçükoglu wrote: 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 clus

Re: Fwd: lost master password

master Sent from Gmail Mobile On Mon, Jul 22, 2024 at 9:30 AM Laurenz Albe wrote: > On Fri, 2024-07-19 at 11:59 -0400, Afa Jamal wrote: > > can you help me with reset > > I am not able to do this > > what u caan advise > > > > On Mon, Jun 10, 2024 at 5:06 AM Laurenz Albe > wrote: > > > On Sun

Re: Fwd: lost master password

On Fri, 2024-07-19 at 11:59 -0400, Afa Jamal wrote: > can you help me with reset  > I am not able to do this > what u caan advise > > On Mon, Jun 10, 2024 at 5:06 AM Laurenz Albe wrote: > > On Sun, 2024-06-09 at 17:46 -0400, Afa Jamal wrote: > > > how you can help me with lost super password? > >

Re: repomd.xml.asc missing in some Fedora 40 repos

This is solved now. Thanks! El 22/7/24 a las 12:35, José María Terry Jiménez escribió: Hello In some yum repos in Fedora 40, there is repomd.xml.asc missing file, at least in pgdg-common, pgdg13, pgdg12, other works. Best, Errors from dnf upgrade: PostgreSQL common RPMs for Fedora 40

Re: Windows installation problem at post-install step

On Mon, Jul 22, 2024 at 5:52 PM Ertan Küçükoglu wrote: > 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.

Re: Fwd: lost master password

Hello can you help me with reset I am not able to do this what u caan advise On Mon, Jun 10, 2024 at 5:06 AM Laurenz Albe wrote: > On Sun, 2024-06-09 at 17:46 -0400, Afa Jamal wrote: > > how you can help me with lost super password? > > Are you talking about a PostgreSQL superuser password or >

Re: Windows installation problem at post-install step

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

Hi On Mon, Jul 22, 2024 at 1:02 PM Sandeep Thakkar < sandeep.thak...@enterprisedb.com> wrote: > > > On Mon, Jul 22, 2024 at 5:21 PM Sandeep Thakkar < > sandeep.thak...@enterprisedb.com> wrote: > >> Hi, >> >> EDB's windows installer gets the locales on the system using the >> https://github.com/En

Re: Bloated pg_catalog.pg_largeobjects

Vacuum Full will not help here if you have large objects present in the pg_largeobjects table but not being referred to by any table. Vacuumlo doesn't require downtime but based on the data it needs to remove can run long and use resources and hence schedule it in off peak hours. You can do a dry r

Re: Windows installation problem at post-install step

On Mon, Jul 22, 2024 at 5:21 PM Sandeep Thakkar < sandeep.thak...@enterprisedb.com> wrote: > Hi, > > EDB's windows installer gets the locales on the system using the > https://github.com/EnterpriseDB/edb-installers/blob/REL-16/server/scripts/windows/getlocales/getlocales.cpp > and > then substitu

Re: Windows installation problem at post-install step

Hi, On Mon, Jul 22, 2024 at 1:57 AM Thomas Munro wrote: > 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 i

Re: Windows installation problem at post-install step

Hi, EDB's windows installer gets the locales on the system using the https://github.com/EnterpriseDB/edb-installers/blob/REL-16/server/scripts/windows/getlocales/getlocales.cpp and then substitute some patterns ( https://github.com/EnterpriseDB/edb-installers/blob/REL-16/server/pgserver.xml.in#L28

Re: Bloated pg_catalog.pg_largeobjects

Hi I would suggest to backup your DB before doing such a thing. Run Vaccum Full, (VACUUM FULL pg_catalog.pg_largeobject) Running this on the system table might be risky Make sure you backup the database. & if you are using PG version above 9.1 use Pg_repack to reclaim the space. Note: It can b

repomd.xml.asc missing in some Fedora 40 repos

Hello In some yum repos in Fedora 40, there is repomd.xml.asc missing file, at least in pgdg-common, pgdg13, pgdg12, other works. Best, Errors from dnf upgrade: PostgreSQL common RPMs for Fedora 40 - x86_64 305  B/s | 146  B 00:00 PostgreSQL common RPMs for Fedora 40 - x86_64 2.4 MB/s

Re: Windows installation problem at post-install step

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: Regarding publish_via_partiton_root with pglogical

Hi Durgamahesh In pglogical extension, there is no direct equivalent to the publish_via_partition_root option found in the built-in logical replication you can achieve similar results when a new partition is added; you must add it to the replication set using pglogical.replication_set_add_table.

Re: Re. Select with where condition times out

Trying to trim to still relevant parts, as mail is becoming extremely hard to read. On Mon, 22 Jul 2024 at 07:08, sivapostg...@yahoo.com wrote: > Actual Query: > select source_node_id, create_time from sym_data where table_name = > 'tx_combined_sales_header' and ((event_type = 'I' and row_data