Ygthkb

Taking an academic pseudonym?

What is an efficient way to digitize a family photo collection?

Why don't you get burned by the wood benches in a sauna?

Explicit Riemann Hilbert correspondence

Does copper wire need to say it's copper?

Can I legally make a website about boycotting a certain company?

Why do single electrical receptacles exist?

Lubuntu 18.10 File Manager: How to view directory tree structure?

How bad is a Computer Science course that doesn't teach Design Patterns?

What's the reason that we have a different number of days each month?

How do I find the distance from a point to a plane?

How can I give a Ranger advantage on a check due to Favored Enemy without spoiling the story for the player?

What could cause an entire planet of humans to become aphasic?

How can I handle players killing my NPC outside of combat?

What happened to Hermione’s clothing and other possessions after she wiped her parents’ memories of her?

How can I put a period right after the algorithm's number in the algorithm's title?

Putting a vertical line in each Histogram using GraphicsGrid

Including proofs of known theorems in master's thesis

What can I do to encourage my players to use their consumables?

Given a total recursive function, can you always compute its fixed-point?

Are there historical references that show that "diatonic" is a version of 'di-tonic' meaning 'two tonics'?

In the Lost in Space intro why was Dr. Smith actor listed as a special guest star?

Dealing with an internal ScriptKiddie

Is the percentage symbol a constant?

Disable / bypass authentication in PostgreSQL

postgres and passwordless authenticationPostgreSQL - using password/md5 authentication with empty passwordPostgreSQL LDAP authenticationChoosing A PostgreSQL Authentication Method For A Large CoursePostgresSQL authentication errorProxy authentication for PostgeSQLpgbench-tools failed authenticationpsql: FATAL: password authentication failed for user “GuardDog_02”postgres authentication externalHow to Disable Windows Authentication in SQL Server

0

I need to run benchmarks (pgbench) in different environments on different versions of PostgreSQL. Authentication works inconsistently and is a generally huge headache / adds a lot of fragile workarounds around the code that has no reason to care about access to the database.

Is there any way I could do something similar to MySQL:

update user set authentication_string=password(''),

    plugin='mysql_native_password'

    where user='root';

and be done with it forever?

I would also be interested in being able to run the database and utilities as super-user (root). Again, I have no interest in all the security dance, there's nothing to protect, but the price for authentication is too high (weeks of work in order to make scripts work reliably, while they aren't even the main focus of my work).

postgresql authentication

share

asked 2 mins ago

wvxvwwvxvw

101

New contributor

wvxvw is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I need to run benchmarks (pgbench) in different environments on different versions of PostgreSQL. Authentication works inconsistently and is a generally huge headache / adds a lot of fragile workarounds around the code that has no reason to care about access to the database.

Is there any way I could do something similar to MySQL:

update user set authentication_string=password(''),

    plugin='mysql_native_password'

    where user='root';

and be done with it forever?

I would also be interested in being able to run the database and utilities as super-user (root). Again, I have no interest in all the security dance, there's nothing to protect, but the price for authentication is too high (weeks of work in order to make scripts work reliably, while they aren't even the main focus of my work).

postgresql authentication

share

asked 2 mins ago

wvxvwwvxvw

101

New contributor

wvxvw is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I need to run benchmarks (pgbench) in different environments on different versions of PostgreSQL. Authentication works inconsistently and is a generally huge headache / adds a lot of fragile workarounds around the code that has no reason to care about access to the database.

Is there any way I could do something similar to MySQL:

update user set authentication_string=password(''),

    plugin='mysql_native_password'

    where user='root';

and be done with it forever?

I would also be interested in being able to run the database and utilities as super-user (root). Again, I have no interest in all the security dance, there's nothing to protect, but the price for authentication is too high (weeks of work in order to make scripts work reliably, while they aren't even the main focus of my work).

postgresql authentication

share

asked 2 mins ago

wvxvwwvxvw

101

New contributor

wvxvw is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

update user set authentication_string=password(''),

    plugin='mysql_native_password'

    where user='root';

share

asked 2 mins ago

wvxvwwvxvw

101

New contributor

wvxvw is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 2 mins ago

wvxvwwvxvw

101

New contributor

wvxvw is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 2 mins ago

wvxvwwvxvw

101

New contributor

wvxvw is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 2 mins ago

wvxvwwvxvw

101