0

Some months ago I used a postgres in 9.5 version. I crated a database backup (by using pgadmin) and restored this backup in postgres 9.6 (by using pgadmin as well). Database works fine but there is a problem to create a backup from postgres 9.6 (currently there are much more data than a few months ago).

I tried to do it by using pgadmin but there is an error:

pg_dump: server version: 9.6.16; pg_dump version: 9.5.5 pg_dump: aborting because of server version mismatch

Then I tried to create backup from command line by using:

pg_dump dbname > dbname-backup.dump

or

pg_dump dbname > dbname-backup.sql

but if I executed this scripts - nothing happend. There is no error, no any message, backup is no generated.

There is a windows 10 and pgadmin 3. How is it possible to crate a backup of this database?

1 Answer 1

1

pgAdmin 3 only supports up to Postgres 9.5 and is itself no longer supported. You should upgrade to pgAdmin 4.

Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.