pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
DBeaver postgres localhost access
3+ messages / 3 participants
[nested] [flat]

* DBeaver postgres localhost access
@ 2023-05-20 14:09 Pedro Gonçalves <zensalves@hotmail.com>
  2023-05-22 07:08 ` Re: DBeaver postgres localhost access Ron <ronljohnsonjr@gmail.com>
  2023-05-22 15:44 ` Re: DBeaver postgres localhost access Adrian Klaver <adrian.klaver@aklaver.com>
  0 siblings, 2 replies; 3+ messages in thread

From: Pedro Gonçalves @ 2023-05-20 14:09 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>

Hi.
Good afternoon.

I'm having dificulties with localhost DBeaver postgres training account.
Had access to it and changed password, that presently don't remember.
What can I do to get access again?

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: DBeaver postgres localhost access
  2023-05-20 14:09 DBeaver postgres localhost access Pedro Gonçalves <zensalves@hotmail.com>
@ 2023-05-22 07:08 ` Ron <ronljohnsonjr@gmail.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Ron @ 2023-05-22 07:08 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

On 5/20/23 09:09, Pedro Gonçalves wrote:
>
> Hi.
>
> Good afternoon.
>
> I’m having dificulties with localhost DBeaver postgres training account.
>
> Had access to it and changed password, that presently don’t remember.
>
> What can I do to get access again?
>
> From DBeaver I was told to address this request to PostgreSQL.
>

Get your DBA to change the password for you.

-- 
Born in Arizona, moved to Babylonia.

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: DBeaver postgres localhost access
  2023-05-20 14:09 DBeaver postgres localhost access Pedro Gonçalves <zensalves@hotmail.com>
@ 2023-05-22 15:44 ` Adrian Klaver <adrian.klaver@aklaver.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Adrian Klaver @ 2023-05-22 15:44 UTC (permalink / raw)
  To: Pedro Gonçalves <zensalves@hotmail.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>

On 5/20/23 07:09, Pedro Gonçalves wrote:
> Hi.
> 
> Good afternoon.
> 
> I’m having dificulties with localhost DBeaver postgres training account.
> 
> Had access to it and changed password, that presently don’t remember.
> 
> What can I do to get access again?
> 
>  From DBeaver I was told to address this request to PostgreSQL.


1) Find the pg_hba.conf file for the server and change the auth method 
to trust for local connections, where local means socket connection. 
This is shown in example here:

https://www.postgresql.org/docs/current/auth-pg-hba-conf.html

Example 21.1. Example pg_hba.conf Entries.

2) Reload/restart server

3) Using psql connect with

psql -d <db_name> -U <user_name> -p <port_no>

Once you are connected you can use ALTER USER <user_name> WITH PASSWORD 
'some_pwd';

This assumes the <user_name> you connect as has sufficient privileges to 
do the the ALTER. One way to ensure that is use the postgres user.

4) Once you have a new password set and shown to work then decide 
whether you want local to remain set at trust or change it to something 
more secure. If you change it then you will need to repeat 2).


> 
> Kind Regards,
> 
> Pedro Gonçalves
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com






^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2023-05-22 15:44 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-05-20 14:09 DBeaver postgres localhost access Pedro Gonçalves <zensalves@hotmail.com>
2023-05-22 07:08 ` Ron <ronljohnsonjr@gmail.com>
2023-05-22 15:44 ` Adrian Klaver <adrian.klaver@aklaver.com>

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