pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #18425: KB5036892 Microsoft Update Package Issue
4+ messages / 3 participants
[nested] [flat]
* BUG #18425: KB5036892 Microsoft Update Package Issue
@ 2024-04-10 10:06 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 4+ messages in thread
From: PG Bug reporting form @ 2024-04-10 10:06 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: tanseltekin01@gmail.com
The following bug has been logged on the website:
Bug reference: 18425
Logged by: Mustafa Tansel Tekin
Email address: tanseltekin01@gmail.com
PostgreSQL version: Unsupported/Unknown
Operating system: Windows 10
Description:
Hi,
I am Mustafa from Turkiye, last night my computer is updated automatically.
But KB50336892 number package file is stopped pgsql 11 service. I solved
this problem form uninstalled this update package but. Windows 10 automatic
update process will be updated other time. Please check this pgsql service
and ıf it is required to contact to microsoft.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: BUG #18425: KB5036892 Microsoft Update Package Issue
@ 2024-04-10 14:30 Laurenz Albe <laurenz.albe@cybertec.at>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 4+ messages in thread
From: Laurenz Albe @ 2024-04-10 14:30 UTC (permalink / raw)
To: tanseltekin01@gmail.com; pgsql-bugs@lists.postgresql.org
On Wed, 2024-04-10 at 10:06 +0000, PG Bug reporting form wrote:
> Operating system: Windows 10
>
> I am Mustafa from Turkiye, last night my computer is updated automatically.
> But KB50336892 number package file is stopped pgsql 11 service. I solved
> this problem form uninstalled this update package but. Windows 10 automatic
> update process will be updated other time. Please check this pgsql service
> and ıf it is required to contact to microsoft
This is the same problem as this one:
https://www.postgresql.org/message-id/flat/18196-b10f93dfbde3d7db%40postgresql.org
The problem is mostly in the Windows installer.
To fix your system, revert the patch so that you can start PostgreSQL
(you already did that).
Then stop the PostgreSQL service and take a backup of the data directory,
in case you mess up something below. Start the service again.
Then you have to connect as superuser and manually update "pg_database" to
change the collation and character type to "tr-TR"; something like
UPDATE pg_database
SET datcollate = 'tr-TR.1254'
WHERE datcollate = 'Turkish_Turkey.1254';
UPDATE pg_database
SET datctype = 'tr-TR.1254'
WHERE datctype = 'Turkish_Turkey.1254';
(I don't have Windows - could somebody ascertain that these values are correct?)
Then you'd update "postgresql.conf" with a text editor and likewise change
all occurrences of "Turkish_Turkey.1254" to "tr-TR.1254".
After that, restart your PostgreSQL service and see if everything works as it should.
Then you should be able to apply the Windows patch, and PostgreSQL should be fine.
As I mentioned above, I don't run Windows myself, so try it on a test system before
you do it on the production database.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 4+ messages in thread
* BUG #18425: KB5036892 Microsoft Update Package Issue
@ 2024-04-15 06:45 MUSTAFA TANSEL TEKİN <tanseltekin01@gmail.com>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 4+ messages in thread
From: MUSTAFA TANSEL TEKİN @ 2024-04-15 06:45 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org
Hi,
Thank you for your interesting. But solution way is not working because
your solution way is effected by KB5031455 update package. But my problem
update package KB5036892. Totally different. KB5036892 package is changed
win10 copilot app update. It is stopped pgsql service on windows 10-11.And
this package is publishing to Europe countries. This package will created
big problems...
Laurenz Albe <laurenz.albe@cybertec.at>, 10 Nis 2024 Çar, 17:30 tarihinde
şunu yazdı:
> On Wed, 2024-04-10 at 10:06 +0000, PG Bug reporting form wrote:
> > Operating system: Windows 10
> >
> > I am Mustafa from Turkiye, last night my computer is updated
> automatically.
> > But KB50336892 number package file is stopped pgsql 11 service. I solved
> > this problem form uninstalled this update package but. Windows 10
> automatic
> > update process will be updated other time. Please check this pgsql
> service
> > and ıf it is required to contact to microsoft
>
> This is the same problem as this one:
>
> https://www.postgresql.org/message-id/flat/18196-b10f93dfbde3d7db%40postgresql.org
>
> The problem is mostly in the Windows installer.
>
> To fix your system, revert the patch so that you can start PostgreSQL
> (you already did that).
>
> Then stop the PostgreSQL service and take a backup of the data directory,
> in case you mess up something below. Start the service again.
>
> Then you have to connect as superuser and manually update "pg_database" to
> change the collation and character type to "tr-TR"; something like
>
> UPDATE pg_database
> SET datcollate = 'tr-TR.1254'
> WHERE datcollate = 'Turkish_Turkey.1254';
>
> UPDATE pg_database
> SET datctype = 'tr-TR.1254'
> WHERE datctype = 'Turkish_Turkey.1254';
>
> (I don't have Windows - could somebody ascertain that these values are
> correct?)
>
> Then you'd update "postgresql.conf" with a text editor and likewise change
> all occurrences of "Turkish_Turkey.1254" to "tr-TR.1254".
>
> After that, restart your PostgreSQL service and see if everything works as
> it should.
>
> Then you should be able to apply the Windows patch, and PostgreSQL should
> be fine.
>
> As I mentioned above, I don't run Windows myself, so try it on a test
> system before
> you do it on the production database.
>
> Yours,
> Laurenz Albe
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: BUG #18425: KB5036892 Microsoft Update Package Issue
@ 2024-04-15 08:35 Laurenz Albe <laurenz.albe@cybertec.at>
parent: MUSTAFA TANSEL TEKİN <tanseltekin01@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Laurenz Albe @ 2024-04-15 08:35 UTC (permalink / raw)
To: MUSTAFA TANSEL TEKİN <tanseltekin01@gmail.com>; pgsql-bugs@lists.postgresql.org
On Mon, 2024-04-15 at 09:45 +0300, MUSTAFA TANSEL TEKİN wrote:
> Laurenz Albe <laurenz.albe@cybertec.at>, 10 Nis 2024 Çar, 17:30 tarihinde şunu yazdı:
> > On Wed, 2024-04-10 at 10:06 +0000, PG Bug reporting form wrote:
> > > Operating system: Windows 10
> > >
> > > I am Mustafa from Turkiye, last night my computer is updated automatically.
> > > But KB50336892 number package file is stopped pgsql 11 service. I solved
> > > this problem form uninstalled this update package but. Windows 10 automatic
> > > update process will be updated other time. Please check this pgsql service
> > > and ıf it is required to contact to microsoft
> >
> > This is the same problem as this one:
> > https://www.postgresql.org/message-id/flat/18196-b10f93dfbde3d7db%40postgresql.org
>
> Thank you for your interesting. But solution way is not working because your solution
> way is effected by KB5031455 update package. But my problem update package KB5036892.
> Totally different. KB5036892 package is changed win10 copilot app update. It is stopped
> pgsql service on windows 10-11.And this package is publishing to Europe countries.
> This package will created big problems...
Sorry for my mistaken assumption.
I guess you'd have to provide a much more detailed description, so that somebody
can reproduce your problem.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2024-04-15 08:35 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-04-10 10:06 BUG #18425: KB5036892 Microsoft Update Package Issue PG Bug reporting form <noreply@postgresql.org>
2024-04-10 14:30 ` Laurenz Albe <laurenz.albe@cybertec.at>
2024-04-15 06:45 ` MUSTAFA TANSEL TEKİN <tanseltekin01@gmail.com>
2024-04-15 08:35 ` Laurenz Albe <laurenz.albe@cybertec.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox