restore a Database Backup with PgDump with PgAdmin III

[hwd]

Hello,
i am trying to restore a Backup created with PgDump.saveToFile with PgAdminIII.
After Creating an empty database i tried the restore-function. No success.
Does not accept the file.
Opening the SQL-Window.
Loading the file: Wrong characters.
Pasting it:ok
Executing SQL: Error
Executing PSql Script seems to work but all indices's are back to 1
Database is unusable
It took forever.
A Backup Restore over PgAdmin takes about 3-5 min
The restore with PSql Script several hours.
What is wrong?
How should i proceed?

[QUERY ] CREATE SEQUENCE "tblwarehouse_bills_pages_BillPageID_seq"
[QUERY ] ALTER TABLE "tblwarehouse_bills_pages_BillPageID_seq" OWNER TO postgres
[WARNING ] SELECT pg_catalog.setval('tblwarehouse_bills_pages_BillPageID_seq', 1207, false)
FEHLER: Relation »tblwarehouse_bills_pages_billpageid_seq« existiert nicht
LINE 1: SELECT pg_catalog.setval('tblwarehouse_bills_pages_BillPageI...

look´s like something in the creation of the sequence fails.

Here is a sample of a line generated by your software:

Code: Select all

SELECT pg_catalog.setval('tblwarehouse_inventory_positions_InventoryPosID_seq', 35069, false);

And here the working version:

Code: Select all

SELECT pg_catalog.setval('public."tblwarehouse_inventory_positions_InventoryPosID_seq"', 35069, false);

Tested with pgAdmin III

[AlexP]

Hello,

Thank you for the information.
We have reproduced the problem.
We will try to fix it in the nearest product version.