search

pgadmin-org / pgadmin4

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
https://www.pgadmin.org
Other
2.53k stars 656 forks source link

Backup does not work with --format=d (RM #3309) #1811

Closed dpage closed 2 years ago

dpage commented 6 years ago

Issue migrated from Redmine: https://redmine.postgresql.org/issues/3309 Originally created by Khushboo Vashi at 2018-04-25 04:31:12 UTC.

When trying to take the backup with format=directory, it is failing.

dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3309#note-1 Originally created by Akshay Joshi at 2018-04-27 10:13:25 UTC.

Redmine ticket header update:

Name Old Value New Value
Sprint changed Ready
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3309#note-2 Originally created by Akshay Joshi at 2018-06-06 09:57:37 UTC.

Redmine ticket header update:

Name Old Value New Value
Sprint changed Ready EDB Sprint 16
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3309#note-3 Originally created by Khushboo Vashi at 2018-06-12 10:10:43 UTC.

Redmine ticket header update:

Name Old Value New Value
Status changed New In Progress
Assigned To changed Khushboo Vashi
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3309#note-4 Originally created by Akshay Joshi at 2018-06-20 09:36:41 UTC.

Redmine ticket header update:

Name Old Value New Value
Sprint changed EDB Sprint 16 EDB Sprint 17
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3309#note-5 Originally created by Khushboo Vashi at 2018-06-29 09:42:38 UTC.

Patch sent. https://www.postgresql.org/message-id/CAFOhELcmC_kJAtVuOUQ-yJhn559oMt_v0FwUX_d3vn_ZWFENuw@mail.gmail.com

dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3309#note-6 Originally created by Dave Page at 2018-06-29 14:13:53 UTC.

Redmine ticket header update:

Name Old Value New Value
Fixed Version changed 3.2
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3309#note-7 Originally created by Khushboo Vashi at 2018-06-29 14:14:42 UTC.

Applied in changeset commit:fb1ef9ac0b1cd7598fce545b656ce23b97e3f1e1.

Redmine ticket header update:

Name Old Value New Value
Status changed In Progress In Testing
Done Ratio changed 0 90
dpage commented 6 years ago

Image migrated from Redmine: https://redmine.postgresql.org/attachments/download/3111 Originally created by Fahar Abbas at 2018-07-03 04:53:33 UTC.

Screen_Shot_2018-07-03_at_9.14.20_AM.png

Filename: Screen_Shot_2018-07-03_at_9.14.20_AM.png

dpage commented 6 years ago

Image migrated from Redmine: https://redmine.postgresql.org/attachments/download/3112 Originally created by Fahar Abbas at 2018-07-03 04:53:33 UTC.

Screen_Shot_2018-07-03_at_9.14.34_AM.png

Filename: Screen_Shot_2018-07-03_at_9.14.34_AM.png

dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3309#note-10 Originally created by Fahar Abbas at 2018-07-03 04:55:12 UTC.

This issue is fixed on MAC OS X while issue is not fixed on Windows 2012R2 64 hence reactivating the issue.

Running command: C:\Program Files (x86)\pgAdmin 4\v3\runtime\pg_dump.exe --file --host "localhost" --port "5432" --username "postgres" --no-password --verbose --format=d "postgres"

Start time: Tue Jul 03 2018 09:25:06 GMT+0500 (West Asia Standard Time)

pg_dump: [directory archiver] no output directory specified

Redmine ticket header update:

Name Old Value New Value
Attachment added Screen Shot 2018-07-03 at 9.14.20 AM.png
Attachment added Screen Shot 2018-07-03 at 9.14.34 AM.png
Status changed In Testing New
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3309#note-11 Originally created by Fahar Abbas at 2018-07-03 05:18:47 UTC.

Commit ID: commit e802f2db64307546332e54cb47942022cea08202

dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3309#note-12 Originally created by Akshay Joshi at 2018-07-04 09:36:55 UTC.

Redmine ticket header update:

Name Old Value New Value
Sprint changed EDB Sprint 17 EDB Sprint 18
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3309#note-13 Originally created by Dave Page at 2018-07-10 12:11:41 UTC.

Redmine ticket header update:

Name Old Value New Value
Status changed New In Testing
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3309#note-14 Originally created by Dave Page at 2018-07-10 12:27:24 UTC.

Redmine ticket header update:

Name Old Value New Value
Status changed In Testing In Progress
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3309#note-15 Originally created by Khushboo Vashi at 2018-07-11 07:04:39 UTC.

Redmine ticket header update:

Name Old Value New Value
Status changed In Progress New
Assigned To changed Khushboo Vashi
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3309#note-16 Originally created by Akshay Joshi at 2018-07-16 12:49:40 UTC.

Redmine ticket header update:

Name Old Value New Value
Status changed New In Progress
Assigned To changed Akshay Joshi
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3309#note-17 Originally created by Akshay Joshi at 2018-07-17 08:54:12 UTC.

Patch sent: https://www.postgresql.org/message-id/CANxoLDca87eGeNhSSB5Lvmj6Sj2ucnPhCvcarnCcsbt02G6dGg@mail.gmail.com

dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3309#note-18 Originally created by Akshay Joshi at 2018-07-17 12:13:35 UTC.

commit-id: 1fc82d328c974d743f8591633afce6717d5a8d88

Redmine ticket header update:

Name Old Value New Value
Status changed In Progress In Testing
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3309#note-19 Originally created by Fahar Abbas at 2018-07-17 13:56:31 UTC.

commit 7f7feee8c1afb28ceb0a8d39273f2da4eb276a6a

Windows(Python 2.7.14)

Redmine ticket header update:

Name Old Value New Value
Status changed In Testing Resolved
Done Ratio changed 90 100
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3309#note-20 Originally created by Raffaele Sgarro at 2018-07-22 09:18:38 UTC.

Directory format doesn't seem to work neither for backup nor for restore. Have you ever simply tried to backup a database with the directory format and restore it?

dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3309#note-21 Originally created by Khushboo Vashi at 2018-07-22 11:58:07 UTC.

This was not working, so the issue has been created and fixed. In the next release this fix will be available.

dpage commented 2 years ago

Issue closed on Redmine.