Its a long shot though https://www.postgresql.org/docs/release/14.2/ mentions
> Fix possible mis-reporting of errors in pg_dump and pg_basebackup (Tom Lane)
>
> The previous code failed to check for errors from some kernel calls, and could report the wrong errno values in other cases.
What version of pg_dump are you using?
r
ricky
03/25/2022, 3:41 PM
@User
pg_dump -V
returns
pg_dump (PostgreSQL) 14.1
ricky
03/25/2022, 3:41 PM
like I said in my original post, pg_dump works if I delete the new test table that I created yesterday
ricky
03/25/2022, 3:41 PM
it seems like any new tables that I've created starting from yesterday doesnt allow me to run pg_dump command anymore
ricky
03/25/2022, 4:11 PM
I cant even view the table properties in pgadmin or run a simple select query
ricky
03/25/2022, 4:22 PM
He
t
tourdownunder
03/26/2022, 5:30 AM
It’s a small chance you are running into the issue as described in release notes and that v14.2 will fix it.