Re: pg_dump problem with postgres user

2023-02-12 Thread Adrian Klaver
On 2/12/23 13:10, ertan.kucuko...@1nar.com.tr wrote: Hello, My service provider spam filter just blocked your message and so I send a separate one. Your suspicion seems like correct. Postgres user is no more a superuser. Seems like they added postgresql_user and made it superuser. Who is they

Re: pg_dump problem with postgres user

2023-02-12 Thread ertan.kucukoglu
Hello, My service provider spam filter just blocked your message and so I send a separate one. Your suspicion seems like correct. Postgres user is no more a superuser. Seems like they added postgresql_user and made it superuser. I thought I only allow access with certificate to the database. OS

Re: pg_dump problem with postgres user

2023-02-12 Thread David G. Johnston
On Sun, Feb 12, 2023 at 7:22 AM wrote: > > I am using postgresql 14.6. PostgreSQL 15.1 is also installed in my system. > I just recognize that my scheduled backups are failing. > > I am using postgres user for backup user and .pgpass file for no password > prompt. > Given that you have "trust"

pg_dump problem with postgres user

2023-02-12 Thread ertan.kucukoglu
Hello, I am using postgresql 14.6. PostgreSQL 15.1 is also installed in my system. I just recognize that my scheduled backups are failing. I am using postgres user for backup user and .pgpass file for no password prompt. Result is same even I force a password prompt. Google results are I get are