I am trying to dump the database in my local system by using the command:
pg_restore –host=localhost- -port=5432 –dbname=dev_db –no-owner –no-privileges db_dump_new.backup But I get an er
Tag: PG
PostgreSQL – PG_UPGRADE tool failed: invalid “unknown” user column
The Postgresql update from 9.6 to 10.4 (on Fedora 28) confuses me: a table in a database has a column of data type “unknown”. I am happy to delete the column , But because I cannot start the postgr
PostgreSQL remote connection, fatal error: No PG_HBA.conf recorded for host “…”, users “…”, database “…”, SSL close
PostgreSQL remote connection method
Sometimes when connecting remotely, it will report Error connecting to the server: fatal error: not used for host “…”, User “…”, database “…”, pg_hba