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 ex****ted but nothing was ex****ted 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 ex****ted 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.jpghttp://www.nabble.com/file/p18395521/db_restored.jpg
--
View this message in context:
http://www.nabble.com/Types-not-ex****ted-restored-tp18395521p18395521.html
Sent from the PostgreSQL - pgadmin sup****t mailing list archive at
Nabble.com.
--
Sent via pgadmin-sup****t mailing list (pgadmin-sup****t@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-sup****t
