EDB to Postgres Migration

List, Recently I happened to have managed a few EDB instances running on the EDB-10 version . I am looking for an option for migrating all these EDB instances to Postgres Community edition. 1. What major steps / actions involved ( in bird's eye view ) for a successful migration to postgres

Re: How to add function schema in search_path in option definitio

eh.. yes to be honest what I create is more similar to an extension rather than a package, I don't believe to be able to create extensions in cloud sql (the actual target db). However , is there a way to share this preliminar "extension" with the community? I'm interested to discuss about solution

Re: Reset Postgresql users password

On Wed, Jul 12, 2023 at 1:17 PM Gurjeet Singh wrote: > for rec in select > 'alter user '|| quote_ident(usename) > ||' with password '|| quote_literal('newpassword') > > Which is more clearly written using the format function: ... for rec in select

Re: Reset Postgresql users password

Thank you all very much. I really appreciate !! On Wed, Jul 12, 2023 at 4:17 PM Gurjeet Singh wrote: > On Wed, Jul 12, 2023 at 12:42 PM Mateusz Henicz > wrote: > > > > You can also just write an sql and execute it, like: > > > > select 'alter user '|| usename ||' with password ''newpassword'';

Re: Reset Postgresql users password

On Wed, Jul 12, 2023 at 12:42 PM Mateusz Henicz wrote: > > You can also just write an sql and execute it, like: > > select 'alter user '|| usename ||' with password ''newpassword'';' from > pg_user; > \gexec Note that the above assumes you're using psql. For tools other than psql, you'd have t

Re: Reset Postgresql users password

You can also just write an sql and execute it, like: select 'alter user '|| usename ||' with password ''newpassword'';' from pg_user; \gexec Cheers, Mateusz śr., 12 lip 2023 o 21:35 Gianni Ceccarelli napisał(a): > On 2023-07-12 Johnathan Tiamoh wrote: > > I wish to find out if there is a way

Re: Reset Postgresql users password

On 2023-07-12 Johnathan Tiamoh wrote: > I wish to find out if there is a way to reset all users in Postgresql > password to the same password at once. I guess you could update the `pg_catalog.pg_authid` table, see https://www.postgresql.org/docs/15/catalog-pg-authid.html -- Dakkar -

Reset Postgresql users password

Hello, I wish to find out if there is a way to reset all users in Postgresql password to the same password at once. Thank you Tiamoh J

Re: Requesting Information for GSSAPI

Greetings, * Lingesan Jeyapandy (lingesan.jeyapa...@gilead.com) wrote: > We have configured postgres GSSAPI setup on Linux server. We have huge > domain AD users in our org. > > But we are looking to limit access only to setup AD distributed groups. Is > there any way to control access only a

RE: How to add function schema in search_path in option definitio

Hi, We have hit similar issues with the software that we develop. We don’t specify the schema names in stored procedures/functions we create. The way we resolved it was to define the schemas where the stored procedures/functions are located in the search path as part of the connection string w

[Beginner Question] Will the vxid replace xid?

Hi community, When I read the newest document, I find there seems to be a new concept "vxid", and It's 64 bit. Is there a plan to replace xid? Or just my careless? Can someone give me some advice? Thanks in advance! Yours, Wen Yi