Dumping Postgresql server version 13 not working #383

New Issue

Closed

opened 2020-12-19 16:18:31 +00:00 by Cludch · 2 comments

Cludch commented 2020-12-19 16:18:31 +00:00

Copy Link

What I'm trying to do and why

I am trying to dump a database on a PostgreSQL 13.1

Steps to reproduce (if a bug)

Try to dump a PostgreSQL 13.1 server / database.

Actual behavior (if a bug)

pg_dump: error: server version: 13.1 (Debian 13.1-1.pgdg100+1); pg_dump version: 12.4

Expected behavior (if a bug)

Should dump the database without issues

Other notes / implementation ideas

Dumping worked fine before I upgraded the DB server earlier.

Environment

borgmatic version: 1.5.12

borgmatic installation method: Docker container

Borg version: 1.1.14

Python version: 3.8

Database version (if applicable): 13.1

operating system and version: unRAID

#### What I'm trying to do and why I am trying to dump a database on a PostgreSQL 13.1 #### Steps to reproduce (if a bug) Try to dump a PostgreSQL 13.1 server / database. #### Actual behavior (if a bug) `pg_dump: error: server version: 13.1 (Debian 13.1-1.pgdg100+1); pg_dump version: 12.4` #### Expected behavior (if a bug) Should dump the database without issues #### Other notes / implementation ideas Dumping worked fine before I upgraded the DB server earlier. #### Environment **borgmatic version:** 1.5.12 **borgmatic installation method:** Docker container **Borg version:** 1.1.14 **Python version:** 3.8 **Database version (if applicable):** 13.1 **operating system and version:** unRAID

s1shed commented 2020-12-19 20:19:06 +00:00

Contributor

Copy Link

Your problem seems to be that you're using client binaries which are version 12.4 and with the server version 13.1. Are you able to dump the databases manually?

I haven't had any problems with borgmatic 1.5.12 and postgres version 13.

# pg_dump --version
pg_dump (PostgreSQL) 13.1 (Debian 13.1-1+b1)
# borgmatic --version
1.5.12

Your problem seems to be that you're using client binaries which are version 12.4 and with the server version 13.1. Are you able to dump the databases manually? I haven't had any problems with borgmatic 1.5.12 and postgres version 13. ``` # pg_dump --version pg_dump (PostgreSQL) 13.1 (Debian 13.1-1+b1) # borgmatic --version 1.5.12 ```

Cludch commented 2020-12-19 20:37:00 +00:00

Author

Copy Link

Oh, i didn't realize that pg_dump is bundled within the Docker image and not with Borgmatic.
Therefore, the issue is with the Docker image.
Thank you!

Oh, i didn't realize that pg_dump is bundled within the Docker image and not with Borgmatic. Therefore, the issue is with the Docker image. Thank you!

Cludch closed this issue 2020-12-19 20:37:03 +00:00

Sign in to join this conversation.

No Branch/Tag Specified

Branches Tags

main

spot-check

1.8.11

1.8.10

1.8.9

1.8.8

1.8.7

1.8.6

1.8.5

1.8.4

1.8.3

1.8.2

1.8.1

1.8.0

1.7.15

1.7.14

1.7.13

1.7.12

1.7.11

1.7.10

1.7.9

1.7.8

1.7.7

1.7.6

1.7.5

1.7.4

1.7.3

1.7.2

1.7.1

1.7.0

1.6.6

1.6.5

1.6.4

1.6.3

1.6.2

1.6.1

1.6.0

1.5.24

1.5.23

1.5.22

1.5.21

1.5.20

1.5.19

1.5.18

1.5.17

1.5.16

1.5.15

1.5.14

1.5.13

1.5.12

1.5.11

1.5.10

1.5.9

1.5.8

1.5.7

1.5.7.dev0

1.5.6

1.5.5

1.5.4

1.5.3

1.5.2

1.5.1

1.5.0

1.4.22

1.4.21

1.4.20

1.4.19

1.4.18

1.4.17

1.4.16

1.4.15

1.4.14

1.4.13

1.4.12

1.4.11

1.4.10

1.4.9

1.4.8

1.4.7

1.4.6

1.4.5

1.4.4

1.4.3

1.4.2

1.4.1

1.4.0

1.3.26

1.3.25

1.3.24

1.3.23

1.3.22

1.3.21

1.3.20

1.3.19

1.3.18

1.3.17

1.3.16

1.3.15

1.3.14

1.3.13

1.3.12

1.3.11

1.3.10

1.3.9

1.3.8

1.3.7

1.3.6

1.3.5

1.3.4

1.3.3

1.3.2

1.3.1

1.3.0

1.2.18

1.2.17

1.2.16

1.2.15

1.2.14

1.2.13

1.2.12

1.2.11

1.2.10

1.2.9

1.2.8

1.2.7

1.2.6

1.2.5

1.2.4

1.2.3

1.2.2

1.2.1

1.2.0

1.1.15

1.1.14

1.1.13

1.1.12

1.1.11

1.1.10

1.1.9

1.1.7

1.1.6

1.1.5

1.1.4

1.1.3

1.1.2

1.1.1

1.1.0

1.0.3

1.0.2

1.0.1

1.0.0

0.1.8

0.1.7

0.1.6

0.1.5

0.1.4

0.1.3

0.1.2

0.1.1

0.1.0

0.0.7

0.0.6

0.0.5

0.0.4

0.0.3

0.0.2

Labels

Clear labels   

bug

  

data loss

  

design finalized

  

good first issue

  

new feature area

  

question / support

  

security

  

waiting for response

No Label

bug

data loss

design finalized

good first issue

new feature area

question / support

security

waiting for response

Milestone

Clear milestone

No items

No Milestone

Assignees

Clear assignees

No Assignees

2 Participants

Notifications

Subscribe

Due Date

The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: borgmatic-collective/borgmatic#383

No description provided.