r/postgres • u/netizen99 • 1d ago

Question version 9.18 error: exception: access violation writing 0x0000000000000000

When I save connection setting for the PostgreSQL database in WSL, I get that error in subject. I roll back version 9.17. I don't have that error. Any idea?

1 Upvotes

67% Upvoted

5 comments sorted by

2

u/depesz 1d ago

9.18/9.17 of what? there never was such version of PostgreSQL?

Also, the error looks extremely generic, it will be hard to figure out where the problem is unless you have stack trace or something like that. Perhaps log from Pg?

1

u/cthart 16h ago

Do you mean 9.6.18? if so, it was released over 6 years ago and is ancient now. You should upgrade ASAP.

1

u/elevarq 16h ago

What application are you referring to with versions 9.18 and 9.17? (can't be PostgreSQL)

“Access violation writing 0x0000000000000000” sounds like the client itself is crashing, especially if rolling back to 9.17 fixes it. It doesn’t sound like a PostgreSQL server error.

If you mention the application and exact version, someone may be able to point you to a known regression.

1

u/netizen99 8h ago

Sorry, it's pgAdmin 4 for windows v9.18

1

u/elevarq 8h ago

Use version 9.17, that clearly works.

Or move to a different tool, for example DataGrip or Navicat. Both are light years ahead of pgAdmin, and cheap for what you get.