I've problem with my database running on postgresql 16.2. My application is running fine, it can query data, but I'm not able to create a backup using pg_dump or inspect database via psql. Running pd_dump ends in following error: pg_dump:…
I am trying to run pg_dump (or even psql) over our postgresql server v13, with binaries from v13 and v16. Both don't work for me, but do work for my colleagues that are not on Mac, not sure if it's…
On a server with Postgresql 10 did a dump and put it to rsync.net pg_dump -Z1 -Fc <db_name> | ssh <user>@s<server> "dd of=dump" On the other server with Postgresql 9.5 downgraded created dump and tried to restore database. Steps were…
I am using pg_dump (15.3) to dump information on a database. This command works: pg_dump --schema-only --schema foo -d foodb -U postgres -Fp and dumps among other things a CREATE SCHEMA foo; statement This command doesn't: pg_dump --schema-only --schema cron…
Database role XYZ does not have any privilege.How assign privileges for that particular role to create a backup of database using pg_dump? Grant SELECT ON ALL TABLES IN Schema public TO :XYZ Is it possible to restore the backup with…
I have a dump from an SQL database, it is a .sql file. I tried restoring it in pgAdmin but I get an error: pg_restore: error: input file appears to be a text format dump. Please use psql. Then I…
I'm trying to restore tables from a dump file. It's illustrated by a footnote in the paper "VCCFinder-Finding Potential Vulnerabilities in Open-Source Projects to Assist Code Audits", that the dump file that the team created with pg_dump could be read…