Types not exported/restored

From: BIBICO <bpvelonza(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Types not exported/restored
Date: 2008-07-11 02:12:05
Message-ID: 18395521.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support


I am trying to do a backup/transfer of database, and possibly the whole
server from one computer to another in a network using Pgadmin III included
in PostgreSQL 8.2. Tables were exported but nothing was exported in types.
Hence, some columns of the tables are missing, I've noticed that these are
tables having dependents in Types(which is missing) . Added to that, only
the public schema was exported and restored but not the other schemas. How
could I totally backup the whole database from one computer to another
completely?

I am new to using PostgreSQL and database as a whole and just starting to
learn.
I am dying for almost a week looking for the answer
Help please... Thanks :)
-these are the screenshots to better explain a novice like me :)
fist one is the screenshot of the db to backup, the 2nd one is incomplete
the restored db
http://www.nabble.com/file/p18395521/db_source.jpg
http://www.nabble.com/file/p18395521/db_restored.jpg

--
View this message in context: http://www.nabble.com/Types-not-exported-restored-tp18395521p18395521.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message sfmei2003 2008-07-11 05:11:58 Couldn't connect to database under Vista
Previous Message Dave Page 2008-07-04 08:32:45 Re: BUG ERROR: Raise Notice without line skip.