Hello,
One of the systems running PostgreSQL 14.7 receive a lot of lines like in
the subject. I have below pg_hba.conf line and that line causes these to be
logged.
host all all 0.0.0.0/0 reject
If possible, I do not want to see these lines in my logs. But, I failed to
find a parameter for it.
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
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
Hello,
I am using PostgreSQL v14.5 on Linux Debian 11.5. I recently observe very
high CPU usage on my Linux system as below
PID USER PR NIVIRTRESSHR S %CPU %MEM TIME+
COMMAND
2357756 postgres 20 0 2441032 2,3g 4 S 298,7 67,9 2114:58
Tspjzj2Z
I could not f
Hello again,
While I was searching for a solution, I saw an example of manual running of
dump file within psql. Tried this and it did work just fine.
\connect mydb
\i last_backup.bak
Above two commands completed without any loading error at all.
Now I wonder why command line did not work.
Do le
Hello,
I am using PostgreSQL 14.5
I tried to move a Linux database to Windows. Both identical version.
Linux dump successfully loaded on Windows system.
Reason for changing system didn't work out and now I am trying to move it
back because it has some modifications.
I just dumped a datab
-Original Message-
From: Rob Sargent
Sent: Saturday, July 18, 2020 5:56 AM
To: pgsql-general@lists.postgresql.org
Subject: Re: Errors after cloning OS to new disk under Hyper-V
> Have you tried to REINDEX as suggested?
I cannot get access to psql. If there is a way to reindex without ha
Hello,
This is PostgreSQL v10.10 64Bit, running on Windows 10 64Bit.
One user, by himself, without asking for help, cloned his OS from one disk to
Hyper-V disk. Old disk was not accessed, OS was shutdown while he is doing the
cloning. He used some kind of tool that I do not know for that purpos
