Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
postgre 8.1.1 backup and restor error
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Unsupported Software
View previous topic :: View next topic  
Author Message
Joseph_sys
Advocate
Advocate


Joined: 08 Jun 2004
Posts: 2571
Location: Edmonton, AB

PostPosted: Sun Sep 20, 2009 1:36 am    Post subject: postgre 8.1.1 backup and restor error Reply with quote

I just upgraded to postgresql-8.1.11 and when doing backup in sql-ledger and restore using command line I get errors:
Code:
...
INSERT 0 1
INSERT 0 1
INSERT 0 1
NOTICE: default for table partsgroup column id depends on sequence id
NOTICE: default for table project column id depends on sequence id
NOTICE: default for table employee column id depends on sequence id
NOTICE: default for table oe column id depends on sequence id
NOTICE: default for table ap column id depends on sequence id
NOTICE: default for table ar column id depends on sequence id
NOTICE: default for table parts column id depends on sequence id
NOTICE: default for table customer column id depends on sequence id
NOTICE: default for table vendor column id depends on sequence id
NOTICE: default for table invoice column id depends on sequence id
NOTICE: default for table chart column id depends on sequence id
NOTICE: default for table gl column id depends on sequence id
ERROR: cannot drop sequence id because other objects depend on it
HINT: Use DROP ... CASCADE to drop the dependent objects too.
ERROR: relation "id" already exists


Wnen I was restoring databases from postgresql 8.0 to 8.1 I get an error as well:
psql -d postgres -U sql-ledger -f dump_all.sql
You are now connected to database "template1".
psql:dump_all.sql:11: NOTICE: SYSID can no longer be specified

Anybody knows how to go about it? There is a hint on the end:
Use DROP ... CASCADE to drop the dependent objects too

How to implement this DROP CASCADE?
In the database I backup I can see:
Code:
...
--
DROP TABLE makemodel;
DROP TABLE gl;
DROP TABLE chart;
DROP TABLE gifi;
DROP TABLE defaults;
DROP TABLE acc_trans;
DROP TABLE invoice;
DROP TABLE vendor;
DROP TABLE customer;
DROP TABLE parts;
DROP TABLE assembly;
DROP TABLE ar;
DROP TABLE ap;
DROP TABLE partstax;
DROP TABLE tax;
DROP TABLE customertax;
DROP TABLE vendortax;
DROP TABLE oe;
...

_________________
#Thelma
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Unsupported Software All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum