Skip site navigation (1) Skip section navigation (2)

Re: Types not exported/restored

From: BIBICO <bpvelonza(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Re: Types not exported/restored
Date: 2008-07-11 09:48:27
Message-ID: 18400275.post@talk.nabble.com (view raw or flat)
Thread:
Lists: pgadmin-support
First of all, thank you for your response, i deeply appreciate :)

The backup/restore process just went ok, no error message but some columns
of tables are not exported/restored. The Types at the 1st pic is 57 and the
restored one is 0. I have here the screenshots showing that some columns are
missing in the restored database.

http://www.nabble.com/file/p18400275/db_source.jpg 
http://www.nabble.com/file/p18400275/db_restored.jpg 

Another interesting output that i've tested ( since i'm going nuts figuring
things out), i installed PosgreSQL 8.3 on the source computer and restored
the database in question. What happened was, Types is also 0, but the
columns were complete! amazing! :) Im not so sure if the missing columns are
what we call foreign keys. This is the content of the dependent type(pls see
the grayed window in both pics). I'm wondering if this is the one causing
the problem or could be some other things...



Guillaume Lelarge-3 wrote:
> 
> BIBICO a écrit :
>> 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 
>> 
> 
> I don't think you're using the same version of pgAdmin. The first 
> screenshot shows system schemas in the Schemas node, and in the second 
> screenshot, there are in the Catalogs node.
> 
> Anyways, the first screenshot shows only one schema (public). All others 
> are system ones. They won't be part of a dump.
> 
> So I don't see any issue here. If you had errors during restore, please 
> show them.
> 
> Regards.
> 
> 
> -- 
> Guillaume.
>   http://www.postgresqlfr.org
>   http://dalibo.com
> 
> -- 
> Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
> 
> 

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


In response to

pgadmin-support by date

Next:From: Will LangfordDate: 2008-07-11 21:06:29
Subject: pgAdmin v1.8.4 editing binary data in 'view data'
Previous:From: Guillaume LelargeDate: 2008-07-11 07:26:46
Subject: Re: Types not exported/restored

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group